Skip to Main Content
Sage 200 UKI Ideas Portal
ADD A NEW IDEA

Excel Reporting

Showing 21

Nominal Transactions Excel Report Glitch

Hi, I have identified an issue with the Nominal Transactions Report in Excel reporting when you pull this off the reports section for us as we have been with Sage just over 2 years so on this report it shows Current Year, Last Year 2 Year but when...
Guest over 4 years ago in Excel Reporting 1 Not an idea

Ability to create an Excel Workbook based on any area within Sage 200

I frequently have to create SQL Views via an ODBC link in Excel to get additional Excel based reports. Please provide a method to create our own reports and allow these to be linked to most if not all areas within Sage 200 including Project Accoun...
Guest over 7 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Financial Data Designer to have the same functionality as Amend Financial Layouts

eg Subtotals so that you can show Gross Profit, Operating Profit, EBIT, Net Profit etc Text lines to put spacing in the report At the moment you have manually add a total in the Pivot Table settings for Net Profit etc ...
Saeed Malik over 6 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Excel Reports - organisation

Can you create a system so we can organise the excel reports - we currently have a long list of reports and it can be hard to find the one you want. A folder system would be useful.
Guest over 6 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Department budget vs actuals summary

A report in excel that produces a one line summary of budget vs actuals for a specified month and YTD. The report should include totals and full department names to make it as useful as possible. As a school the majority of our internal management...
Guest almost 7 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 7 years ago in Excel Reporting 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 7 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

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 7 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

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 about 1 year ago in Excel Reporting 1 Further Information Required

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 about 1 year ago in Excel Reporting 0 Idea Accepted - Gauging Support