In this section we will : 

  1. Describe the source of the One Quote Line Items Price settings




1/ One Quote Line Price Settings

The Object One Quote Line 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 One Quote Line Price Settings fields are updated ONLY when : 

  • Quote is  Cloned, Renewed and One Quote Line Created,  Cloned
  • Account Manager clicks on "Send for Approval
CPC Field RetreivedSourceBusiness Rule
Freight & Duty GuidanceSLV48_Freight_Guidance__c .Cost Guidance
(converted at the OQLI Original Currency & UOM)

We retreive the Cost Guidance (SLV44_Freight_Guidance__c)

Record type : "Freight Cost" 

If  (existing combinaison : Shipping Plant Code  x Product Code x Ship-To Code x Shipping plant region x ShipTo Region x Invoterms)

SLV44_Freight_Guidance__c.Record Type ="Freight Cost"
OQLI.SLV47_Shipping_Plants__c.Utility_Plant__c.Name =SLV44_Freight_Guidance__c.Shipping Plant Code
OQLI.SLV44_Product_Level_5__c.ProductCode = SLV44_Freight_Guidance__c.PP_MaterialCode__c
OQLI.Ship To. (PRS_D__c or RCS_ID__c ) = SLV44_Freight_Guidance__c.ShipToPartyCode 
OQLI.SLV47_Shipping_Plants__c.Utility_Plant__c.SLV6_Region__c =SLV44_Freight_Guidance__c.SLV44_Origin_Region_From__c
OQLI.SLV44_Ship_to__c.SLV_Region__c = SLV44_Freight_Guidance__c.SLV44_Destination_Region_To__c
OQLI.Incoterms SLV44_Freight_Guidance__c.Incoterms
  • ==> Select this record


If  (existing combinaison : Shipping Plant Code x ShipTo Country x Product Level 3 Code x Invoterms)


SLV44_Freight_Guidance__c.Record Type ="Freight Cost"
OQLI.SLV44_Product_Level_5__c.Level_3__c.ProductCodeSLV44_Freight_Guidance__c.Level 3 Code
OQLI.SLV44_Ship_to__r.BillingCountryCode = SLV44_Freight_Guidance__c.Ship-to Country Code
OQLI.SLV47_Shipping_Plants__c.Utility_Plant__c.SLV6_Region__c =SLV44_Freight_Guidance__c.SLV44_Origin_Region_From__c
OQLI.Incoterms SLV44_Freight_Guidance__c.Incoterms
  • ==> Select this record


Else if  (existing combinaison : Shipping Plant Region x Ship-To Region x Incoterms )

SLV44_Freight_Guidance__c.Record Type ="Freight Cost"
OQLI.SLV47_Shipping_Plants__c.Utility_Plant__c.SLV6_Region__c =SLV44_Freight_Guidance__c.SLV44_Origin_Region_From__c
OQLI.SLV44_Ship_to__c.SLV_Region__c = SLV44_Freight_Guidance__c.SLV44_Destination_Region_To__c
OQLI.Incoterms SLV44_Freight_Guidance__c.Incoterms


  • ==> Select this record

Else

==> 0


Margin GuidanceVolume Bracket.Market Margin Policy Value (converted at the OQLI  Currency & UOM)Based on the RMP - Volume Bracket
Margin Guidance %Volume Bracket.Market Margin Policy %Based on the RMP - Volume Bracket
Margin Floor (SLV44_Price_Floor_EXW)Manufacturing plant. Price floor EXW(converted at the OQLI Original  Currency & UOM)Based on the Manufacturing Plant 
Variable Manufacturing CostsManufacturing plant. Variable Manufacturing Costs (converted at the OQLI Original Currency & UOM)Based on the Manufacturing Plant 
Asset Margin FloorManufacturing plant.Asset Margin Floor  (converted at the OQLI Original Currency & UOM)Based on the Manufacturing Plant 

Transfer Cost guidance

PP_Transfer_Cost__c . Cost Guidance
(converted at the OQLI Original Currency & UOM)

We retreive the Cost Guidance

Record type : "Transfer Cost"


We retreive the Cost Guidance (SLV44_Freight_Guidance__c)

Record type : "Transfer Cost" 

If  (existing combinaison : Manufacturing Plant x Shipping Plant x Material)

LV44_Freight_Guidance__c.Record Type ="Transfer Cost"
OQLI.SLV44_Manufacturing_Plant__c.Utility_Plant__c.Name = SLV44_Freight_Guidance__c.PP_Manufacturing_Plant_Code__c
OQLI.SLV47_Shipping_Plants__c.Utility_Plant__c.Name =  SLV44_Freight_Guidance__c.Shipping Plant Code
OQLI.SLV44_Product_Level_5__c.ProductCode=SLV44_Freight_Guidance__c.PP_MaterialCode__c


  • ==> Select this record

Else

==> 0



CPC Field CalculatedCalucation done in the code
Price Guidance

  1. OQLI.“Margin Guidance” is not empty

    1. Price Guidance = OQLI. SLV44_Margin_Policy__c +OQLI.SLV44_Variable_Manufacturing_Cost__c + OQLI . Transfer Cost guidance  OQLI. SLV44_Freight_duties__c

  1. If CPC.“Margin Guidance %” is not empty

    1. Price guidance = (OQLI.SLV44_Variable_Manufacturing_Cost__c + Transfer Cost guidance + CPC. SLV44_Freight_duties__c) / (1-OQLI.Margin Guidance %)


Price floor

CPC.Price Floor = 
If ( OQLI.PP_GBU__c = "Novecare" ) {

    • if (OQLI.PP_Asset_Margin_Floor__c = 0 or Empty )
      • {CPC.SLV44_Floor_price__c = empty} else
    • CPC.Price floor   = CPC .PP_Asset_Margin_Floor__c +  OQLI.SLV44_Variable_Manufacturing_Cost__c + OQLI.Transfer Cost guidance +OQLI. SLV44_Freight_duties__c

}

Else   {
  CPC.Price floor   = OQLI.SLV44_Price_Floor_EXW__c +OQLI. SLV44_Freight_duties__c
}