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
Category: Blog Tags
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
NAV World, Meet Microsoft Dynamics 365!
Microsoft announced last week the availability later this year to integrate ERP and CRM Suite with Office 365. The Integration of the ERP Suite will bring ERP integrated with Office 365. Dynamics 365 apps are designed so they can be easily and independently deployed. That means you can start small and pay only for what you… Continue reading NAV World, Meet Microsoft Dynamics 365!
Reducing the Quantity of Inventory Sub-Ledger Entries
We often hear the comment that Dynamics NAV posts too many Inventory Sub-Ledger entries to the General Ledger. There is a way in Dynamics NAV to reduce the number of General Ledger entries when running the batch report “Post Inventory Cost to G/L”. When running the batch report, select “Per Posting Group” and the system… Continue reading Reducing the Quantity of Inventory Sub-Ledger Entries
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
Understanding Expected Cost Posting in Microsoft Dynamics NAV
There is an Inventory Setup in Dynamics NAV to select “Expected Cost Posting”. In an earlier blog, we explained some of general Effects of Inventory Setup. In this blog we will go deeper into Expected Cost Posting, and explain what it means and its effects. Figure 1 – Inventory Setup contains an option to select… Continue reading Understanding Expected Cost Posting in Microsoft Dynamics NAV
What IoT Means for Manufacturers
Internet of Things (IoT) as an industry is projected to grow from 5 billion devices installed in 2015 to 24 billion in 2020. By the end of 2017, 76% of manufacturers will be involved in the industry growth and foresee launching industrial IoT applications and use of smart devices. IoT can be a huge game… Continue reading What IoT Means for Manufacturers
Unit and Standard Cost Not Equal on NAV Inventory Valuation Report
We received a call recently from a client who said when they run the Dynamics NAV Inventory Valuation Report that the unit cost on the report is not equal to the Standard Cost of the Item. To illustrate, see the example below. The Standard Cost for Item 1000 is 427.499, but when we run the… Continue reading Unit and Standard Cost Not Equal on NAV Inventory Valuation Report