Category: How To NAV

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

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

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

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

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

There are times where it seems like an item’s inventory value changes without an explanation. This blog attempts to show how the Microsoft Dynamics NAV Inventory Valuation Report calculates the Inventory Value and may help explain why the inventory value might appear to magically change. We have set up an example to try to explain… Continue reading Item Inventory Value Changes in Microsoft Dynamics NAV

If you are a manufacturing company using the Dynamics NAV Standard Cost Method, it is important that you understand the concept of Single Level and Rolled Up cost Shares. When you Roll Up Standard Costs in Dynamics NAV, the system not only populates the Standard Cost Field for the manufactured items, but also populates the… Continue reading Single Level and Rolled Up Cost Shares in Microsoft Dynamics NAV

We have all received checks from customers that were less than what they owed—that is a given. The question is, why did they send less than what they owed? Outside of any extraordinary situations, the most common reasons include: the customer was not paying attention when they issued the check and sent a lesser amount,… Continue reading Dynamics NAV 2013 – How to Use Payment Tolerance to Save You Time

Microsoft Dynamics NAV (Navision) has several defined methods for calculating depreciation expense in Fixed Assets. These are Straight Line, Double Declining Balance, and a combination of the two where straight line depreciation is used when its results become the larger of the two methods calculated. But there are times when the desired method is something… Continue reading Dynamics NAV: User Defined Depreciation Methods in Fixed Assets

It is quite common in processing industries, like chemical production, that the cost of Labor is not the primary cost of production. In chemical processing, the cost of energy or depreciation may be the largest cost component. While Centers and Routings in Dynamics NAV are typically thought of in terms of Direct Cost (Labor) and… Continue reading Work Center Units of Measure in Microsoft Dynamics NAV 2013