Determine last shipment ID on sales schedule

Infor LN FP6

In Infor LN FP6, if no last shipment ID is communicated by the customer on the incoming sales release, LN cannot determine the last shipment ID, which is required to match customer and supplier cumulatives (CUMs).

New in Infor LN 10

If the sales schedule is based on a sales contract with a linked terms and conditions agreement, in the new Method of Last Shipment ID determination field of the Schedule Terms and Conditions (tctrm1131m000) session, you can specify how the last shipment ID is determined if it is not yet sent by the customer.

This field can have the following values:

  • Customer's Last Shipment
    The last shipment ID must be communicated by the customer on the sales release. This is the default value, which also applies if no terms and conditions agreement is linked. This is the old Infor LN FP6 functionality.
  • Customer's Last Receipt Date
    If, before generation of the sales release, not all shipments that are sent by the supplier are received by the customer, the shipments that are in transit are determined by comparing the last receipt date, sent by the customer, with the planned receipt date in the supplier's (your) system.
  • Customer's Release Generation Date
    If, before generation of the sales release, not all shipments that are sent by the supplier are received by the customer, the shipments that are in transit are determined by comparing the release generation date, sent by the customer, with the planned receipt date in the supplier's (your) system.
  • Supplier's Release Creation Date
    If, before generation of the sales release, not all shipments that are sent by the supplier are received by the customer, the shipments that are in transit are determined by comparing the supplier’s release creation with the planned receipt date in the supplier's (your) system. The assumption is that this release creation date lies close to the customer's release generation date.
  • Supplier's Last Shipment
    The last shipment ID is determined based on the supplier's last dispatched shipment. The assumption is that before generation of the sales release, the supplier's last shipment is already received and, therefore, nothing is in transit.

In the Sales Schedules (tdsls3111m000) session, the new Sent by Customer check box determines whether or not the last shipment ID was sent by the customer.