Power BI Embedding: Make it possible to add a Company filter or SystemId in the link (filter).
To make sure when you embedd a Power BI report in a list page in Business Central, you need to add a filter for the Pk of the table, so the record in the list page is linked to the same record in the Power BI report. However, the Power BI report may contain data from another, or multiple, compan...
Implement a SQLJoinType property in Report objects
Currently the only way to implement an inner join or a left outer join between data items is using the PrintOnlyIfDetail property. In Query objects there's a SQLJoinType property. Why not also implement the SQLJoinType in reports, instead of the PrintOnlyIfDetail property? Better control over ...
Expand create data set to all pages
You can create data sets that you can use for building reports in Excel, Power BI or any other reporting tool that works with an OData data source. The function 'create data set' gives the user the possibility to create a data set form list pages or queries. Pages are much more convenient, becau...
Best regards,
Business Central Team
"No. of Copies" in Request Page of Report 1304 - 1307
Reintroduction of the field "No. of Copies" in Request Page of the reports 1304 "Standard Sales - Quote" 1305 "Standard Sales - Order Conf." 1306 "Standard Sales - Invoice" 1307 "Standard Sales - Credit Memo" as there was in the reports 204 - 207. As stated here https://docs.microsoft.com/en-us/...
Best regards,
Business Central Team
Web Client: "limit totals" available in all reports
Web Client: "limit totals" available in all reports it would be useful to be able to introduce and use the "limit totals" functionality in the reports as it happens in the pages from the October release. There are many reports where this function is useful for totalizing data by filtering (ex: r...
Show the event log error message in web client same as windows client
I setup "Max Data Rows Allowed to Send to Excel" in Navision administrator, once I try to export the excel that exceed the limitation, windows client will popup alert show me the corresponding error message. but in web client, the error message only show in event log, for the client,it's a blue s...
Need to add Vendor's Our Account No to check
Looking at various Check Reports, adding the field Our Account No from the Vendor Card is not available. Can we please get this field available to be added to Checks.
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.
Ability to filter on Closing Date in Account Schedules
When you go to run a report in account schedules you can only filter on the closing date in the overview window. you cannot print reports or schedule them to the report inbox with closing dates. this will be useful for balance sheet running at the end of the year for clients to conveniently run r...
Vendor Performance Report
We have received requests for vendor performance reports over the years. It would be nice to have a built in report. This would show vendor statistics by vendor, by PO showing on time delivery statistics such as % fulfilled, % on time, etc.
Best regards,
Business Central Team
Send Remittance Advice Should Use Vendor Document Layouts If Defined
The ability to re-send the remittance advice from the Vendor Ledger Entries is much appreciated, however, it only uses the standard layout remittance report. It would be nice if the custom layout is used when a vendor has a custom remittance report defined in the Vendor Document Layouts
Best regards,
Business Central Team
Administrator