A lot number is an identification number assigned to products indicating the batch or lot in which the product was manufactured or processed. Lot number tracking, is the ability to track and trace products back to suppliers, through distributors or to customers by lot or batch.
Preliminary: Attributes and screen setup
In attributes, add the vendor lot number and production lot number. Once this is done, add these attributes as line attributes to the following screens.
- Add production lot number to work order, pick, pack, ship.
- Add vendor lot number and production lot number to locations and receipts.
Step 1: Locations for separate lot numbers
Once you’ve made sure the attributes and screens are setup, add two new locations. One for the vendor lot number, and one for your production lot number. The vendor lot will be used for the raw materials you receive to produce your products. Your production lot will be used for your finished products.
To do this, from the home screen, go to the locations module.
From here, hit the create new button.
Create two new locations for the vendor lot numbers, and for your production lot numbers.
Step 2: Linking receipts to vendor lots
Upon receipt of raw materials from your vendors, link the raw materials you receive to your vendor lot numbers by adding the vendor lot number as a line attribute on the goods you receive.
First, from the receipt screen, add the items you’re going to be receiving from your vendors. Once added, right click on the item line, and hit the edit line attributes. Add your vendor lot number here.
You can see that a line item has an attribute within it by the blue triangle that appears to the left of the line.
Once you’re done adding all items, complete the receipt.
You’ll now be able to see the material addition to your vendor lot location. Hit the inventory module. From here, select your item, and hit the history tab to see the history of movements.
Because you’re receiving the inventory into your locations, you will know where and how many units you have left for a raw material.
Step 3: Issue and receive work order
Issue a work order using the material you’ve received into your raw material warehouse.
Right click on your line items to add your production lot number to the items. Once you’re done adding everything, issue the work order.
Once issued, go to the receipt module. Receive your work order into your production lot warehouse.
Add your production lot number as a line attribute on your line items. Once done, save your receipt, and complete it.
Once completed, you’ll be able to see your items in your production lot warehouse. To see this hit the inventory module, find your product, and hit the history tab. In this example, we can see the whey protein product, as well as the vanilla powder product.
Step 4: Issue sales order and ship goods
When issuing a sales order, you’ll pick, pack and ship from your finished goods warehouse and you can see the inventory being depleted from your finished goods warehouse (your production lot warehouse).