API

Since upgrading from Sage 200 2011 to 2016 earlier this month, we've lost some really useful functionality that allows us to flexibly work with sales orders in Workspaces. Previously there were various filter options/criteria on each column header...

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...

Currently to export a price file you can only export all the prices, it would be good to be able to select an individual or group of products groups to work on, similar to exporting stock items

The standard Traceable Opening Balance Import does not allow multiple cost prices for the same stock code, this is very troublesome and can cause a lot of additional manual work. I had a site that recently went live and had spent a long time prepa...

The ability to import standard costs within the stock module

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...

When importing stock items the stock unit is currently drawn from the product group. As it isn't possible to change the stock unit it should be possible to specify this for each item in the import file.

Currently if you need to perform a large update of sales prices - the easiest option is to use the Export Prices option, modify the CSV/EXCEL and use Import Prices to import the modified CSV to update the prices. This works fine on a small scale, ...

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...

Useful when many other stock items are used in BOM or manufacturing (but not the finished item to sell !)