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...
Allow multiple Excel reports to be updateable/ viewable
Within Excel reports there is a check box column down the left side allowing selection of multiple reports. Current functionality greys out the Update and View buttons when more than one report is selected. Could the check boxes be removed to less...
Guest
about 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
When creating the Balance Sheet in the excel reporting area, all PL AND Balance Sheet reporting categories are shown, it would be much more efficient if the B/Sheet behaved like the old style financial statement layouts and could have the system g...
Guest
almost 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
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 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
Within the the nominal account - account settings, have the ability to change all three fields relating to the "Report Category". Thus ensuring accurate reporting directly from sage 200 and not exporting the data into another software and then rep...
Marek Tonderys
about 2 years ago
in Settings
4
Not an idea
Have a parameter in each module to make the cost centre and / or department mandatory for the nominal postings. This will ensure that postings are more accurate and errors eliminated.
Guest
about 11 years ago
in Settings
0
Idea Accepted - Gauging Support
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...
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 7 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
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
almost 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
