Category: Microsoft Software

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

Reversing the Output of a Dynamics NAV Released Production Order

We are asked from time to time how to reverse the output of a Dynamics NAV-released Production Order. The need to do this probably was caused by a mistake made when posting the original output. To illustrate the issue, we created a Dynamics NAV-released Production Order: Figure 1 – Screenshot of a NAV-released Production Order… Continue reading Reversing the Output of a Dynamics NAV Released Production Order

Reversing a PPV for a Purchase Return Credit Memo in Dynamics NAV

The item was later returned and a Purchase Credit Memo was issued and posted, but the PPV was not reversed. We have set up the following example to illustrate: Figure 1 – Screenshot showing an example of a standard cost item of $2.00 We created and posted a purchase order with the cost of $3.00.… Continue reading Reversing a PPV for a Purchase Return Credit Memo in Dynamics NAV

Understanding the Order Reordering Policy in Microsoft Dynamics NAV

We are given the following choices for Item Reordering Policy in Dynamics NAV. The choice affects how the Planning Worksheet (MRP) plans for replenishment of the item. Blank Fixed Order Quantity Maximum Quantity Order Lot-for-Lot Figure 1 – List of choices defining how the Planning Worksheet (MRP) plans for replenishment of an item If we… Continue reading Understanding the Order Reordering Policy in Microsoft Dynamics NAV

Item Category and Product Group Code in Microsoft Dynamics NAV

There was a question recently on a Dynamics NAV Forum asking, “What is the Product Group Code on the Item Card used for?” If we look at an Item Card in Dynamics NAV, we see the field for Product Group Code. Above it, there is a field for Item Category Code. Figure 1 – Item… Continue reading Item Category and Product Group Code in Microsoft Dynamics NAV