ie, Warehouses - this is only relevant to calculate the Logistics and Duties variable Costs
What are these? does this mean that the Manufacturing Plant can be different than the Shipping Plant for a specific customer Order, and as such affecting the prices (which would in turn need to be reflected in the Quote sent to the Customer via SF?)
What specific data from the Shipping Plant is required for the purposes of calculating Quote prices?
Ship To - how will this affect pricing in Quotes?
Incoterms - how will this affect pricing in Quotes?
currency field (same as the Currency standard field) - pending further details from Julien - depends on Customer segment - does not need to be captured on RMP for now
Manufacturing Plant - picklist field with values
What Products need to be "quotable" - Level 5 only
Product is meant to be Public Read Only - sharing rules TBD later
Data Issues:
There are currently 15 554 Novecare Level 5 Active Products in Core Production environment. According to Julien, it should be around 3500 Products- data cleanup required and confirmation of SAP integration to check why SF has almost 5X more Active Products in this GBU than it should.
No changes required
“Product Manager” - new lookup to User object required
No changes required (Lookups already existent)
Defined by Active TRUE/FALSE checkbox on Product object
Potential to implement later something similar to the Product Availability of iCare.
No changes required
No changes required
Business Users need to be able to capture certain pricing details on a per Product Level 5 basis - namely the Price Floor and the Variable Manufacturing Costs of each Product. Those values vary per Plant where they are produced.
Solvay Plants are captured in CORE in the object Utilities, specifically those where Type = Plant.
NOE, Julien to confirm that Utilities records in Core where Type = Plant and Involved GBU includes Novecare - correspond to the needed Solvay Manufacturing Plants for Novecare quoting purposes
Defined on a per Manufacturing Plant basis (same product coming from 2 different Utility (Plants) can have 2 different values on Price Floor)
Price Floor is a fixed value that is calculated based on:
Product Level 5 + Manufacturing Plant
only depends on Product - no relation to Market or Region nor Logistics and Duties
Price Floor will be inputted in SF directly per Product Level 5 combination with Manufacturing Plant
Format = Currency (16,2)
Required
Formula field retrieving UOM from Product in Manufacturing Plant object
Track History Changes on all MFP fields
Still required and not built in POC sandbox: a trigger will be required to prevent same Level 5 Product of being linked twice to the same Utility (Plant) - aka, we need to prevent two MFP records from being linked to the same Product.ID and same Utility.ID (both on creation and edit)
Possible:
MFP1 linked to ProductA+UtilityX and MFP2 linked to ProductA+UtilityY
MFP1 linked to ProductB+UtilityY and MFP2 linked to ProductA+UtilityY
Needs to be prevented by Trigger
MFP1 linked to ProductA+UtilityX and MFP3 linked to ProductA+UtilityX
Picklist field with values:
Pricing Policy - computation that starts from Margin Policy (captured at Product Level 4 - varies according to Region, Market and Product); Marketing Directors will be maintaining the Margin Policy
Price Floor
Price Floor will be inputted in SF directly per Product Level 5
Questions:
Minimum Data requirements:
Will all Products always have Pricing for all 4 Regions (APAC/EMEA/NAM/LAM)? No
Will all Products always have the 6 Markets (Agro/Coatings/HPC/IPS/Amines/Not Assigned)? No
Track History:
Validation Rules Required
Duplicate Rule Required
A Level 4 cannot have 2 RMPs for same combination of Region and Market (ie, 2 RMPs for APAC/Agro).
Validations / Triggers to:
Prevent overlaps on From/To VBRs under the same RMP.
Never allow any VBR to be smaller than 0,01