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...
At the moment you can only delete lines from the journal template, so if you have a template with multiple lines it can be quite time consuming to add a line in in the middle. Could functionality to move lines up or down possibly be added in? Than...
Imrie, William
over 6 years ago
in Journal Templates
0
Idea Accepted - Gauging Support
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
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...
It would be so beneficial to have capability for people to use a template in excel and upload journals in to Sage, rather than sitting within Sage and typing everything out in to the Journal. This would be beneficial especially at year end when ex...
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
