FD - [iCARe] Price Settings

iCARe Auto-Maintained Epics Links: Unable to locate Jira server for this macro. It may be due to Application Link configuration. and Unable to locate Jira server for this macro. It may be due to Application Link configuration.

how the system calculates the price for a quote line item and a quote bracket (H4)

when the price list is updated, there's a message in the quote to advise the account manager and the system loads the most recent price into the quote

Auto-Maintain Feature

Diagram Flow: https://app.diagrams.net/#G1WkhoxxMnYdHxfplABdbuKjpo5s8OUvnw

Which Prices can be auto-maintained?

The auto-maintain is an automation implemented in the system to automatically create/update/delete the price list for Korea, India and China. The process is running daily over night (GMT).

The auto-maintain was anabled manually for the pricing settings provided by the business (not all the pricing settings are auto-maintained) that match the following criteria:

the pricing setting currency is USD (the auto-maintained is only working for USD currency)
the pricing setting Region & Incoterms is one of the combinations in the table below:

Currency	Region	Incoterms
USD	China	EXW, CIP, CFR, CIF
USD	India	EXW, CIP, CFR, CIF
USD	Korea	DDP

The auto-maintain feature creates automatically Pricing Settings and Product Brackets with the price in the local currencies with specific Incoterms.

Region	Local Currency	Incoterms
China	CNY	DDP
India	INR	EXW
Korea	KRW	DDP

The “Auto maintained in local currency?” checkbox is hidden when

the currency is not USD or
the region is not China, India or Korea or

the Product Pricing is not Valid.

Auto_maintain price calculation:

Depending on the region and incoterms, the calculation of the price includes the conversion from USD to the local currency plus some extra charges like Import Doty, Import Fee and Domestic Transportation, also based on Product Family.

The local prices are calculated based on:

Currency Exchange rate maintained in ICare - Manage Currencies rates in the setup
Import duties, Import fees and Domestic Transport managed by SC in this file and uploaded in ICare in the custom object
The import duties and the additional charges can be different within one product family. eg. Ryton anti-dumping
Any change to the Currency Exchange rates and or additional charges percentages will be reflected into the auto-maintained prices over night

Price Calculation Example

Local Currency Price = USD price * Currency Exchange Rate * (1+ import duty%+ duty fee% + domestic transportation%)

Example 1: PPS -R-7-121B / Import Duty: 214%

CNY price list = 10.62 USD/kg * 6.3 * (1+ 214% + 1% +1% ) = 211.4 CNY/KG

Example 2: Veradel PESU A-301 GN001 import duty changes from 8.5% to 10%

INR new price/old price = (1+ 10%+1%+1% )/ (1+8.5%+1%+1%) = 1.01 1% increase in local price

The Product Manager can deactivate the auto-maintain feature - he goes into the Pricing Setting and deselect the checkbox “Auto maintained in local currency?”

The Product Manager can see if the auto-maintained is enabled or not, through the grids but he cannot change the auto-maintained field in Grids..

AUTO MAINTAINED IN LOCAL CURRENCY? - if checked, indicates that the Pricing Setting in USD is enabled to be auto-maintained in the local currency (CNY, INR, KRW)

AUTO MAINTAINED - if checked, indicates that the Pricing Setting is created automatically through the auto-maintained feature.

Email Notifications sent to the Data Steward

There are 2 types of notifications that are sent to the data stewards:

Every time the Product Manager deactivates an auto-maintained pricing setting

every time the Product Manager activates or re-activates the auto-maintain in a pricing setting

The actions that need to be taken by the Data Steward are:

when the auto-maintained was deactivated on the pricing setting in USD:
- Go into the Pricing Setting record received on the emai, click on Product Pricing, tab Related, Pricing Settings, View All and open the Piricng Setting in the Local Currency
- update Auto-Maintained field on the Pricing Settings in the local currency to false
- keep the Auto_maintained From Id

- update the Auto-Maintained field on the Product Brackets in the local currency to false
- keep the Auto_maintained From Id

when the auto-maintained was re-activated on the pricing setting in USD:
- Go into the Pricing Setting record received on the email, click on Product Pricing, tab Related, Pricing Settings, View All and open the Piricng Setting in the Local Currency
- update the field Auto-Maintained in the Pricing Setting in the local currency to true
- confirm that Auto-Maintained From field is populated with the Pricing Setting in USD
- update the field Auto-Maintained Product Brackets in the local currency to true
- confirm that Auto-Maintained From field is populated with the Product Bracket in USD

when the auto-maintained was activated for the first time on the pricing setting in USD:
- Go into the Pricing Setting record received on the email, click on Product Pricing, tab Related, Pricing Settings, View All and open the Piricng Setting in the Local Currency
- update the field Auto-Maintained in the Pricing Setting in the local currency to true
- update the Auto-Maintained From field with the Pricing Setting in USD
- update the field Auto-Maintained Product Brackets in the local currency to true
- update the Auto-Maintained From field with the Product Bracket in USD

Manage people that receive auto-maintain notifications:

There is a custom metadata named PP Control Panel to configure the emails from the people that is added in the CC of the email, to receive the notifications when the product manager deactivates or re-activates the auto-maintain.