Making I.T. Happen
The Sage 50 import process V2010 (V16) and earlier
1/ Make sure that the CSV data is valid and complies with the rules
2/ Get the fields in the right order There are a lot of field in the different tables the link will show you them all. Unfortunately Sage changed the layout several times and it is best to consult the help file in your program to be sure you have the right order for the fields.
3/ Run the Import process in Sage 50, this is a two part process,
Sage runs a test the first time and if everything is okay it does a second pass, during which it import all the data into sage 50. The process is ALL or NOTHING, if it fails on one record all the records will fail to import.
4/ Fix any problems highlighted by the import. It is quite possible that you have missed something even though you were really careful with your data preparation, so be prepared to go back fix mistakes and run step 3 again.
Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!This Sage 50 import website is copyright © Making I.T. Happen 2017