New SCV entities and program for purchasing

New SCV entities have been added to hold item-supplier combinations, time-phased purchase prices and (calculated) daily purchase prices. A new SCV program is now available to calculate daily purchase prices.

Time-phased purchase price details for procured items are now modelled in SCV. Price details can be either imported from the ERP or manually specified in SCV for each item-supplier-purchasing organization combination.

These new SCV entities have been added:

  • ITEM_SUPPLIER
  • PURCHASE_PRICE
  • PURCHASE_DAY_PRICE

These new SCV tables have been registered together with all related configuration (such as constraints, validation rules, Inbox->Core mappings and datasheets):

  • SI_ITEM_SUPPLIER
  • SC_ITEM_SUPPLIER
  • SM_ITEM_SUPPLIER
  • SI_PURCHASE_PRICE
  • SC_PURCHASE_PRICE
  • SM_PURCHASE_PRICE
  • SI_PURCHASE_DAY_PRICE
  • SC_PURCHASE_DAY_PRICE
  • SM_PURCHASE_DAY_PRICE
Note: Currently, the new added PURCHASE_PRICE and PURCHASE_DAY_PRICE entities are considered as transactional data entities. User Data (Planning Configuration - SM) tables for these entities are created to allow manual entry of purchase prices. However, by default, User Data in Planning Configuration tables are not included in Inbox > Core transfers. To move manually specified PURCHASE_PRICE and PURCHASE_DAY_PRICE entities in Core, the SCV - Transfer Transactional Inbox to Core Full macro must be altered to pass the INCLUDE_USER_DATA=Y additional parameter to the EXECUTE_TRANSFER program called by the macro.

These table groups have been updated:

  • Master_Inbox
  • Master_Core
  • Transactional_Inbox
  • Transactional_Core
  • Supply_Master_Inbox
  • Supply_Master_Core
  • Supply_Transactional_Inbox
  • Supply_Transactional_Core

These macros have been updated to process the imported item supplier and purchase price details:

  • SCV - Inbound All Full
  • SCV - Inbound Master Full
  • SCV - Inbound Transactional Full
  • SCV - Inbound Supply All Full
  • SCV - Inbound Supply Master Full
  • SCV - Inbound Supply Transactional Full

A new SCV program is now available that calculates a daily purchase price for each item-warehouse-supplier combination. The number of combinations is limited, using the imported item-supplier and item-sourcing data. If a specific price is available for a given item-warehouse-supplier combination for a specific day, that price is used. Else, a more generic price at item-supplier level or at item-warehouse level is used.

Prices are calculated for each day in the planning horizon, as specified by the SCP_DEFAULT_HORIZON_END_OFFSET_DAYS SCV configuration parameter.

This new SCV program is now available:

  • TFORM_CALC_PURCHASE_PRICE

This new macro has been added to execute the new program:

  • SCV - Transform Calculate Purchase Price
Note: This feature is enabled after appending the base template (base.zip) for this version. No additional role or privilege is required to access this feature.