We’ve had query objects for a while now – since NAV 2013 (I think). In theory they sound great, link a bunch of tables together, aggregate some columns, get distinct values, left join, right join, cross join – executed as a single SQL query.
So now – “let’s get started” with ..
Why would I rename all my AL-files?
Well – because of Microsoft and their new (upcoming) code analysis rule about file name conventions. You might already have complied with their previous conventions, and … they will change. Even better: they actually already changed .. Just read here:
Probably most of you already know that with the Dynamics 365 Business Central Wave 2 release, we have the ability to modify the Base App. But to extract Dynamics 365 Business Central Base App as .al files that would compile might be quite difficult, so in this article, we will talk about how to extract the Dynamics 365 Business Central Base App using Docker, Business Central DVD, and symbols. Also, we will briefly mention how to upload a customized Base App.
Following on from the series of posts I wrote last month (starting here) about testing the performance of Power BI reports in the browser, I would now like to highlight one possible cause of slow report rendering performance: the over-use of custom visuals. Before we go any further, though, let me be absolutely clear about something:
The automatic payment reconciliation of Dynamics NAV and Business Central is great feature – load a statement file and match the open invoices within the blink of an eye. It’s every accountants dream and a basic feature in today’s world. Let’s have a quick but informative look into how it works and fill the gap the official documentation leaves.