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 Transfer, the quantity available is decreased. The available quantity is initially updated by Purchase Receipt of Inventory Entry and Transfer Receipt of Inventory Entry.

If you manually create a new lot for linear cut products in Product Extended Lot Number Setup, you should manually create cut pieces on the Cuts tab to match the available quantity specified here.

Bin Location #1 and #2

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

For example:

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

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

Case Quantity

The quantity in each case for a specific lot. The case quantity for a product may vary based on the vendor.

Closed

Set when the last quantities are sold or transferred. If the last quantities become unavailable, then 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 Invoice Center Entry-PO Costing or Transfer Receipt of Inventory Entry automatically update this field.

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

Country of Origin

The country in which the lot was manufactured, produced, or grown.

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.

Mfg Lot #

The lot number from the manufacturer. This number may be different than the lot number assigned by the distributor.

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. This value is set when the lot record is created through Purchase or Transfer. If you use TWL, then this date is the receipt date that is 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, then select 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.