Product Extended Lot Number Setup - General overview

Product > Setup > Extended Lot Number

Use this page to set up extended lot numbers for products. Lots must exist in Product Extended Lot Number Setup before they can be sold in Sales Order Entry or transferred in Transfer Entry.

Lots differ from serial numbers because a serial number is one record per unit whereas a lot contains several units per record. You may sell from a lot until all quantities are depleted.

Product Extended Lot Number Setup is not used often. The most frequent use is inquiring on existing records.

After you receive a lot product through a purchase order or transfer, the Product Extended Lot # record is updated with the allocated quantity. In Purchase Receipt of Inventory Entry or Transfer Receipt of Inventory Entry, lot records must be entered for each lot product. Lot numbers for build-on-demand kit components are carried to the tied order entry line item, based on the sequence number of the kit component.

You can enter the lots for a product in Sales Order Entry or Sales Shipping Feedback Entry. You cannot perform Sales Entry Processing Invoice Processing until you have entered all lots. If a lot product is returned, the lot number record is de-allocated in Sales Entry Processing Invoice Processing. During warehouse transfers, the lot numbers must be entered when the transfer is entered or during Transfer Shipping Feedback Entry.

Special costing products are indicated with the appropriate special cost unit beside the Cost field. If your operator record does not allow you to view costs, the Cost field is not available.

If you print labels in TWL, you can now add information such as the lot number, country of origin, and manufacturer's lot number from Product Extended Lot Number Setup to these labels:

  • Item label
  • Picking label
  • Receiving label
  • Shipping label
  • SCM label

Storeroom

When lot numbers are created in the Regrind in Receipt function in Storeroom, this information is saved in Product Extended Lot # Setup:

  • Lot number
  • Bin location
  • Open date
  • Expire date

Product Certificates

This section displays all the product certificates that are defined on the SA Table Code Value Setup-Product Certificate Type screen. You can assign these certificates to the lots for a product to indicate that the certificates are required upon product delivery.

The Certificates grid includes these details:
  • Certificate Required: A checkbox to assign the certificate to the lot for a product. The selected certificates are listed in the Assigned Certificates field.
    Note: The default selection of this checkbox is based on the selection of the Default to Lot checkbox on the Special Handling tab of the Product Setup screen.
  • Certificate Type: The name of the certificate as defined on the SA Table Code Value Setup-Product Certificate Type screen.
  • Description: The description of the certificate as defined on the SA Table Code Value Setup-Product Certificate Type screen.
  • Product Certificate Active: The status of the certificate as defined on the SA Table Code Value Setup-Product Certificate Type screen.
  • Receiving Type: Indicates whether the certificate is required from the vendor or supplier upon receiving, as defined on the SA Table Code Value Setup-Product Certificate Type screen.
  • IDM Document Type ID: The IDM document ID as defined on the SA Table Code Value Setup-Product Certificate Type screen.
    Note: You must use Personalization to view this field.
  • IDM XQuery Attributes: The IDM query attributes as defined on the SA Table Code Value Setup-Product Certificate Type screen.
    Note: You must use Personalization to view this field.