Note that when using importing data a lot of the filed are not required as they are calculated on the fly according to the normal sage rules for data entry.
In various place sage uses Status Codes and Values these are detailed here
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.
Record numbers are generally used when updating existing data to select the transaction to update, they are not "Sage" fields but pseudo fields created to allow easy updating of records.
Pseudo tables are creates for the BOMS and Scheme Discounts to make importing easier, there are no exports for these
Sample csv's and xmls are a straight dump of the demo data in headed csv and xml format respectivly.
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 things are always being added and occasionally changed.
In addition there are native data table structures that we can write custom dictionaries to access.
Pay as you go Sage 50 Support, Data repair, Sage Reports, Excel- Sage 50 Data Links and Reports, 3rd Party integration and more!
Copyright © Making I.T. Happen 2017