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 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 Freight Guidance

Record type : "Freight Cost"

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 guidancePP_Transfer_Cost__c . Cost Guidance
(converted at the OQLI Original Currency & UOM)

We retreive the Freight Guidance

Record type : "Transfer Cost"

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
}








OQLI Field RetreivedSourceBusiness Rule
Freight & Duty Guidance

Margin Guidance

Price Floor

Variable Cost

Margin Floor

Transfer Cost guidance
















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

Record type : "Freight Cost"

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
Asset Margin FloorManufacturing plant.Asset Margin Floor  (converted at the CPC  Original Currency & UOM)Based on the Manufacturing Plant SKU in the CPC
Transfer CostSLV44_Freight_Guidance__c . Freight Cost Guidance (converted at the CPC  Original Currency & UOM)

We retreive the Freight Guidance the same way as the Quote

Record type : "Transfer Cost"

CPC Field CalculatedCalucation done in the code
Price Guidance

  1. CPC.“Market Margin Policy Value” is not empty

    1. if (“Market Margin Policy Value” = 0 ) {Price Guidance = empty } else

    1. Price Guidance = CPC. Market Margin Policy Value +CPC.Variable Cost + CPC. Freight

  2. If CPC.“Margin Policy %” is not empty

    1. if (“Margin Policy %” = 0 ) {Price Guidance = empty } else

    2. Price Guidance = CPC.Variable Cost + CPC. Freight + (CPC.Variable Cost+ CPC. Freight ) * CPC. Margin Policy %

    3. Price guidance = (CPC.Variable Cost + CPC. Freight) / (1-CPC.Margin Policy %)

Business rule changed/update  Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Price floor

CPC.Price Floor = 
If ( CPC.PricingCampaign.GBU = "Novecare" ) {

    • if (CPC.PP_Asset_Margin_Floor__c = 0 or Empty )
      • {CPC.SLV44_Floor_price__c = empty} else
    • CPC.Price floor   = CPC .Asset Margin Floor +  CPC.Variable Costs + CPC. Freight

}

Else   {
  CPC.Price floor   = EXW Price floor + CPC. Freight
}


Variable CostCPC.Variable Cost = CPC .Variable Manufacturing Costs + CPC.Transfer Cost Guidance
  • No labels