Versions Compared

Old Version 2

changes.mady.by.user Bablot-ext, Romain

Saved on

compared with

New Version Current

changes.mady.by.user Bablot-ext, Romain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 : 

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

We retreive the Cost Guidance (SLV44_Freight

Guidance the same way as the Quote

Record type : "Freight Cost"

_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

Jira
serverJira
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyIPP-3012


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 Guidance
Market Margin Policy Value
Volume Bracket.Market Margin Policy Value (converted at the
CPC Original
OQLI  Currency & UOM)Based on the RMP - Volume Bracket
set in the CPC
Margin
Policy
Guidance %Volume Bracket.Market Margin Policy %Based on the RMP - Volume Bracket
set in the CPCEXW Asset Price Floor
Margin Floor (SLV44_Price_Floor_EXW)Manufacturing plant. Price floor EXW(converted at the
CPC
OQLI Original  Currency & UOM)Based on the Manufacturing
Plant SKU in the CPC
Plant 
Variable Manufacturing CostsManufacturing plant. Variable Manufacturing Costs (converted at the
CPC
OQLI Original Currency & UOM)Based on the Manufacturing
Plant SKU in the CPC
Plant 
Asset Margin FloorManufacturing plant.Asset Margin Floor  (converted at the
CPC  Original
OQLI Original Currency & UOM)Based on the Manufacturing
Plant SKU in the CPC
Plant 

Transfer Cost

guidance

Jira
serverJira
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
keyIPP-1519

PP_Transfer_Cost
SLV44_Freight_Guidance
__c .
Freight
Cost Guidance
(converted at the
CPC  Original
OQLI Original Currency & UOM)

We retreive the Cost Guidance

Record type : "Transfer Cost"


We retreive the Cost Guidance (SLV44_Freight

Guidance the same way as the Quote

_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
CPC

  1. OQLI.

“Market

  1. “Margin

Policy Value”

  1. Guidance” is not empty

if (“Market Margin Policy Value” = 0 ) {Price Guidance = CPC. Market Margin Policy Value +CPC.Variable Cost + CPC. Freight
    1. Price Guidance =
empty } else
    1. OQLI. SLV44_Margin_Policy__c +OQLI.SLV44_Variable_Manufacturing_Cost__c + OQLI . Transfer Cost guidance  OQLI. SLV44_Freight_duties__c

  1. If CPC.“Margin

Policy Price guidance = (CPC.Variable Cost + CPC. Freight

  1. Guidance %” is not empty

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

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

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

    Business rule changed/update 

    Jira
    serverJira
    columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
    columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
    serverIdbbf5f9ee-7f3e-3274-bb6e-be12673f2166
    keyIPP-1866


    Price floor

    CPC.Price Floor = 
    If (

    CPC

    OQLI.

    PricingCampaign.GBU

    PP_GBU__c = "Novecare" ) {

      • if (
    CPC
      • 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 +
     CPC
      •  OQLI.
    Variable Costs + CPC. Freight
      • SLV44_Variable_Manufacturing_Cost__c + OQLI.Transfer Cost guidance +OQLI. SLV44_Freight_duties__c

    }

    Else   {
      CPC.Price floor   =

    EXW Price floor + CPC. Freight
    }Variable CostCPC.Variable Cost = CPC .Variable Manufacturing Costs + CPC.Transfer Cost Guidance

    OQLI.SLV44_Price_Floor_EXW__c +OQLI. SLV44_Freight_duties__c
    }