Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration Solution - Sage 50 Tables & Field details.

Note that the internal names of the data sets are the same as used in the report designer and ODBC, Customer Ledger is called Sales Ledger and so on.

Some field name are obscure, the Line information on an order item is called Job Reference, the Order Number is sometimes called Invoice Number and more.

In addition to these main tables, we can read and write to all the other tables in Sage 50 

Record numbers are generally used when updating existing data to select the transaction to update.

Sample csv's are a straight dump of the demo data from V2009 in headed csv format.

The powerful interpreter with the product is quite capable of extracting information from complex structures like printed invoices that have been saves as text files as well as data from a wide range of other source such as csv, headed csv, xml, MS access mdb, excel spreadsheets, any ODBC source, pipe delimited, emails, ftp server, web servers. We have even done strange mashups of pipe delimited embedded inside csv's!

Not all fields are available in all versions of Sage 50  

Accounting, Pay as you go Sage 50 Support, Excel Reports, Sage Reports, Sage 50 3rd Party integration and more!

This Sage 50 import website is copyright Making I.T. Happen 2022