To integrate with Sage 200 Online using Zynk you will need to import and export data using XML. The field names and types used are the same as the Sage 200 Online API Documentation, but are in an XML format rather than JSON
The format for downloading and uploading are the same for each record type, but there are certain fields that only used when creating a record for the first time, updating an existing record, or when downloading a record. These are highlighted on each page, along with the data types and field length restrictions.
Sage 200 Online Country Code XML
All countries each have a specific code to identify accounts that belong to that country.
Sage 200 Online Currency XML
Sage 200 works in multiple currencies and each company can configure up to 99 currencies to use., and all can be configured to use a single exchange rate, period exchange rates, or both. One currency must be configured as the base currency and this cannot be changed once transactions have been entered.
Sage 200 Online Customer XML
Customers are one of the most important entities within Sage 200 as they are associated with many important resources within the application and underpin most of the main features (e.g. sales orders, payment receipts, etc).
Sage 200 Online Sales Order XML
Sales orders are used to represent the sale of goods or services to a customer. They are central to a business and define the terms (price, quantity and times) by which the products or services will be delivered.
Sage 200 Online Sales Receipt XML
Receipts are used to record a sales receipt against a particular customer’s account.
Sage 200 Online Sales Transaction XML
Sales posted transactions are created when transactions, such as orders invoiced, receipts, refunds or credit notes, are posted against the sales ledger.
Sage 200 Online Stock Level XML
All stock within Sage 200 regardless of type (Stock, Service/labour, or Miscellaneous), require a holding location. The location indicates where an item is stored and the stock level settings for each product in the warehouse i.e. the re-order level, the minimum and maximum stock levels. Items with a type of ‘Stock’ have levels recorded for each warehouse location and the levels are used when allocating, issuing and receiving stock.
- Exporting Stock Levels from Sage 200 Online
- Exporting Stock Records From Sage 200 Online
- Importing Stock Records To Sage 200 Online
Sage 200 Online Stock Record XML
Products are used to track stock within Sage 200. This is not just for physical items, but also for items that are ordered direct from suppliers, services, and time or labour that can be included on customer invoices. Each stock item has default settings that are used each time the item is bought or sold. Some of these are inherited from the product group and some are set on each item.
Back | Edit on Github