How the Suggested Due Dates and In Receiving Measure Are Calculated for On-Hand Lots with Hold Dates

The suggested due date for an on-hand lot is defaulted to its hold date. The lot quantity is shown in the In Receiving measure for the suggested due date.

These points explain how the suggested due dates and In Receiving measure are determined for on-hand lots with hold dates in replenishment plans:
  • The suggested due date for an on-hand lot is set to its hold date after the manufacturing calendar for the organization is considered.
  • If the on-hand lot has no hold date, the suggested due date is set to the plan run date, and the lot appears under the On Hand measure on Day 1.
  • If the hold date coincides with a holiday, the next working day is set as the suggested due date.
  • If the hold date is greater than the plan run date, the lot quantity is shown in the In Receiving measure for the hold date.

    The In Receiving measure is treated as another source of supply and is included in the Total Supply and On Order measures. The On Order measure is considered from Day 1 for the In Receiving measure.

    You can drill from the In Receiving measure to an order of the on-hand type in the Supplies and Demands table for the suggested due date.

  • The supply that's reflected in the In Receiving measure is consumed from the suggested due date to the expiration date, and the unconsumed quantity is reflected in the Expired Lot Quantity measure.

Example 1

Consider this example in which the suggested due date is determined from the hold date, and the In Receiving measure reflects the lot quantity.

Figure showing Example 1 for determination of the suggested due date and In Receiving measure
Note: The In Receiving measure shown for the Replenishment Workbench isn't available in that table by default and must be added to the table.

Note these points about the example:

  • We have four lots. For Lots 1234 and 1235, no hold date is specified. For Lots 1236 and 1237, hold dates are specified.
  • When these lots are processed, the suggested due date is set to the hold date for Lots 1236 and 1237 in the Supplies and Demands table.

    For Lots 1234 and 1235, the suggested due date is set to the plan run date, in keeping with the replenishment planning functionality when hold dates aren't specified.

  • For Lots 1236 and 1237, the lot quantities are shown in the In Receiving measure in the Replenishment Workbench for the suggested due dates.
  • In the Replenishment Workbench, the On Hand measure for Day 1 reflects the combined quantity for Lots 1234 and 1235. This measure is shown for Day 1.
  • You can drill from the In Receiving measure in the Replenishment Workbench to the Supplies and Demands table. The quantity is shown in the Supplies and Demands table under an order of the on-hand type with the suggested due date as the hold date.

Example 2

Consider this example in which we have both hold dates and expiration dates:

Figure showing Example 2 with hold dates and expiration dates
Note: Some measures shown for the Replenishment Workbench aren't available in that table by default and must be added to the table.

Note these points about the example:

  • We have four lots. For Lots 1234 and 1235, no hold date or expiration date is specified. For Lots 1236 and 1237, hold dates and expiration dates are specified.
  • When these lots are processed, the suggested due dates are set to the hold dates for Lots 1236 and 1237 in the Supplies and Demands table.

    For Lots 1234 and 1235, the suggested due dates are set to the plan run date, in keeping with the replenishment planning functionality when hold dates aren't specified.

  • For Lots 1236 and 1237, the lot quantities are shown in the In Receiving measure in the Replenishment Workbench for the suggested due dates.
  • In the Replenishment Workbench, the On Hand measure for Day 1 reflects the combined quantity for Lots 1234 and 1235. This measure is shown for Day 1.
  • The total demand is 10 units on each day.
  • Lot 1236 is consumed completely on Days 5 and 6.
  • Lot 1237 is consumed partially on Days 8, 9, and 10. The Expired Lot Quantity measure for Day 10 is set to 10 units.