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 42

Improve Excel VAT Transactions Report

The current VAT Transactions report (Excel) records the VAT on Sales Invoices as a positive amount, rather than as a negative amount and Sales Credits as negatives instead of positives so that the cumulative total differs from the VAT return. Can ...
David Waller almost 2 years ago in Excel Reporting 4 Idea Accepted - Gauging Support

The ability to select which budget you're reporting against when running financial statements

We set a budget for the start of the financial year. I'm sure plenty of other companies then do a re-forecast. Some might do it after Q1, some may re-forecast every quarter for example. It would be incredibly helpful if we could select the budget ...
John Wilkins about 2 years ago in Budgets 0 Idea Accepted - Gauging Support

Add narrative column to excel report Supplier Transactions

I would find the Supplier Transactions report, which can be found in the excel reports, much more useful if a column showing the narrative was included. When processing invoices we leave the default narrative, which includes the supplier code and ...
Guest almost 3 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Excel Reporting - Revenue and Cost report: flip sign on budgets

A client is using the Excel Revenue and Cost report to extract budgets and actuals from Sage 200 for reporting. The actual values are signed flipped, so that the revenue credits are displayed as positives and the cost debits as negatives. Budgets,...
Gregor Imrie over 4 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Sage 200 web users able to drill down into budget line details

We have rolled out "My Budget Overview" access to our managers for keeping more up to date view on budget spend than monthly management accounts allow. However it would be useful if the figures in actual/committed POs/etc columns were able to be d...
Jo Clarkson over 6 years ago in Excel Reporting / Roles 0 Idea Accepted - Gauging Support

Add Excel Pivot on Invoicecredit and Invoice Credit Line

Useful to bolster existing trading reports e.g. if stock updated by despatch date then such trading information is unavailable.
Owen Orr 7 months ago in Excel Reporting 1 Further Information Required

Export / Import Excel Financial Statements

To have the ability to export and import your Excel financial statement layouts like you can with the main ones. Seems mad that you can't already.
David Shearer over 1 year ago in Excel Reporting 0 Idea Accepted - Gauging Support

Budget Monitoring in New Year when Old Year is still open

The ability to run a budget v actuals report for the new year, when the old year is still open would be very helpful. I have not been given the go ahead to close old year by our accountants. This means I am unable to produce any meaningful budget ...
Guest about 7 years ago in Budgets 0 Idea Accepted - Gauging Support

I would like to maintain multiple versions of my nominal budgets

Throughout the course of the year my budgets are often revised. When I amend the budget I would like to keep a copy of the original budget and also see the new budget. I would also like this to be reflecting in report so I can see original
Guest almost 9 years ago in Budgets 0 Idea Accepted - Gauging Support

Budget audit trail

It would be really useful to be able to view an audit trail of budgets for an individual nominal code/dept - to be able to see original budget, changes up / down since then with current budget showing as a result of these changes. Vital for the ed...
Guest almost 5 years ago in Budgets 0 Idea Accepted - Gauging Support