Use a lot number to trace the source of raw materials or products.
Inventory Lots information can be accessed from a few different locations in EBMS:
Product Record Lots Tab
-
Click on the product record Lots tab of the inventory item classified as Lots (Lots - Avg Cost or Lots - Linked Cost) as shown below:
-
The Lot Number is a unique code for each inventory item.
-
The On Hand quantity reflects the quantity of product in stock. The On Hand value = Processed - Shipped + Received.
-
Received reflects the amount that has been received on a purchase order but has not been processed into an expense invoice.
-
Shipped equals the quantity shipped on a sales order but has not been processed into a sales invoice.
-
The Processed value reflects the quantity of product that is posted to the financial ledger.
-
Use the View setting to query the list. Choose one of these options:
-
All: List all lots. Use this query to search for a lot based on the lot number or date.
-
Active: Includes lots that are assigned to sales orders and purchase orders but have not been processed. Lots will also appear active if they are over sold.
-
Available for Sale: This status identifies product that is in inventory and available to sell. The lot quantity in the query would equal the On Hand value on the Count tab. Available for Sale is similar to Active but will not appear as soon as it is assigned to a sales order.
-
Sold: Inventory on a processed sales invoice.
-
Processed Items: Lots will not be listed until the purchase order is processed. The lots list displayed with this status should match the Processed value shown in the Count tab with the following exception - a lot will show on the list if it was processed in a sales order and was NOT processed within the purchase order (sold before it was purchased).
-
Click on the Properties button to view the transactions for each lot.
-
Click on New Item, Adjust, or Remove buttons to adjust inventory levels. Review the Adjusting Inventory Count and Value section for more details on adjustments.
Lots Dialog
The second way to access inventory lots information is to open the Lots dialog to view all lot records.
Go to Inventory > Lots from the main EBMS menu. Double-click on a Lot Number from the list to open the lot record.
-
Select any transaction record and click on the View Document button to view the source document.
-
Click on the Reverse Line button to void the transactions.
-
Activate utilities to verify the integrity of the inventory lots information by clicking on the Verify Status button.
-
Select OK to return back to the lot list.
Common use cases
Traceability Records
Many food industries have traceability requirements. Many manufacturing companies are required to track the lot information for raw materials used for manufacturing. Dated product requires lots to track the sell by dates or expiration dates on products sold.
Lot Details
This option gives the user the ability to track multiple lot numbers within a single inventory item. A lot number is assigned each time a product is sold, consumed, transferred, or moved. Additional information, such as expiration date, can be associated with each lot.
This lot information can be used to maintain traceability records, facilitate quality evaluations, or any other reason to track each lot from the time it was purchased until it is sold or consumed in a manufacturing environment.
Features
- Track each lot from the time it was purchased until it is sold or consumed.
- Trace the source of raw materials or products being sold.
- Track multiple lot numbers within a single inventory item.
- Associate additional information such as an expiration date with each lot.
- Enter lot numbers and lot information within the purchase order lines or manufactured finished goods records.
- Lots - Avg Cost inventory classification to create lots where the lot number does not affect the value of the product.
- Lots - Linked Cost inventory classification to link the cost to the lot number in a FIFO (First In, First Out) manner.
- Lot number and lot date can be manually assigned or automatically assigned.
- Lot number assigned each time an inventory item is sold, consumed, transferred, or moved.
- Transactions associated with individual lots can be evaluated or adjusted.