Import item supplier and purchase price details from M3

Suppliers, sourcing rules and supplier capacity have been imported from M3. Now item-supplier combinations and time-phased purchase price details are also imported from M3.

The item-supplier combinations in M3 do not necessarily include all items that have "purchase" as defaulting sourcing method. In order to provide a complete list of item-supplier combinations in SCV, during the import from M3, item-supplier combinations from sourcing rules are extracted and included in the import.

Time-phased purchase prices imported from M3 are at item-supplier level. In M3, two time-phased purchase prices can be specified at item-supplier level; this information is used as the source when importing time-phased purchase prices from M3.

These new BOIs have been added:

  • PPS040MI_LstItemSupplier_ST_M3_IN_PPS040MI_LstItemSupplier
  • PPS040MI_GetItemSupplier_ST_M3_IN_PPS040MI_GetItemSupplier

These new M3 import staging tables have been registered:

  • ST_M3_IN_PPS040MI_LstItemSupplier
  • ST_M3_IN_PPS040MI_GetItemSupplier

These new SCV views have been added:

  • ST_V_M3_ITEM_SUPPLIER
  • ST_V_M3_PURCHASE_PRICE

These new SCV mappings have been added:

  • BASE_ST_V_M3_ITEM_SUPPLIER-SI_ITEM_SUPPLIER
  • BASE_ST_V_M3_PURCHASE_PRICE-SI_PURCHASE_PRICE

These new SCV datasheets have been added:

  • M3 In - ST_M3_IN_PPS040MI_LstItemSupplier
  • M3 In - ST_M3_IN_PPS040MI_GetItemSupplier

These macros have been updated to import item-supplier and purchase price details from M3:

  • SCV - M3 Import Master Full
  • SCV - M3 Import Supply Master Full
  • SCV - M3 Transfer Master Staging to Inbox Full
  • SCV - M3 Transfer Transactional Staging to Inbox Full
  • SCV - M3 Transfer Supply Master Staging to Inbox Full
  • SCV - M3 Transfer Supply Transactional Staging to Inbox Full
Note: This feature is enabled after appending the M3 base integration template (base for m3.zip) for this version. No additional role or privilege is required to access this feature.