Category: Dynamics NAV

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?

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

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

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

Microsoft Dynamics NAV Filters

You can perform advanced queries with Microsoft Dynamics NAV filters, similar to a Google search. This free Quick Reference Guide reviews different expressions and what they mean. You can also download a printable version to have a copy available wherever you are. 1) Filter on an Interval  To filter between a range, enter FirstNumber..LastNumber e.g.… Continue reading Microsoft Dynamics NAV Filters

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

Setting Up Production Lead Time in Dynamics NAV if Not Using Routings

There are manufacturing companies using Dynamics NAV that want to offset the start time on production orders to accommodate production time even though they are not using Routings. To illustrate, we set up a test item. Note that the item has a BOM, but not a Routing. Figure 1 – To offset start time on… Continue reading Setting Up Production Lead Time in Dynamics NAV if Not Using Routings

Tooling Amortization in Microsoft Dynamics NAV

Manufacturing companies will often build or purchase production tooling. In most cases the manufacturing company would like to amortize the cost of the tooling by adding the cost to the items produced. There is no direct way to do this in Dynamics NAV, but we have accomplished this using Dynamics NAV Item Numbers and Bills… Continue reading Tooling Amortization in Microsoft Dynamics NAV