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
Category: How To NAV
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
Lot and Serial Tracking in Microsoft Dynamics NAV Clarified
Dynamics NAV provides for very robust Serial Number and Lot Number Tracking. When we advise clients about Serial and Lot Tracking, we say, “Only do it if you have to, as it adds additional user effort to record a transaction.” There are situations where you must use serial or lot tracking. These situations are primarily… Continue reading Lot and Serial Tracking in Microsoft Dynamics NAV Clarified
What are Rounding Value Entries in Microsoft Dynamics NAV?
We received a question recently from a client about an unexpected and unexplained Rounding Value Entry that was created by the Adjust Cost – Item Entries program in Dynamics NAV. The Rounding Value Entry was associated with a Purchase Receipt that was made several months before the Rounding Value Entry was created. The Purchase Receipt… Continue reading What are Rounding Value Entries in Microsoft Dynamics NAV?
Unexpectedly High New Standard Cost in Microsoft Dynamics NAV
There are times when you are using the Dynamics NAV Standard Cost Method and rolling up a Standard Cost for a Produced Item you get an unexpectedly high Standard Cost. A probable cause is that you have selected “Cost Includes Setup” in the Manufacturing Setup and that you have a setup time in a Routing… Continue reading Unexpectedly High New Standard Cost in Microsoft Dynamics NAV
Ensuring All Items are Posted When Using a Nightly Batch Job
Running Adjust Cost-Item Entries and Posting Cost to G/L in Microsoft Dynamics NAV Whether you use the Dynamics NAV automatic features to run the Adjust Cost-Item Entries and Post Cost to G/L processes during nightly batches or run them manually, nearly all of the time these processes work correctly and produce the correct results.… Continue reading Ensuring All Items are Posted When Using a Nightly Batch Job
Getting the Most Out of Your Dynamics NAV Setup: Part Number Revision Levels
What do you hope to achieve? For whatever reason, in the past six months, I’ve found myself having the “Revision” conversation more than ever. Usually the engineering group will recognize or comment on the fact that NAV does not have such a field designated on the Item Card. As I do in many conversations regarding… Continue reading Getting the Most Out of Your Dynamics NAV Setup: Part Number Revision Levels
Hints on Navigating on an Item Ledger Entry in Microsoft Dynamics NAV
We frequently use the Dynamics NAV Navigate tool and Microsoft Excel to verify Item Ledger Entry postings to the General Ledger. When Navigating on an Item Ledger Entry that involves both a purchase receipt and a purchase invoice, you must do two Navigations to see all of the General Ledger postings. We start our scenario… Continue reading Hints on Navigating on an Item Ledger Entry in Microsoft Dynamics NAV
Tracking Non-Conforming Material in Microsoft Dynamics NAV
We am often asked how to track non-conforming material in Dynamics NAV. There is no formal NCMR (Non-conforming Material Report) functionality in Dynamics NAV, but we have handled non-conforming material by creating a location named MRB (Material Review Board) and moving material in and out of that location. Some people would name this location “Quarantine”,… Continue reading Tracking Non-Conforming Material in Microsoft Dynamics NAV