Sage 1000 API
Develop with Sage 1000
A preferred programming interface.
Interact with Sage line 500 and Sage 1000 ERP using any .Net or COM compatible language, including VB.Net, C#, C++, F# and VB6. Codis' Sage API demands only the minimum data required for an operation while optionally allowing extra data to be provided. Default values are automatically calculated when required and an optional transaction size can be set at batch or item level. All data is validated, including cross referencing to existing Sage data. Validation can also be done independently of posting any data.
This API lets you interact with key Sage modules including sales invoices and credit notes, sales cash, purchase invoices, general ledger journals, payroll timesheets and customer creation.
Table import facilities
Import Sage data programmatically.
When importing data into a Sage table using our Sage API, not all column names need to be defined - default values will be generated. A log file with five available logging levels is updated showing details of the import and any errors encountered. Imports into Sage can optionally be set to avoid using complete batches, ensuring that should a transaction within the batch fail validation, the remaining transactions write a valid batch in Sage. The batch number is written back to the original source table, providing a full audit trail from source to target and vice versa.
You can use "processed" flags on the source table, ensuring that records are only marked as processed once the relevant Sage transaction is validated and successfully written to the database. These import facilities are available as Microsoft DTS components, allowing integration into Microsoft DTS scripts.