We frequently get questions about how the Dynamics NAV Account should be set up. If we look at the General Posting Setup in Dynamics NAV, we see that there are two setup columns: COGS COGS Interim The COGS Interim Account is for items that have been shipped, but not invoiced to the customer. Figure 1 –… Continue reading Interim COGS Account Set Up in Microsoft Dynamics NAV
Category: How To
Understanding Low-Level Code When Running Adjust Cost-Item Entries
or When Running Adjust Cost-Item Entries, why does the Microsoft Dynamics NAV need to know the Item Low-Level Code? The scenario: Your company is a manufacturing company and has a Bill of Material that has several levels. Your company has not started to use the Dynamics NAV MRP (Planning Worksheet) functionality yet. You are running… Continue reading Understanding Low-Level Code When Running Adjust Cost-Item Entries
Customizing Drop-Down Lists for Tables in the NAV Role-Tailored Client
Back in the days of the legacy client, doing lookups into another table for a foreign key field in Microsoft Dynamics NAV (Navision) always involved running a list form. Nowadays, if you try to do a lookup into a table for a foreign key, you get something like this (Customize DropDown List for a table… Continue reading Customizing Drop-Down Lists for Tables in the NAV Role-Tailored Client
Tracking Production Order Variances in Microsoft Dynamics NAV
We had a question from a client recently regarding Production Order Variances. The client was seeing Variances being posted to the General Ledger and wanted to know what was causing them. Keep in mind that this analysis is only for those items that have a Costing Method of Standard Cost. Also keep in mind that there will… Continue reading Tracking Production Order Variances in Microsoft Dynamics NAV
How to Fine-Tune and Present Cash Flow Data in NAV 2013 R2
Several weeks ago, a very well written blog was posted on how to create a cash flow schedule in NAV 2013 R2. In this blog, I wish to expand on how the data can be fine-tuned and then the many ways in which this information can be presented to decision makers. After you have selected… Continue reading How to Fine-Tune and Present Cash Flow Data in NAV 2013 R2
Why Does Inventory Valuation show Zero on Hand but has a Value?
We often get the question from clients using the Dynamics NAV Average Cost Method, “Why is there a dollar value when there is zero on hand in a location, but when I run the report for all locations combined, it has a correct value?” First, we should look at the Inventory Setup. We can see… Continue reading Why Does Inventory Valuation show Zero on Hand but has a Value?
How to Set Up Additional Currencies in Microsoft Dynamics NAV
Microsoft Dynamics NAV (Navision) allows management to view reports in a second currency in addition to the base currency. Many companies have divisions or sister companies in foreign countries. Those companies are quite likely to be required by local governments to use the local currency for G/L reporting. The parent company may wish to view… Continue reading How to Set Up Additional Currencies in Microsoft Dynamics NAV
Managing Inventory Periods in Microsoft Dynamics NAV
Inventory periods are used to manage posting of inventory adjusting entries. Adjusting entries will post in the period the original transaction unless inventory periods are closed on a monthly basis. Creating and closing inventory periods will prevent the inventory adjustments from posting in that period. If the posting date of the original transaction is in… Continue reading Managing Inventory Periods in Microsoft Dynamics NAV
Understanding Concurrent Capacities on Dynamics NAV Routing Lines
There is a field in the Dynamics NAV Routing Line named Concurrent Capacities. The question is, “What is it used for?” We hope to answer this question through the use of a practical example that will hopefully demonstrate its usefulness. We set up a simple example to illustrate the use of this field. Figure 1 –… Continue reading Understanding Concurrent Capacities on Dynamics NAV Routing Lines
Quick Reporting in Dynamics NAV Using Microsoft Excel Pivot Tables
Yesterday a client called and asked if there was a report in Dynamics NAV that listed inventory on hand and in which warehouse bins the inventory was located. We did not find a report for this, so we thought that if we could get to the Bin Contents Table, we could export the data to Excel and create a… Continue reading Quick Reporting in Dynamics NAV Using Microsoft Excel Pivot Tables