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
about 2 years ago
in Excel Reporting
4
Idea Accepted - Gauging Support
It would be useful if we could add more customer contact details, within a company there may be several contacts, such as workshop supervisor, purchase ledger clerk, but there doesn't seem the capacity to enter this detail in sage
Sally Bruce
over 2 years ago
in Customer/Supplier
6
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 the new Nominal Analysis Codes to all related Reports, Workspaces, BI and Excel Reporting
Please add the ability to report on the new Nominal Analysis codes in Sage 200C to all related reports, Workspaces, Excel workbooks and BI. It would be useful to analyse Nominal transactions and Accounts by these new codes. I have a few customers ...
Excel Reporting to data criteria & increase maximum rows limit
Excel reporting has the potential to be very useful, there are 2 limitations that make is not so useful. 1. There is an upper limit of 1 million rows, whilst this may appear to be a high number it is nowhere as high as can be seen in some SQL tabl...
Ability to identify Customers and Suppliers as Counterparty transactions and report on this for Annual Accounts Return
Academies are required identify transactions between the trust and other public bodies (Counterparties) and report these in the Annual Accounts Return each year. It would be really useful to tick a box or select a drop down on a customer or suppli...
Guest
over 8 years ago
in Customer/Supplier
0
Idea Accepted - Gauging Support