Using lead time when importing purchase orders from M3

Open purchase orders are extracted from planned material transactions in M3. As a result, requirement date has been populated on the purchase orders while the requested ship and requested delivery dates have not been populated during the import. In order to populate these two date columns, which are used by Supply Planning, the import mappings for purchase orders have been changed.

Requested delivery date is mapped to the same value as requirement date.

Requested ship date is calculated from requirement date using purchasing lead times.

These new views are now available:

  • SC_V_UTIL_PURCHASE_LEAD_TIME: Selects purchasing lead times from sourcing rules and from item-location combinations. User-defined values in extension columns as well as imported values in the main Core tables are selected.
  • ST_V_M3_UTIL_PURCHASE_LEAD_TIME: Applies the same logic as SC_V_UTIL_PURCHASE_LEAD_TIME, however, on the newly imported data in staging tables.

These views are updated:

  • ST_V_M3_PURCHASE_OPEN_TRX: Uses the purchasing lead time from the new views to calculate the requested ship date from requirement time. Purchasing lead time is determined in this order:
    1. User-defined purchasing lead time from sourcing rules in Core
    2. Imported purchasing lead time from sourcing rules in staging
    3. Imported purchasing lead time from sourcing rules in staging
    4. User-defined purchasing lead time from item-warehouse combinations in Core
    5. Imported purchasing lead time from item-warehouse combinations in staging
    6. Imported purchasing lead time from item-warehouse combinations in staging.

    Sourcing rule effective at the time of order's requirement date is selected.

    Note: The related content is available after loading the base template (base.zip) and M3 template (base for M3.zip) for this release. You are not required to have a new role or privilege access to use this feature.