You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

In this section we will : 

  1. Describe the source of the Pricing Campaign CPC Price Settings
  2. Describe the process that set the CPC Price Setting


Here is specification of the batch and fields : Specification - CPC Price Setting Update - Google Slides

1/ Pricing Campaign CPC Price Settings

The Object CPC contains fields retreived from the Price Settings. The objective is that the most accurate, the most up to date and the same prices are retreived in CPC and One Quote Line Item (OQLI)

The CPC Price Settings fields are updated when : 

  • CPC is created
    • Whenever a PAM team member load a CPC in SF we retreive all Price Setting CPC.
  • Refresh Price Setting CPC is launched
    • We let the possibility to the PAM team to refresh the Price setting whenever thy want.
  • OQLI is deleted
    • Everytime a OQLI is deleted and was link to a CPC, the CPC can be Editable again. In that case the Account Manager can change the commited price. For that reason the CPC Price Settings need to be updated



From a technical perspective when we retreive the Price Settings CPC we : 

  1. Store the values retrieved in Number fields
  2. Calculate dependent fields based on the CPC values


We do not user SF formula fields because we don't want that any value changes in the CPC is there is a later update on the price settings. 

This feature makes sure that we always save all data that te Account Manager used to set his decision of the commited price

CPC Field RetreivedSourceBusiness Rule
FreightSLV44_Freight_Guidance__c . Freight Cost Guidance (converted at the CPC  Original Currency & UOM)We retreive the Freight Guidance the same way as the Quote
Market Margin Policy ValueVolume Bracket.Market Margin Policy Value (converted at the CPC Original Currency & UOM)Based on the RMP - Volume Bracket set in the CPC
Margin Policy % Volume Bracket.Market Margin Policy %Based on the RMP - Volume Bracket set in the CPC
EXW Asset Price Floor Manufacturing plant. Price floor EXW(converted at the CPC Original  Currency & UOM)Based on the Manufacturing Plant SKU in the CPC
Variable Manufacturing CostsManufacturing plant. Variable Manufacturing Costs (converted at the CPC Original Currency & UOM)Based on the Manufacturing Plant SKU in the CPC



CPC Field CalculatedCalucation done in the code
Price Guidance

  1. “Market Margin Policy Value” is not empty

    1. Price Guidance = CPC. Market Margin Policy Value + CPC .Variable Manufacturing Costs + CPC.Variable Manufacturing Costs (forward)+ CPC. Freight

  2. If “Margin Policy %” is not empty

    1. Price Guidance = CPC .Variable Manufacturing Costs (forward) + CPC. Freight + (CPC .Variable Manufacturing Costs (forward) + CPC. Freight ) * CPC. Margin Policy %


Price floor Price floor = CPC . EXW Asset Price Floor + CPC. Freight

2/ The process that set the CPC Price Setting

2.1/ CPC Creation

At Creation if we are not able to find a SLV44_Freight_Guidance__c,Volume Bracket, Manufacturing plant then, an error message does not allow the creation of the CPC.

If everything is found then the CPC is created the the price settings is set.

/!\ If Price Guidanceor Price Floor is loaded at creation they will be overwritten by the CPC Price Setting calculation

2.1/ Refresh Price Setting CPC by PAM Team

The PAM team has a specific button available on the Pricing campaign.

This button is visible by the following Profile


This allow the PAM team to launch the batch to refresh ALL CPC or Selected CPC from one specific region.

It let them the possibilty to send an Email to impacted users with a specific text message.


When they click on Update , the batch starts in the background and the user can continue working.


When the Batch finishes, the user that lunched the flow will receive an email that contains the number of success CPC update and a report link to ALL CPC that could not be upadted.



Provide Here a screenshot of the Report.



  • No labels