Understanding Shipment Ascending Date Rules

Shipment ascending date rules enable you to ship product based on lot dates that are greater than or equal to the dates of the last shipment. These dates include the expiration date, best before date, or sell by date. You can specify date ascending rules for any combination of customer, customer group, product, or product group.

You can use these criteria to review recent shipments to a customer:

• Last lot number

• Last expiration date

• Last best before date

• Last sell by date

• Highest lot number

• Highest expiration date

• Highest sell by date

• Highest best before date

The system uses values from the expiration date, sell by date, best before date, or user-defined date options 1 through 5 in the F4239 table to compare the dates on the item that is being hard committed, depending upon the commitment date method that is specified on Item Master Revisions form or the Preference Values Revisions form. When you hard commit a lot, the system edits the ship ascending rules with the specified lot using the Last Customer Shipment table during these events:

• Sales order entry

• Pick confirmation override

• Manual planner

• Ship confirmation

The system stores ascending rules in the F49211 table. The system might also use these tables when processing information:

• F40721

• F4009

• F4600

  Note: After you set up ascending date rules for lot shipment, verify that Lot Shipment Ascending Dates is enabled in the system constants, as well as the Display Warning/Error for Ascending Date Rule Check processing option on the Process tab in Sales Order Entry program (P4210). The system displays a warning when you manually enter a lot number on the order. You can also override the schedule for advanced preferences on the Preferences tab in processing options for the P4210 program.

See also:

• Setting Up Dates for Lots.