19

Filter out closing entries

It would be nice to exclude closing entries from financial reports when using a date range that crosses over year end. This functionality exists on "G/L Balance by Dimension", but it is not present in Account Schedules or other financial reports. On the flow field filters, it would be nice to ent...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Needs Votes
19

Document Map & Online Sorting in Preview Mode

It would be very nice, if the document map and online sorting functionality in report previews would be available in the webclient.

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for your feedback. Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future. Sincerely, Business Central Team
17

Hold active filter in Power BI Report when selecting "Expand Report" in Power BI factbox

If you have an Power BI report on a list, for example the item list and the Power BI filter on all pages is set to item no. in the factbox of the itemlist it shows the Power BI report filtered on item no. When selecting on the Power BI report > Expand Report, the system opens the Power BI report ...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for this suggestion! 
This is already fixed in production in the newest version of the product.
Best regards, 
Business Central Team
17

Aged Accounts Receivable/Payable Report Selection

I would like to be able to choose which report is printed, for the Aged Accounts Receivable and Aged Accounts Payable report, either Report IDs 120 and 322 or Report ID’s 10040 and 10085. These two reports offer users different functionality and having the ability to use either would be extremely...

Read more...

1 Comments

Read more... 1 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Needs Votes
17

Enable Custom APIs for use with PowerApps

It is possible to consume standard MS created API's with PowerApps. It is also possible to create an API page as an extension and publish it to Business Central. I would like to have these custom API's available to use with PowerApps. We have currently customer cases where we need for example ...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in 2021. 
Please refer to the following link for more information: 
 
Sincerely, 
Blazej Kotelko
PM, Microsoft 

16

Date Filter for report "Vendor - Balance to Date"

The date filter in report "Vendor - Balance to Date" shows only data up to and including the upper-limit of the date filter. If there is no Date filter, this means the report will run only for "Vendor - Balance to Date", however, it is common practice across the globe that you quote aging to yo...

Read more...

0 Comments

Read more... 0 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Needs Votes
16

Parent vs. Child Report Logic in Document Layouts

We email a Confirmation Order for every sales order by specifying the Send To Email address in the DOCUMENT LAYOUTS for each customer. For most customers, this works exactly as expected and Confirmation Orders go to the address specified. However, we also have several “child” customer accounts w...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (258)

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
16

Dynamically Update M Account Schedules

Suggestion: Creating a dynamic account schedule that updates when new accounts are added, or modified based on their account subcategories Currently in Business Central: We are able to generate the M Account Schedules based off of the account sub-categories. Each time an account is added or modi...

Read more...

2 Comments

Read more... 2 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your feedback. We released this feature as part of the functionality in Control how Account Schedules for core financial reports are generated in 2020 Release Wave 2.

Please refer to the following link for more information:
https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/control-how-account-schedules-core-financial-reports-are-generated

Sincerely,
Business Central Team

16

Inventory valuation - limit totals

Currently, it's not possible to run the inventory valuation report and limit totals to: Bin Global dimensions Location Lot No Serial No Variant This is a really big shortcoming, especially for the location limit. This is available in NAV, and really needs to be available in BC.

Read more...

1 Comments

Read more... 1 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2019 release wave 2.  
Learn more about what's new and planned for Filtering reports more efficiently in the release plan here: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/powerful-filtering-capabilities-reports

Your help was greatly appreciated,  
Business Central Team

16

API - Expose remaining/open amounts of Salesinvoices

https://docs.microsoft.com/en-us/dynamics-nav/fin-graph/resources/dynamics_salesinvoice When a customer makes a partial payment, the remaining amount of the sales invoice is not returned via the API. Request: Return the remaining / open amount of the sales invoice via the API. Example: Sales i...

Read more...

1 Comments

Read more... 1 Comments

Category: Reports and Business Intelligence (258)

STATUS DETAILS
Completed
Ideas Administrator

Thank you for the feedback. We're done implementing this. It will roll out with next update. remainingAmount will be avaliable in v1.0 of the Standard APIs.

Best regards,
Henrik Westergaard Hansen
PM, Microsoft