I recently came across a question in the Business Central forum: How do I get information about Posted Sales Shipments in Power BI? And this is not a standalone question, I get these questions a lot in my training’s that I deliver all over the world. Many times I see answers suggesting to use existing list pages and publish them as web services, either manually or using the assisted setup: Setup Reporting Data . And although I like the Setup Reporting Data wizard in Business Central, I don’t like the results, or I should say: the performance . It’s very easy to create new web services using…

Recently someone asked me, what’s wrong with me report, it’s not showing me the correct data? After investigating I noticed that the report used filters, applied in several different ways and that the expected data was not showing up in the dataset, and then of course it was also not displayed in the layout. So, let’s see how you can apply filtering, in the dataset of a report, and let’s do this with a document. A document typically fetches information from two tables: Header and Line. Let’s take the purchase Header and Purchase Line as an example, but the same is also valid for all other…

Released Cumulative Updates for Microsoft Dynamics 365 Business Central on-premises: https://support.microsoft.com/en-us/help/4470116/released-cumulative-updates-for-microsoft-dynamics-365-business Released Updates for Microsoft Dynamics 365 Business Central 2019 Release Wave 2: https://support.microsoft.com/nl-be/help/4528706/released-updates-for-microsoft-dynamics-365-business-central-2019 Dynamics 365 Business Central On-Premises Spring 2019 Updates: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/deployment/update-versions-14