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 53

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

Expand Cashbook trans. type or use a dropdown function (Y/N) for 1st Reference field and if Y, creating a fix reference in the dropdown

When receiving customer payments or paying suppliers, the methods in how this take place is limited and should be record as such. The following types can take place, CASH, DD (direct debit), SO (stop Order), C/Card (Credit card), BACS, Transfer, C...
Marek Tonderys almost 2 years ago in Payment/Receipt 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 6 months ago in Excel Reporting 1 Further Information Required

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

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

Allow the facility to include bank charges to receipts into sterling account from foreign accounts.

Currently you are able to post bank charges as part of the receipt on foreign currency bank accounts. Why is this not possible on sterling accounts when monies have been received from overseas.
Guest over 3 years ago in Payment/Receipt 0 Idea Accepted - Gauging Support

Clone or Template Receipt

It would save me a huge amount of time if I could clone a receipt or create a receipt template. As a school we receive weekly income for several different departments/nominals and it is time consuming to select all the codes each time we input the...
Guest over 5 years ago in Payment/Receipt 0 Idea Accepted - Gauging Support

Change bank code whilst entering a payment in Cash Book module

Can I suggest that you allow the bank code to be changed during a payment/receipt entry. Currently the bank code is greyed out as soon as you start to enter the lines of a payment/receipt in cash book module, it would be good if you could change t...
Guest over 6 years ago in Payment/Receipt 0 Idea Accepted - Gauging Support

Amend default cashbook/bank account for Customer & Supplier Accounts!

To have an extra option, perhaps for admins only where you can amend the default bank account in cashbook so it updates for customers and suppliers.
Guest almost 8 years ago in Payment/Receipt 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 ...
Guest about 8 years ago in Business Intelligence / Excel Reporting / Workspaces 0 Idea Accepted - Gauging Support