Product Extended Lot Number Setup - General field descriptions

Fields are presented in alphabetical order.

Available

The total quantity available for sale. As quantities from this lot are sold through Sales or transferred through Warehouse Transfer, the quantity available is decreased. The available quantity is initially updated by Purchase Entry Receipt of Inventory and Transfer Entry Receipt of Inventory.

Bin Loc #1 and #2

Two bin locations are allowed for each lot in the warehouse stored with this record. Type the primary bin location in the first position and secondary location on the second line. To use the bin locations, type a character in each position. The sections represent the Building/Section/Row/Shelf.

• 01/01/001/001
• 11/11/111/111
• 11/ / /
• 01/12/ /
• 00/00/000/123

These fields are optional. The bin locations print on all pick tickets and physical count sheets to assist you in finding the lots.

Closed

Set when the last quantities are sold or transferred. If the last quantities become unavailable, you can close the lot. Closed lots are not displayed on the Lot Number Entry window in Sales Order Entry.

Cost

The actual cost charged by your vendor or through the transfer. Vendor Transaction Entry PO Costing or Transfer Entry Receipt of Inventory automatically update this field.

If you do not have security to view costs, indicated on SA Operator Setup, this field is not displayed.

Expire

For those products that have a limited shelf life. You are not prevented from it, but, you should no longer sell the lot when the expiration date is reached. The expiration date is displayed on the Lot Number Entry window in Sales Order Entry to notify the operator.

On Hand

The On Hand quantity is the total quantity you currently have on hand for this product. This includes the gross quantity available for sale but not those that are damaged or considered unavailable.

Opened

The date the lot quantities are available for sale. Set when the lot record is created through Purchase or Transfer. If you use TWL, this is the receipt date specified by the RF operator during receiving.

Status

Initially the status is Active. When the entire lot is allocated, the status changes to Inactive. if you do not want to sell from a particular lot at this time, choose Hold.

Unavailable

The quantity of the lot that is not available for sale. The quantity unavailable can be updated through Sales, Product, Purchase, or Transfer.