Modern Inventory Management: QR Codes + Cloud + Mobile Technology

Inventory Serialization: Tracking By SKU, Lot Number / Batch Number, Or Serial Number.

When do you need to track inventory by SKU, when do you need to track inventory by lot number or batch number, and when by serial number. How to set up QR Inventory to track assets and inventory the way you need.
QR Inventory gives you an option to track inventory the way you need: by SKU number / line item number, by lot number / batch number or by serial number. This article will help you understand what would be the better way to track inventory for your business scenario, and how to set up QR Inventory to do what you need.

How Should I Track Inventory: By SKU, By Lot Number Or By Serial Number?


When to track inventory by SKU number / line item number?

If your main concern is inventory stock in different locations and you do not need inventory traceability - use SKU / line item number to track inventory. All inventory items that are exactly the same will have the same SKU / line item number. For example, you may have a box of Hex bolts, Stainless steel 18-8, 1/4" - all bolts of these type will have the same SKU. Normally you would not care which specific bolt from this box you are using - you just want to know how many you have in stock and when is it time to re-order. Most of the supply items / consumables like this (bolts, nuts, office paper, toner, etc.) are usually tracked by line number / SKU.

When to track inventory by lot number / batch number, and what is the purpose of the lot number?

If you want to implement inventory traceability, tracking inventory by the line item number / SKU is not enough. You will need to divide inventory items that are the same and have the same SKU into lots / batches that were produced under similar conditions (usually on the same date / shift plus there may be additional parameters by which inventory is combined in the lots / batches). Each batch gets its unique lot number. Under this scenario you may have two Stainless steel 18-8, 1/4" bolts that were produced under different conditions and have different lot numbers. For inventory traceability you should be able to tell them apart. You should know lot numbers of all components that you were using to assemble the finished product, and where / when each batch was distributed. Then, if it turns out that a specific batch was defective, you can quickly locate all affected items. This is the purpose of inventory traceability, and the purpose of tracking inventory by lot number.

When to track inventory by serial number?

Serial number uniquely identifies the item, and there can only be one item with a specific serial number. If you want to track each item individually, you need to track it using serial number. For example, if you are tracking IT assets (computers, routers, hard drives), as a rule you want to know where each individual computer is, what is installed, its life-time history and transactions. You may have multiple computers which are exactly the same, but in order to track each computer individually you need to track them by serial number.
Any electronics, equipment, and other valuable items are usually tracked by serial number.

How Do I Set Up QR Inventory To Track By SKU, By Lot Number And By Serial Number


How to set up inventory tracked by line item number / SKU?

Enter each line item into the system as inventory, and set its line item number / SKU as item ID. If you use an example with the Stainless steel 18-8, 1/4" bolt, you will have one entry for this item. You will then be able to track stock of this item in each location, know all transactions for this item (how many where purchased when, how many where used for each project, etc.), and receive alert when you need to order more.

How to set up inventory tracked by lot number / batch number?

Enter each batch into the system separetely as inventory, and use lot number as item ID. As a rule, you will do it on a smartphone when receiving each new batch in the warehouse, or on a factory floor as each new batch is produced. You will also be able to enter all batch details (production date, shift, etc.). You can do this using web interface as well if it is better fit for your situation.
Use the same name for the items with the same SKU (e.g. all batches of Stainless steel 18-8, 1/4" bolt will have a name Stainless steel 18-8, 1/4" bolt, but different item ID numbers). With this setup, you will be able to track inventory by lot number, check all batch transactions, and locate all products where this batch was used as a component / ingredient. You also will be able to check stock and location of all Stainless steel 18-8, 1/4" bolts, regardless of their lot number.

How to set up inventory tracked by serial number?

Enter all serialized items as assets (unique items tracked individually). Enter serial number as item ID. Use the same name for the assets that are the same in everything except for serial number - this way you will be able to track each asset individually by serial number, but also be able to review stock and location of each asset type. For example, if you track compressors, thermostats or other similar equipment by serial number, you still will be able to see how many compressors you have in each location.
You do not have to enter all data for each single asset. Instead, you can bulk enter assets that are the same into QR Inventory: enter all information once, then scan in or paste all serial numbers. Use Bulk Add Assets link to do this.

Inventory Traceability


How do I achieve traceability using QR Inventory?

To achieve traceability, you need to track inventory either by lot number or serial number.
If you are building assemblies or create a product from multiple ingredients, be sure to record lot number or serial number of components that you are using. When you ship finished goods to the retailer / distributor, make sure you record where the item was shipped.
If you need to find out where all items with a specific lot number are, check item details report for this lot number - you will see all relevant transactions in one place: in what finished products the item was used, what was already distributed and where, what do you still have in storage and in what locations.

 

 

QR Inventory FAQ: Topics
How Do I Set Up QR Inventory?
How Do I Enter Data And Do Inventory Count?
Inventory Serialization: Track By SKU, Lot Number Or Serial Number?
How Do I Use QR Inventory Mobile Application?
How Do I Access And Collect Data With QR Inventory Mobile Application?


 
  QR Inventory
At A Glance
Features
How Does It Work
Why QR Inventory
Industries
Business Solutions
New Additions
Your Inventory Project
Demos & Trials
QR Inventory Tour
Video Overview
Demo
Try It Out
Get A Quote
Video Library
QR Inventory Modules
Service & Maintenance
Stocktaking & Asset Audits
Assemblies & Kits
Accounting (PO & Invoices)
NFC Asset Tracking
Barcode Scanners
QR Code Based Ordering
Resources
Software Selection Guide
Asset & Inventory Management Blog


About
QR Inventory FAQ
Contact Us
 
 

See It For Yourself - Mobile Asset & Inventory Tracking In Action