Lot tracking, a feature available to Plus and Pro plan subscribers, is used to track batches or groups of a specific item. Lots work similarly to serialized inventory, except a lot represents a group of items instead of an individual unit. Although all lot items are included on the Items list (Operations menu > Inventory > Items), this list is designed only to provide the characteristics of a lot item. The Lots list (Operations menu > Inventory > Lots), however, provides the in-stock information of the physical items in the warehouse, as well as the lot number and the name of the item to which it corresponds, the quantity in stock, the quantity available to be picked, the lot's expiration date, and whether it has been recalled.
A lot number is assigned to each batch of items, and the number stays with the batch as it goes through the system. You can track when each batch was received, shipped, manufactured, and so on, as well as set an expiration date for the lot. If a customer reports something wrong with the lot, you can mark it for recall.
The Plus and Pro plans of SOS Inventory support lot inventory.
In the Purchasing settings (Settings > Purchasing settings), many settings make lot tracking more powerful. You can enable settings to automate the generation of lot numbers, add a prefix to the number, set the number length, and either generate the numbers randomly or keep them in sequence by providing a starting sequence number.
If you need to enable lot tracking for an existing item that is not currently lot tracked, the steps involved are different from those listed here. Refer to Converting a non-lot-tracked item to a lot-tracked item for more information.
To turn on lot tracking for a new item, do the following:
The steps required to convert an existing non-lot-tracked item to a lot-tracked item depend upon whether its current stock level is at zero.
If the item has a stock level of zero
On the Items list (Operations menu > Inventory > Items), choose Edit on the item's Actions menu.
Enable Track lot numbers on the item's Edit page.
Select Save and close.
No further action is needed.
If the item has a stock level other than zero
Disable syncing between SOS Inventory and QuickBooks Online.
Go to the QuickBooks sync settings page (Settings > QuickBooks setup).
Set the Directional sync field to Do not send data in either direction.
Scroll to the bottom of the page and select Update.
Run the Inventory stock status report (Operations menu > Reports > Inventory > Inventory stock status).
Under the Filters section:
Select All for the Location.
Enter the name of the item in the Item name contains filter.
Under the Actions section, select Display report.
In the report results, note the locations where the item is present and the quantities at each location.
For each location with quantities of that item, create an inventory adjustment (Quick add > Inventory > Adjustment). Change the quantity to zero for each adjustment, noting the value of the adjustment for that location.
Go to the Sync queue (Sync > Preview Sync). Scroll to the bottom of the list and delete the adjustment transactions from the queue. (This does not affect QuickBooks since lots are merely added to existing stock in SOS Inventory.)
Go to the item’s record in the Items list (Operations menu > Inventory > Items) and select Edit on the item's Actions menu.
Enable Track lot numbers.
Select Save and close.
Create an item receipt (Quick add > Purchasing > Item receipt) for each location in which you adjusted the item.
Select the vendor from which the items were purchased.
Select the location to which you are reloading the now lot-tracked item.
Add the lot-tracked item to the line items table and include for that location the following information. (Refer below to the Methods for adding lot numbers on transactions section, if needed.)
Appropriate lot number.
Lot expiration date.
Quantity of the lot.
Total value of the lot in the Amount column.
If that item has more than one lot at that location, add a line for each additional lot, repeating Steps 6.c.i-6.c.iv.
Set the Payment option to None.
Select Save and close.
Once all locations have been restocked, check the Items list and the Lots list to validate that the item is correctly lot tracked.
Restore syncing between SOS Inventory and QuickBooks Online.
Go to the QuickBooks sync settings page (Settings > QuickBooks setup).
Set the Directional sync field to Send data in both directions.
Scroll to the bottom of the page and select Update.
Once lot tracking has been enabled, whenever you use that item on transactions, the system will prompt you for the lot number. Depending on the type of transaction, the system will prompt you to perform one of the following:
Use any of the following options to assign lots to items:
Do not create a new lot via the Lots list (Operations menu > Inventory > Lots). The exception to this rule is if you want to add quantities for a lot-tracked item with an adjustment transaction. In this instance, you must first create the lot, then you can access the lot from the dropdown on the adjustment transaction.
After one or more lot numbers have been assigned to a lot-tracked item, you must indicate on transactions which lot(s) you are shipping, adjusting, transferring, etc. Select from the transaction dropdown in the Description column the number that corresponds to the lot being shipped, adjusted, transferred, etc. Below is a screenshot of the lots available for Argyle Cloth Red:
The dropdown displays not only all existing lot numbers for that item, but also each lot's total quantity on hand at that location (shown within parentheses), as well as its expiration date.
If you have multiple locations, keep in mind that quantities of the same lot may be spread across those locations.
Use the Lot stock status report if you need to know whether any additional quantities of the same lot are in stock at other locations. In the report's Filters section:
A transaction that includes multiple lots of the same lot-tracked item needs a separate line item for each lot required. Be sure the quantities entered for each lot are accurate.
For existing lots, use an adjustment transaction (Quick add > Inventory > Adjustment) if you need to adjust your inventory of items tracked by lot at a specific location. The system will prompt you for the lot number(s).
If the lots are brand new, they must be created before they can be selected on the adjustment. Then you can adjust quantities and values up or down, as needed.
Lots are normally created in SOS Inventory when they are added via an item receipt. The exception to this rule is when lots are used in an adjustment transaction. If a new lot is needed to add quantity in the adjustment, go to the Lots list (Operations menu > Inventory > Lots), then select Add new. Complete the fields for Lot number and Description, choose the lot item from the Item dropdown, and select the lot's Expiration date. If the lot has been recalled, check the Recalled box. The new lot will then appear in the adjustment's Lot dropdown.
To view the history of a lot, go either to: (1) the Lots list (Operations menu > Inventory > Lots) and use the item’s Actions menu to select Transaction history; or (2) the Lot history report (Operations menu > Reports > Inventory > Lot history) to view the history of one or more lots.