Extension to Preferred Lot/Replenishment Days calculation (Inventory)

Previously, the IPLS_PREFLOT_OR_REPLENDAYS measure can have the following values:

  • 0: Use Preferred Lot
  • 1: Use Replenishment Days

Preferred Lot/Replenishment Days calculation logic has been updated. The measure can now have the following values:

  • 0: Manual Preferred Lot Qty
  • 1: Manual Replenishment Days (days between orders)
  • 2: EOQ QTY
  • 3: Adjusted EOQ to the nearest increment of 7 days
  • 4: Adjusted EOQ to the nearest increment of batch (Units per Storage Unit)

These interface services have been updated to use the new properties in SCV:

  • IPLS - SCV - Import Inventory Measures: Updated interface service query and import mappings for measure IPLS_PREFLOT_OR_REPLENDAYS
  • IPLS - SCV - Import Previous Inventory: Updated interface service query and import mappings for measure IPLS_PREFLOT_OR_REPLENDAYS
  • IPLS - SCV - Publish Simulation: Updated interface service export mappings for measure IPLS_PREFLOT_OR_REPLENDAYS

Action required prior to activation:

These interface services now use newly created properties in SCV. Previously, used SCV properties are now deprecated. Existing custom import mappings for the deprecated properties must be adjusted and existing data in the deprecated properties must be migrated to the new properties.

The INVENTORY.inv_use_order_freq_flag and ITEM_LOCATION.inv_use_order_freq_flag deprecated properties are not part of any standard ERP integration. If there are any custom import mappings to populate these deprecated properties, the custom import mappings must be adjusted to populate the new properties instead.

If the values are specified manually in the INVENTORY.xs_inv_use_order_freq_flag and ITEM_LOCATION.xs_inv_use_order_freq_flag deprecated extension properties, these are not migrated by the migration macro mentioned above. Values in the deprecated extension properties must be copied manually to the new extension properties.

For both, updating the custom import mappings and migrating the deprecated extension property values, the following data mappings must be used:

  • When inv_use_order_freq_flag = "N" then inv_preflot_or_replendays = 0
  • When inv_use_order_freq_flag = "Y" then inv_preflot_or_replendays = 1
  • When inv_use_order_freq_flag = <empty> then inv_preflot_or_replendays = <empty>
Note: This feature is available after loading the demand (dpls.zip) template for this release. You are not required a new role or privilege access to use this feature.