Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

ADD A NEW IDEA

Clear

Ideas

Showing 73

Excel Reporting (Date/FY) FiIters before opening excel

Some clients, with years + years worth of data, and as such, the functionality to amend the pivot tables, create new graphs etc.. and re upload into Sage to be used next month is not available as the file size is too big. The function to amend and...
Guest almost 8 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Excel Financial Report Pack to have values for Budget for the Year & Forecast for the Year

Budget for the Year & Forecast for the year are key values for financial analysis, these are not currently available in the Pivot Table Field list
Saeed Malik about 8 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Allow selection of Product Group, Stock Codes and Price Bands when Exporting Prices to CSV

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, ...
Paul Daly over 8 years ago in Stock 0 Idea Accepted - Gauging Support

allow additional fields to be added to excel reporting reports

client would like to add the user field to excel reporting report cashbook transactions but not on the list of fields available in the pivot table tools analyse section
joanne scott over 8 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Endpoints relating to dbo.StockItemPeriodBalance

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...
Guest almost 6 years ago in Stock 0 Idea Accepted - Gauging Support

Add the Allow SOP flag to the stock import for Sage 200

Useful when many other stock items are used in BOM or manufacturing (but not the finished item to sell !)
Nigel Smith over 8 years ago in Stock 0 Idea Accepted - Gauging Support

Opening balances for phantom stock

Phantom Items - At the moment stock balances can be entered for Phantom items via the standard import routine. However if you do this by mistake there&s no way to remove the stock quantities. The stock opening balances routine should stop you ...
Guest almost 10 years ago in Stock 0 Idea Accepted - Gauging Support

Validation option in Sage 200 Standard using RESTful data service

At the moment, there is no option to validate the REST request. It would be a great addition/feature to your product.
Guest over 2 years ago in API 2 Further Information Required

Excel Reporting for Sage 200

Report directly from excel to help analyse the data in a more in depth manor and in line with existing processes
Guest over 2 years ago in Excel Reporting 2 Already Exists

To be able to drill into Committed costs on Nominal Outturn Report

Logging on behalf of a customer who cannot access Ideas Hub. The Nominal Outturn and Nominal Outturn by report category shows committed costs of Purchase Orders received but not yet invoiced, via Excel Reporting. You can drill into this to see the...
Guest over 2 years ago in Excel Reporting 0 Idea Accepted - Gauging Support