Inventory Receipt for Lot Numbers Split/Product Break Down

Inventory Receipts are most commonly used to receive products associated with a purchase order. However, there are situations where a standalone Inventory Receipt is required, such as adjusting lot numbers or converting one product into others.

When using an Inventory Receipt for internal inventory adjustments like these, the session total should always net to $0.00.

• If the session contains a single transaction, you can verify the total in the bottom-right corner of the window.
• If the session includes multiple transactions, preview or print the Inventory Receipt register to confirm the combined total nets to $0.00 before posting.

If the session does not net to zero, your accountant will need to create a general journal entry to move the balance from the purchases account to the appropriate adjustment account.

Split One Lot Number into Multiple Lots

1. Select Inventory menu > Enter Receipts.
2. Click New to create a new session.
3. Select the appropriate Warehouse for this transaction.
4. Enter any optional header information, such as Vendor, Reference, Receiving Document, or Description.
5. Add the lot numbered product being split by typing the Product ID and pressing tab key, or by selecting it from the lookup.
6. In Lot / Serial #, enter the lot number being removed. This must match the original lot number.
7. Enter a negative Quantity to remove the lot quantity.
8. If bin locations are used, enter the Location the lot is being removed from.
9. Verify the Unit Cost matches the original lot exactly.
10. Add the same product again to the session to create the new lot(s).
11. Enter the new Lot / Serial #, along with Expiration Date, Reference, or Specification, if applicable.
    • Use Options > Show Columns to display any additional fields needed.
12. Enter a positive Quantity for the new lot.
13. If using bin locations, enter the Location where the new lot will be stocked.
14. Verify the Unit Cost matches the cost of the lot being removed.
    • If you are not adding the full quantity back to a single lot, confirm the Amount matches the amount being removed.
15. Repeat steps 10–14 for each additional new lot.
16. Confirm the Receipt Total in the bottom-right corner is $0.00.
17. Save the session.
18. Post when ready. This removes the original lot quantity and adds the new lot(s) to inventory.

Break One Product Down to Add Quantity to Other Items

1. Follow the same steps as above through step 9.
   • Ignore step 6 if the product is not lot-controlled and step 8 when not using locations..
2. Enter a negative Quantity for the product being removed.
   • If listed in a bin, enter the Location you are removing the lot number from.
3. If using bin locations, enter the Location the product is being removed from.
4. Verify the Unit Cost matches the current unit cost exactly.
5. Add the product(s) being added to inventory.
   • If the added products are stocked in a different warehouse, Save the session and select Action > + Add Transaction.
     Repeat as needed when breaking products into multiple warehouses.
6. For lot or serial numbered items, enter the appropriate Lot / Serial #.
7. Enter a positive Quantity for each product being added.
8. Verify the Unit Cost or Amount matches the values of the negative line.
   • When allocating cost across multiple products, you’ll need to manually calculate the distribution.
9. When breaking down into multiple products, continue doing steps 4-6 until all products being added to stock are listed.
10. Repeat steps 5–9 until all resulting products are listed.
11. Save the session.
12. Preview the Inventory Receipt register to confirm the session nets to $0.00.
13. Post when ready. This removes the original product and adds the newly created items to inventory.