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
Category Archives: reporting
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
Overview Sometimes, how a computer system does accounting will be different than how traditional accountants does accounting. One of the subjects that always come up for debate is how COGS (Cost of Goods Sold) is calculated. The Postings In Dynamics 365 Business Central, when a purchase of inventory is made, 4 General Ledger accounts areRead more
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
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
Let me first start by saying that I’m not a fan of doing book reviews. In my very humble opinion, most books about Dynamics NAV that are released, although a good read and provides some valuable information, does not bring much INCREMENTAL value to the NAV professional. What do I mean by Incremental value? It’sRead more
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
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
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