9 Cost Chances

Suppliers often change the cost of items.

Cost is an important factor in individual transactions and many financial calculations in RMS. Changes in cost must be reflected in the information stored in RMS and pending transactions.

Batch Design Summary

The following batch designs are included in this functional area:

sccext.pc (Supplier Cost Change Extract)
ccprg.pc (Cost Change Purge)

sccext (Supplier Cost Change Extract)

Module Name	sccext.pc
Description	Apply Pending Cost Changes to Items
Functional Area	Cost Change
Module Type	Business Processing
Module Technology	ProC
Catalog ID	RMS355
Runtime Parameters	NA

Design Overview

The sccext module selects supplier cost change records that are set to go into effect the next day and updates the RMS item/supplier/country tables with the new cost. The item/location tables are also updated with the new cost if the cost change impacts the primary supplier/country for an item/location, as this is considered a base cost change. The process also triggers a recalculation of cost and deal application for pending purchase orders.

Scheduling Constraints

Table 9-1 Scheduling Constraints

Schedule Information	Description
Frequency	Daily
Scheduling Considerations	NA
Pre-Processing	NA
Post-Processing	prepost sccext post
Threading Scheme	Threaded by cost change

Restart/Recovery

The logical unit of work for the program is a cost change. The program is also restartable from the last successfully processed cost change record.

Key Tables Affected

Table 9-2 Key Tables Affected

Table	Select	Insert	Update	Delete
COST_SUSP_SUP_HEAD	Yes	No	No	No
DEAL_CALC_QUEUE_TEMP	Yes	No	No	No
DEAL_CALC_QUEUE	Yes	Yes	Yes	No
PERIOD	Yes	No	No	No
ITEM_SUPP_COUNTRY_LOC	Yes	No	Yes	No
COST_SUSP_SUP_DETAIL	Yes	No	No	No
DEAL_SKU_TEMP	No	Yes	No	No
PRICE_HIST	No	Yes	No	No
ITEM_SUPPLIER	Yes	No	Yes	No
SUPS	Yes	No	No	No
SYSTEM_OPTIONS	Yes	No	No	No
COST_SUSP_SUP_DETAIL_LOC	Yes	No	No	No
ITEM_SUPP_COUNTRY	Yes	No	Yes	No
ITEM_SUPP_COUNTRY_BRACKET_COST	Yes	Yes	Yes	No
ITEM_MASTER	Yes	No	No	No
PACKITEM	Yes	No	No	No

Design Assumptions

This module should only be run if contracting is turned on in the system.

ccprg (Cost Change Purge)

Module Name	ccprg.pc
Description	Purge Aged Cost Changes
Functional Area	Cost Change
Module Type	Admin
Module Technology	ProC
Catalog ID	RMS476
Runtime Parameters	NA

Design Overview

This program is responsible for removing old cost changes from the system. Cost changes are removed from the system using the following criteria:

The status of the cost change is Delete, Canceled, or Extracted.
The status of the price change is Rejected and the effective date of the cost change has met the requirement for the number of days that rejected cost changes are held.

The number of days that rejected cost changes are held is determined by the system parameter Retention of Rejected Cost Changes (RETENTION_OF_REJECTED_COST_CHG).

Scheduling Constraints

Table 9-3 Scheduling Constraints

Schedule Information	Description
Frequency	Monthly
Scheduling Considerations	NA
Pre-Processing	NA
Post-Processing	NA
Threading Scheme	NA

Restart/Recovery

Key Tables Affected

Table 9-4 Key Tables Affected

Table	Select	Insert	Update	Delete
PERIOD	Yes	No	No	No
PURGE_CONFIG_OPTIONS	Yes	No	No	No
COST_SUSP_SUP_HEAD	Yes	No	No	Yes
COST_SUSP_SUP_DETAIL	Yes	No	No	Yes
COST_SUSP_SUP_DETAIL_LOC	Yes	No	No	Yes