Lot No Profiles

Article01/10/20245 min read

It is possible to apply a certain structure in a lot number, using a Lot No. Profile. In a Lot No. Profile page, the different parts to generate a lot number are specified, such as a date, conversion code or document number.

Lot No. Profile Setup

On the Lot No. Profile Setup page the different elements that are used to generate lot numbers are set up. The order of the lines in the lot number profile determines the order of the values in the lot number.

  1. Select the Search icon , enter Lot No. Profiles and then choose the related link.
  2. On the Lot No. Profiles list, on the action bar, click New to create a new entry on the Lot No. Profile page.
  3. Enter Code.
  4. Enter Description.

Picture1

A lot number can consist of different types of elements, which require different settings. In the description below, the different elements are shown with their setting.

Date Elements

  1. On the Lot No. Profile page, on the Lines FastTab, click the Element field.

  2. Select the required option from the dropdown menu.

    Picture1

  3. Select one of the following options from the list:

    • Year Number Long
    • Year number Short
    • Month Number
    • Week Number
    • Week Day Number
    • Day Number
    • Hour Number

When selecting one of the above date element types, the Use Date field is mandatory. The Use Date field specifies the date that is used for generating the value for the selected element.

  1. Click the Use Date field.
  2. Select and click the required option from the dropdown menu.

For the element Hour Number, the actual hour of the moment creating the lot number is taken, so it is not possible to enter a use date.

  • Work Date: This is the work date that is set up in My settings at the moment the lot number is created.
  • Expiration Date: The expiration date is based on the expiration date entered in the item tracking line. If this field is empty and the toggle Require Expiration Date is turned off in the item tracking code, the expiration date will be based on the Expiration Calculation field on the item card. If this field is empty or the Require Expiration Date toggle is turned on, the Expiration Date field on the item tracking line needs to be filled manually before assigning a lot number.
  • Starting Date: The starting date is used from the production order from which the lot number is created. This date can be used together with the ending date if a production order consists of several steps. For example, if the production order exists of a production and packaging step, in most cases the production date will be similar to the starting date and the packaging date will be similar to the ending date. If no starting date is available, because the lot number is created from another document than a production order, then the work date is used here.
  • Ending Date: The ending date is used from the production order from which the lot number is created. If no ending date is available, the work date is used here.
  • Production Date: The production date is considered based on the date that is entered in the Lot Production Date field on the relevant Production Order page. This Production Date option is displayed only for the Year Number Long, Year Number Short, Month Number, Week Number, Weekday Number, Day Number, Year Code, Month Code, Week Code, Weekday Code, Day Code, Julian Date, and Julian Day elements.
Note

This Production Date option is displayed only if the Aptean Expiration Management extension is installed. If the Aptean Expiration Management extension is uninstalled after selecting this option, the Use Date field is reset to the Work Date option.

Date Conversion Elements

  1. Click the Element field and select the required option from the dropdown menu.
    For using a code from the date conversion table, select one of the following options from the list:

    • Year Code
    • Month Code
    • Week Code
    • Week Day Code
    • Day Code

    When selecting one of the above date codes, both fields Value and Use Date are mandatory.

  2. Click the lookup button in the Value field.

  3. Select and click the required Code. The available date conversion codes are shown. See Lot Date Conversion for more information about setting up the date conversion codes.

Picture1 4. Click the Use Date field. 5. Select and click the required option from the dropdown menu.

Lot No. Series Element

It is possible to add a created number series from the No. Series Table. For example, it is possible to add a number series that automatically increases (a part of) the lot number when creating it.

  1. Click the Element field and select the No. Series option in the list.
  2. Click the Value field.
  3. Select and click the required number series.

Picture1

Lot Elements for Vendor, Work center or Machine center

Lot elements for vendors, work centers or machine centers are short codes, of up to 4 characters, that specify which work/machine center or vendor is linked to the lot number.

  1. Click the Element field.
  2. Select one of the following options from the dropdown menu:
    • Work-/Machine center Element
    • Vendor Element
  3. When creating the lot number, the element values that are set up on the corresponding Vendor, Machine and/or Work center card are copied to the lot number. See Set up Lot Elements for more information. If the element is not specified on the Vendor, Work- or Machine center card or the lot no is created when no vendor or work-/machine center is available in the source document, then a fall-back value is required. This fall-back value, of up to 4 characters, must be specified in the ”Value” field.

Fixed Value

It is possible to specify a fixed value that should be part of the lot number. As an example, this fixed value can be used to split different lot elements with a punctuation mark, such as - or /.

  1. Click the Element field.
  2. Select the Fixed value option from the dropdown menu.
  3. Click the Value field and enter Value.

Picture1

A lot no. profile with different lot no. element lines is now set up. The profile can now be selected on an item card, so lot numbers will be generated based on this profile. See the topic Set up Lot No. profile for an Item” for more information.