API

I have discovered that it is impossible to filter by certain 'calculated' columns on the API, particularly on the sales_posted_transactions endpoint. The following API call with a filter to return only Sales Receipts works successfully... /v1/sale...

Unfortunately in the current Sage 200 Professional API there doesn't appear to be an endpoint that would provide an approximation of the data stored in dbo.StockItemPeriodBalance. Altough these tables have great data within them. One example,of Pe...

Please support Analysis Codes in your API so we can enter them in Paperless against invoices/credit notes, which would greatly reduce our time spent amending individual transactions in Sage and improve our reporting.

I have a large amount of stock transactions to import, Adding to Stock or 'Writing off' as a result of stock taking. We cannot use the Stock taking facility because of it's limitations in not reading a retrospective date for the Stock level, just ...

Hi, Would it be possible to add the postal_name field to the Sop_orders_delivery_address endpointas a POST/PUT field. Sage 200 field PostalName in SopDocDelAddress. Thanks

This functionality exists in Sage 200 SDK(The same as in Sage 50), and our customers really would like to continue to use it in Sage 200 Standard. I'm sure it shouldn't be a big task because API is based on Sage200 SDK. We really need. Thank you, ...

Imports - Update -further improvements to the update of stock records as outlined below. Adding / removing suppliers to a stock record Adding / removing locations to a stock record Adding BOM details to a stock record - e.g. can specify that the i...

One to save some time, if you could export and import Search Categories/values, then this would save a whole heap of time because if you're moving the contents to another database then you can save the details to SQL using a script but you have to...

You can import Product Groups, much like stock items, and they can be a complicated structure with all of the Search Categories, Batch/Serial settings and what not, but you cannot Export them. This is useful if you are moving Product Groups to oth...

When you import stock records, you have to enter the nominal codes for the item even though you're selecting the product group - which already has the nominal codes on. There should be a tick box at the least for it to use the standard Product Gro...