Analysis reports - date filters
Currently, it's not possible to add a date or date range before viewing the matrix for: Inventory analysis report Sales analysis report Purchase analysis report It would make the matrix much more use-able if dates could be added, to be able to produce a matrix for a specific reporting month for ...
Publish more data for PowerBi, specifically for Dimensions report
We would like to be able to do reporting in PowerBi on Dimensions. Currently, the dimension set ID field from table 20 is not published on page 20 that we can publish to PowerBi.
This would make reporting much easier with Excel and PowerBi.
Dynamic Filters for Reports
In Pages it's possible to use dynamic filters like %MYCUSTOMERS to create views that support users with "their" data. The advantage is the flexibility of the filter range - it's always up to date. If I use the same filter in a report (created by a job queue entry or using a report filter templat...
Schedule reports - Send by email and multiple users
Ability to schedule a report to :
- Send it by email
- Send it to single, multiple or all users
Reports Due for Reworking
Top Sales Document Reports that are due for reworking: - 117 Reminder - 204 Sales - Quote - 205 Order Confirmation - 206 Sales - Invoice - 207 Sales - Credit Memo - 208 Sales - Shipment - 780 Certificate of Supply - 6631 Return Order Confirmation Top Purchase Document Reports that are due for re...
Business Central Team
Query Tool/Wizard
It will be great to have ability to create Queries, linking multiple tables in the 'front end' that could be "published" and then used in Excel, etc. to create reports, pivots.
Account Schedule - Smart Column Captions
Currently, Account Schedules are limited to static captions such as "Current Period" or "Prior Period"
The reports would be more readable if the Column Captions could be "smart" and display either the Date Filter being applied to the column or resolve to the Month / Period caption...
User Defined Fields on Tables
Report Extensions are something many want but may be technically challenging. How about introducing a set of user defined fields on certain tables (or all) which can be populated as the client wishes via customer extensions. These fields can then be exposed in the dataset and used if required. Th...
Analysis View export to Excel is no longer a Pivot Table
I just wanted to demo the Analysis View export to Excel and saw that the Excel sheet is no longer a Pivot Table. Will that return?
Allow the ability to exclude fully paid documents from customer statements
It would be nice to be able to exclude fully paid documents from customer statements. Statements should be able to be generated on the amounts that are outstanding with the option of excluding documents that are fully paid.
Administrator
Best regards,
Business Central Team