Updating Document Page Headers from Lines with UpdatePropagation

The UpdatePropagation property is new in Microsoft Dynamics NAV 2015. I learned about it when I had a customer request to have a total amount on the header section of a Sales Order page that would update when a Sales Line was changed. In previous versions of NAV, this was a challenge, but the UpdatePropagation… Continue reading Updating Document Page Headers from Lines with UpdatePropagation

How Average Cost is Calculated in Microsoft Dynamics NAV

We often get questions on how Dynamics NAV calculates Average Cost and have created a simple example below to illustrate. The explanation below comes from a white paper entitled, “Dynamics NAV 5.0 Inventory Costing.” The explanation of how to calculate Average Cost was explained as follows: Determines the cost of the item at the beginning… Continue reading How Average Cost is Calculated in Microsoft Dynamics NAV

Connecting GL Entries to Value Entries in Microsoft Dynamics NAV

When trying to figure out what caused a posting to the Dynamics NAV General Ledger, there is a handy tool in Dynamics NAV you can use. If you are in the Dynamics NAV General Ledger Entries and want to know what Value Entry/Item Ledger Entry caused the posting, you could ‘Navigate’ or use the available… Continue reading Connecting GL Entries to Value Entries in Microsoft Dynamics NAV

How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card

From time to time we get the question, “How is the Unit Cost on the Dynamics NAV Item Card calculated?” It seems like a simple question, but in large part the answer is not well known. We sometimes describe the Unit Cost on the Item Card as the “weighted average cost of the remaining inventory”.… Continue reading How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card

Microsoft Dynamics NAV: Freight with a Credit Card Program

young beautiful woman paying for delivery with card

In this blog, we will go over general credit card and tax / freight integration in Microsoft Dynamics NAV. Sales tax and freight charges on the same sales order It is common to have both sales tax and freight charges on a sales order. If you are using standard Microsoft Dynamics NAV, the sales tax… Continue reading Microsoft Dynamics NAV: Freight with a Credit Card Program

Avoid a Common Mistake when Posting a Positive Adjustment in NAV

When posting a positive adjustment in Microsoft Dynamics NAV, be careful to select Entry Type ‘Positive Adjustment,’ not ‘Purchase’. When you want to post a Positive Inventory Adjustment in Dynamics NAV, you use the Item Journal. Often, when trying to reconcile the Purchases Account, users are not careful to pick the Entry Type of ‘Positive… Continue reading Avoid a Common Mistake when Posting a Positive Adjustment in NAV

Warehousing Myth: Accuracy Takes Too Much Time

One of the most frequently heard comments in a poorly run warehouse is, “It takes too much time to stop and record where product was placed.” The problem with that statement is that just the opposite is true. A well run warehouse is efficient and productive, but only because time and care is taken to… Continue reading Warehousing Myth: Accuracy Takes Too Much Time

Microsoft Dynamics NAV: KeyRef and Working with Keys in RecordRef Variables

There are several variable types in Microsoft Dynamics NAV where you look at them and wonder, “What is this? How did it get here? When do I use it?” And you may never find the answers to that on your own, unless you find something or someone who explains it. One of these variable types… Continue reading Microsoft Dynamics NAV: KeyRef and Working with Keys in RecordRef Variables

Deferral Posting Suggestion in Microsoft Dynamics NAV 2016

Editor’s Note: Saurav Dhyani is proposing an enhancement to Microsoft Dynamics NAV 2016. If you think this feature should be part of the base application, please vote for it on Microsoft Connect or iLoveNAV. If you have a suggestion of your own, feel free to propose it on these resources. When you are posting any… Continue reading Deferral Posting Suggestion in Microsoft Dynamics NAV 2016

Understanding the Interim COGS Account in Microsoft Dynamics NAV

We frequently see NAV Users who have set up their Interim COGS Account incorrectly. This might not have a significant effect in some cases, but in others it can be. The purpose of the Interim COGS Account is to record inventory value that has shipped but has not been invoiced to the customer. It is… Continue reading Understanding the Interim COGS Account in Microsoft Dynamics NAV