fbpx

Microsoft Dynamics NAV can effectively track items with Lot No. It is quick to set up and easy to use.

In this blog I will take you through the setups required for activating the Lot tracking functionality.  I will also show how inbound and outbound transactions can be handled effectively in Microsoft Dynamics NAV.

Setup

1. Set up Item Tracking Code.
Item Tracking Code indicates how Microsoft Dynamics NAV will track the item in inventory.
Tick the options (as per client specific requirement) under the ‘Lot No.’ tab.

Lot tracking in MS Dyn NAV im1

2. Assign Item Tracking Code, Lot No. and/or Expiration Calculation on the Items that needs to be Lot tracked.

Lot tracking in MS Dyn NAV im2

Inbound Transactions

The purchase order is often the central document used for processing inbound transactions. Lot No. will need to be assigned to the Item on the purchase order line, the moment it enters the company.

To assign the Lot No., click on Line button and select “Item Tracking Lines”.

Lot tracking in MS Dyn NAV im3

Enter the Lot No. and Quantity (Base) and click OK.

Lot tracking in MS Dyn NAV im4

Then post the purchase order as ‘receipt’. When the document is posted, the item tracking entries are carried to the associated item ledger entries.

Outbound Transactions

The sales order is often the central document used for processing Outbound transactions.

Lot No. will need to be assigned to the Item on the sales order Line before the Item leaves the company.

To assign the Lot No., click on Line button and select “Item Tracking Lines”.

Lot tracking in MS Dyn NAV im5

Click on the ‘assist’ button on the Lot No. field to select the Lot No. and then enter the Quantity (Base).

Lot tracking in MS Dyn NAV im6

On posting, the Item Tracking Entries will be updated and will reduce the Lot available quantity.

When you work with Lot No., Microsoft Dynamics NAV calculates its availability information and shows it in the ‘Item Tracking Lines’ and ‘Lot No.-List’ windows.  This lets the user see how much of a Lot No. is currently being used on other documents. This reduces errors and uncertainty caused by double allocations.