Category Archives: reporting

Export to Excel in Dynamics 365 Business Central v19

Overview Relax folks, Microsoft didn’t remove the Export to Excel function in Dynamics 365 Business Central starting from v19. It’s just been moved. The Difference Old Version (or versions prior to Business Central v19): Starting from Business Central v19: Why The Change? The direction from Microsoft is to integrate more and more Microsoft 365 applicationRead more

Accounting Cost vs. True Cost – Analyzing Costing in Business Central

Overview In Microsoft Dynamics 365 Business Central (formerly Dynamics NAV), when doing costing and profitability analysis, you need to differentiate between a transaction’s True Cost and Accounting Cost. These terms will not appear on any official documentation or manuals, I made them up for a lack of better terms. To better explain the difference betweenRead more

Why Your Inventory Valuation Does Not Match the Inventory Account on the General Ledger

Overview At the end of every month, we will inevitably get some questions on why their inventory valuation figures does not match the G/L inventory account. We would investigate and find out why and provide solutions on how to fix them. Some of the reasons are pretty common so I’d thought I compile a listRead more

Optimizing your Aged Accounts Receivables Report

Overview Doing numerous upgrades from an older version of Navision to NAV 2015 and 2013, one common complaint is how slow the reports are running. This is especially true for larger reports like the Aged Accounts Receivables, Aged Accounts Payables , Inventory Valuation, etc. The old reports that took a long time, such as the InventoryRead more

Navision RDLC reporting – SetData and GetData – Why It Is REQUIRED

Ever wondered why there’s no tutorial on how to create a Sales Order report from scratch in the RDLC? The reason is because it takes a LONG TIME! Even for an experienced developer, it takes a long time. As I previously mentioned on my article, Microsoft really needs to address this in future versions. TheRead more

Open Suggestions to Make Navision RDLC Reporting More Efficient

Working with the new RDLC reporting for a few months now after the NAV2009 release, I thought I would like it as I work with it more. Sad to say, that hasn’t happened yet. It’s like being in a bad relationship and hoping some day that it’ll magically get better. And from the general consensusRead more

How to Define SetData and GetData in RTC Reports in Dynamics NAV Navision

For some reason unfamiliar to me, Microsoft likes to write tutorials that does not easily teach you what you need to do to get the job done. For basic List type reports, yes, it’s quick and simple, however, when it comes to reports involving forms (i.e. sales order, sales invoice, etc), I cannot find aRead more