Lots

Overview

Lot numbers are assigned to a particular quantity, batch or grouping of a manufactured product in order to give traceability from raw material to consumption.   In CustomBooks™, lots are recorded on the item receipt for purchased goods and assigned on assembly builds for manufactured products.   In contrast to a serial number, a single lot number can refer to many of the product to which it is assigned.

Enabling Lots

Lots are disabled by default.    To enable them, navigate to Quick Menu / Settings / inventory and check the checkbox labeled Use Lots/Serial Numbers.

Setting up an Item to Use Lots

Once enabled, the items in your inventory that will use lots will need to be setup.

To setup your item, 

1. Go to Inventory / Items and double click the item*.
   
2. On the lots/serials numbers drop down, choose lots.
   
3. Click the Lots Tab.
   
4. Pick a Lots type.  You can use Lot Number / Expiration or create a Characteristic.
   
5. Presentation / Characteristic

1. If you choose Lot Number / Expiration, choose how you'd like them to be presented in the software.   Choices are:   Lot number, Expiration Date, Lot number + expiration date or expiration date + lot number.   You may create lots at this time for existing inventory by clicking the Lots link at the top.
   
2. If you choose Characteristic, create the characteristics
   

.

Adding Lots when Receiving Items.

When you receive items ordered on a Purchase Order that use lots there will be a lot field on those lines.   Before saving the Item Receipt (or Bill), you must choose a lot for each of the units received.

1. To receive the same item into multiple lots, split the quantities on separate lines so that there is one lot per line.
   
2. If the lot does not exist when received, you may create it in the lot assignment dialog.
   
3. If you are using multi-location and need to receive multiple lots in multiple locations, use one line per lot / location combination.
   

CustomBooks™ will keep track of the quantities on hand, which lots they belong to and which location these items are stored.

Recording Lots on Sold Items

When selling items that use lots, the lot numbers of the item sold must be recorded on the Shipment (or Sales Invoice).   Choose the lots that were sold from the lot dialog and quantities will be decreased when saving the document.

Related Articles:   Lot Adjustments

• Related Articles

• Print lot labels from Item Receipt

  Introduction This extension allows users to print labels with lots and barcodes for received items directly from the Item Receipt screen. Installation Please see the article on Managing Extensions for installation instrucitons. Usage On the item ...

• How to create a product item?

  Creating a Product Item CustomBooks™ has two types of items: Product and Service. The big difference is that Product items are tracked in inventory. To create an product item : Navigate to Inventory → Item. Click Create. Enter an item Code (product ...

• Creating Sales Invoices

  Sales Invoices track sales of products or services for inventory control and for tax and accounting purposes. Sales Invoices record a customer’s liability to you and record income from the transaction. The calculations made on Sales Invoices are also ...

• How to create a service item?

  Creating a Service Item Service items differ from product items in that are not tracked in inventory. To create a service item : Navigate to Inventory → Item. Click Create. Enter an Item Code (product number, sku, etc). Enter a Description for the ...

• Inventory Journal (with and without lots)

  Introduction This dynamic report totals up and shows details of all transactions, including opening and closing balances (5), receipts and expenses (3,4), and/or item(s) (1) for a defined period split by location (2). The report has many great ...