In the more current versions of Microsoft Dynamics NAV you are able customize your Home page similar to the old ‘Shortcuts’ in earlier versions of NAV. One of the appealing attributes of Dynamics NAV is the ability to personalize your user experience. Customizing, or personalizing, the home screen is easy to do, making your work… Continue reading Microsoft Dynamics NAV – Adding Favorites to the Home Page
Category: Dynamics NAV
Database Normalization in Dynamics NAV
Anomalies and Database Normalization The three most common types of database anomalies include insertion, deletion, and update. These anomalies come from poor database design and can cause errors and other frustrations. This article will explain all three of these common database irregularities and provide solutions. For this article to provide real value, a basic understanding… Continue reading Database Normalization in Dynamics NAV
Using NAV Item Journal to Issue Items to Different Expense Accounts
Scenario: You would like to Debit different General Ledger Expense Accounts when you issue stockroom material using the Dynamics NAV Item Journal. For instance, if the engineering department uses stock room inventory for a project, you would like to debit the Engineering Expense Account for the cost of the inventory. Without doing any additional setups,… Continue reading Using NAV Item Journal to Issue Items to Different Expense Accounts
New and Changed Item Setups for MRP Planning in Dynamics NAV 2013
The MRP planning functionality beginning with Microsoft Dynamics NAV 2013 has some changes from the previous versions of NAV to be aware of when setting up items for MRP planning. If we look at the Planning Tab of an Item Card, we can see the following new fields: Dampener Period Dampener Quantity Lot Accumulation Period… Continue reading New and Changed Item Setups for MRP Planning in Dynamics NAV 2013
Which GL Account Will Purchase Receipts and Invoices Post to?
The other day, the question came up about how to determine which Dynamics NAV General Ledger Accounts are posted to for a Purchase Receipt and Invoice. First, we need to find our way to the Item Ledger Entry for the receipt you want to analyze. Figure 1 – Item Ledger Entry showing the receipt to… Continue reading Which GL Account Will Purchase Receipts and Invoices Post to?
Purchasing Lead Time in Microsoft Dynamics NAV
There are actually two Purchasing Lead times in Dynamics NAV. If we look at the Replenishment and Planning Tabs of a Dynamics NAV Item Card or SKU Card, we see Lead Time Calculation and Safety Lead Time. The Lead Time Calculation is what most people would call Purchasing Lead Time. The reason it is called… Continue reading Purchasing Lead Time in Microsoft Dynamics NAV
A Brief Definition of Time in Microsoft Dynamics NAV Manufacturing
In order to set up Routings in Dynamics NAV and understand their Cost Accounting effects, one needs to know how time is defined. In a Routing there are ‘Value Added Times’ and times just for scheduling purposes. Value Added Times Setup Time – The time to set up a machine or to get ready to… Continue reading A Brief Definition of Time in Microsoft Dynamics NAV Manufacturing
Optimizing SQL Server Through the Parallelism Feature
There are many default values within SQL Server’s instance level properties that allow it to function well out of the box without extensive modification. Tweaking these values to your specific environment/workload can provide optimization and a deeper understanding of your system. Two features in particular, with slight modifications, can make a significant impact on your… Continue reading Optimizing SQL Server Through the Parallelism Feature
Using Send-Ahead Quantity in Microsoft Dynamics NAV Routings
From a production scheduling point of view, it may be advantageous to ‘overlap’ production steps to reduce the elapsed time to produce a lot of goods. From the APICS Dictionary Send-Ahead is the movement of a portion of a lot of material to a subsequent operation before completion of the current operation for all units… Continue reading Using Send-Ahead Quantity in Microsoft Dynamics NAV Routings
Item Substitutions in Microsoft Dynamics NAV
There are times in a manufacturing company where substitute items that are not on the Bill of Material are OK to use if the preferred item is not available. Often this substitution has to be approved by an engineer and is usually in the form of a ‘Usage Variance’. If substitutions are a common event,… Continue reading Item Substitutions in Microsoft Dynamics NAV