Sage Importing from 3rd Party Software

Sage Importing from 3rd Party Software

Didn't find your answer?

Does anyone know if there is a cheap bit of Software on the market (or has anyone written a piece of software) to allow Purchase and Sales Invoices to be imported into Sage from third party software. We know SageLink is there at an astronomical charge and equally know that there is an import facility within Sage but this only allows for PI and SI details.

Any comments would be gratefully allowed.
Bruce Rose

Replies (5)

Please login or register to join the discussion.

avatar
By brucier
17th Oct 2005 13:53

FAO Martin
Hi Martin - I'm still playing with CSV files but Sage isn't very explicit in giving an actual example. If you pick this comment up, would you be able to give me a working example?
Much obliged.
Bruce

Thanks (0)
avatar
By User deleted
21st Oct 2005 12:38

Try the following steps .....
Steps
- export your data from the 3rd party package into CSV (Comma Separated Variable) format
- load export data to Excel/Supercalc/Lotus (any spreadsheet)
- get import data structure from Sage Help file (search: csv & select Audit Trail)
- get rid of any surplus columns not required by the Sage import & put the remaining columns in the right order (to be on the safe side)
- save out as csv; in Excel-->Save As-->CSV
- run Sage; File-->Import-->Audit Trail

Potential Problems
- 'Lookup' tables need to exist prior to importing for
- sales/purchase/bank a/c ref
- nominal
- department
- VAT code (T1...T9 etc)
- the 'Lookup' ID's must match the equivalent being imported

Caveats
- back up your SAGE data files before importing

Thanks (0)
avatar
By User deleted
15th Oct 2005 08:52

Sage importer
I have not used this software, so I could not give a recommendation, however it does offer a free trial.
http://www.import2sage.com/
I hope this helps

Thanks (0)
avatar
By martin.truroglass
15th Oct 2005 09:36

No software needed...
You can quite happily import into Line 50 without the need for additional software. If your third party software can export the required information in a CSV file, then you can import it into Sage using File, Import, Audit Transactions. From within Sage using help will tell you the file structure that Sage uses. Needless to say, follow a strict routine when doing this, make a note of the number of transactons from the CSV file and add them to existing Sage audit trail number and ALWAYS back-up first! No other users can be logged into Sage when carrying out this procedure.

Regards

Martin

Thanks (0)
avatar
By brucier
15th Oct 2005 12:56

Thank you
Many thanks for your replies .....I will attempt to try this out.
Bruce

Thanks (0)