82

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 ...

Read more...

4 Comments

Read more... 4 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team
82

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.

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Completed
Ideas Administrator
Completed in a previous release

Best regards, Business Central Team
76

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...

Read more...

1 Comments

Read more... 1 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap. 

Your help is greatly appreciated, 
Mike Borg Cardona
Program Manager, Microsoft  
74

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

 

 

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We need some more details to understand your suggestion better. Can you please help us by answering the following questions?
From the suggestion we feel the request is targeted at internal users only? Is that assumption correct? You are saying schedule and send email to USERS.
Is there an expectation to enumerate specific reports as for internal use only, e.g. they cannot be sent outside of the company, or they can be sent but to specific list of whitelisted contact (e.g. extenal accoutant)?

 ​
Sincerely,​
Ivan Koletic
PM, Microsoft​

64

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...

Read more...

7 Comments

Read more... 7 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for this suggestion! We are adding this to our longer term roadmap.

Best regards,
Business Central Team
64

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.

Read more...

5 Comments

Read more... 5 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Planned
2020 Release Wave 2
Ideas Administrator
Thank you for your suggestion, this is something we are looking at for a future release.  
 
Jennifer Ranz
Sr. Program Manager
64

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...

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Needs Votes
60

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...

Read more...

5 Comments

Read more... 5 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. 

Best regards,
Business Central Team
56

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?

Read more...

3 Comments

Read more... 3 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Declined
Ideas Administrator
Thank you for your feedback. 

We won't be investing in adding this feature back. It was removed due to some technical limitation with libraries.

Going forward we will be looking to PowerBI for analysis and visualization capabilities.


Brian Nielsen, Program Manager
55

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.

Read more...

6 Comments

Read more... 6 Comments

Category: Reports and Business Intelligence (250)

STATUS DETAILS
Needs Votes