Note that you can click the button (or press F5) to invoke field help at any time from within the job panel itself.

Business Benefits

The ability to translate Manufacturer's Date code dates may be required in order to allow the Warehouse to rotate stock according to a release or expiry date. This program allows you to set up a variety of code date formats and attach them to Products.

The purpose of this functionality is to:

• enforce the data entry of only valid date code formats during receiving, and
• automatically calculate the Expiry (Release) date from the Manufacturer's Date code for Products that are released by this date.

Note: For related documentation and workflows, see CR - Client Related.

Usage

Use this job to set up Lot code date formats as follows:

Define a "Method Code". This is a 2-character code that will determine how this particular code date format is to be referred to (e.g., "J1" could mean Julian Date code format #1, which might be in the form 5032, where

• the first digit denotes the year (e.g., 5 = 1995)
• the next three digits denote the Julian date (e.g., day 032 of the year); the system will then be set up to recognize this code and translate it to an actual date of February 1, 1995.

This functionality is used during Receiving in programs RE.11 [In-Transit Receipts], RE.21 [Receipts], or RE.31 [Receipt Invoices] and it can be applied to either the Lot code field, the Lot Identity field, or the Extra field.

For instance, the operator may enter a different number in the Lot Code field, then enter the Manufacturer's Lot code in the Lot Identity field. Alternatively, they may enter the Manufacturer's code date in the Lot Code field. The setup in this program allows for either situation.

If the "Extra field" option is used, the operator may use both Lot Code and Lot Identify for other purposes, and instead enter the code date in the Extra field that will appear in receiving. The purpose of the Extra field is only to allow entry of the code date and the original date is not stored on the system.

During the receiving process, the system will do the following:

• When the Product code is entered, it will display the Method Code description. This is meant to guide the operator when he enters the Julian date code (e.g., if the system requires YYMMDD, this should be part of the Method Code description so that the operator will see this).
• If the Julian Date Code is entered in a different format, the system will warn the operator of this. Invalid Date Code formats will not be allowed.
• The system calculated date is automatically updated to the "Expiry Date" of the Lot.

Note that a Method Code may be attached to Products that are NOT defined as Release-Dated. The purpose of this is to still enforce the format of the Lot Code or Lot Identity even though no actual Release Date calculation takes place.

Preconditions

This program applies only if Component *LRD* (Lot Release Date) has been set up in program WP.43 [Global Lot Components].

Lot Set codes need to be set up in programs WP.44 [Lotting Data Sets] and assigned in program WP.46 [Lotting Assignments].

Subsequent Actions

The date code conversion occurs in various programs, including:

OE.01 [Enter Orders (Shipping)]

OE.06 [Pick Confirmation]

OE.20 [Confirm or Modify Shipments]

OE.21 [Enter Shipped Orders]

RE.21 [Receipts]

RE.31 [Receipt Invoices]

OR.20 [Lots - Maintain / Adjust]

and OR.43 [Stock - Inquiry].

Program Fields and Functions

To review a text version of the field help, click here. Click the button (or press F5) to invoke field help at any time from within the job panel itself.