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 32

    Excel Add On to refresh reports on to a tab within Excel (formulas set up for analysis)

    It would be great to be able to install an Excel add on that allows you to refresh a report within Excel, rather than refreshing within Sage 200 and exporting the report again. SAP by design has this feature and we could add formulas to the left h...
    Jenny Jose 13 days ago in Excel Reporting 2 Idea Accepted - Gauging Support

    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 about 2 years ago in Excel Reporting 4 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

    Purchase Order - e-mailed status

    Like there is for Print Status in POP a column to show that it has been e-mailed. These days it is e-mailed more than printed and the print status updates to PRINTED even if just previewed so need a separate column for E-mailed.
    David Shearer over 4 years ago in List 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

    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 almost 2 years ago in Excel Reporting 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 8 months ago in Excel Reporting 1 Further Information Required

    There needs to be a column on purchase order list saying 'goods received'or 'booked'

    There needs to be a column on purchase order list saying quot; goods received quot; or quot;booked inquot;
    Guest over 2 years ago in List 0 Idea Accepted - Gauging Support

    Purchase Orders not showing as Complete when Over Invoiced

    In Sage currently, it is possible to over-invoice on a Purchase Order. So in POP, a Purchase Order could have a line with quantity of 100,100 are then receivedand then a Purchase Invoice is recorded with a quantity of 150. When amending the Quanti...
    Guest almost 11 years ago in List 0 Idea Accepted - Gauging Support