Currency Management Model



Import (SCO)

Data is NO longer imported from BW file DYS_BW_CURR file.

As of July 2024, rates for Syensqo databases are currently updated manually.  Interfaces have been turned off.

Steps to update currencies are as follows:

  • Open the data field "Import Currencies - MCR [CAR4] in the Currency Management | 0. Import data table
    • This is in the x. Currency Management user model
  • Update the rates manually from the current month to the end of the future (the same rate should be propagated in all future months)
  • If needed, update the current month with the data from the BW files (past rates are based on actuals)
  • Save the changes
  • D+1 - the currency / LC conversion will be updated in the hierarchy and sent to the BW queries



OLD

- for Composites (DP2)

  • last imported value is propagated through the end of the horizon (Y+10) and;
  • Y-4 values are kept.

- for MTP (Mid Term Planning) for Special Chem & Novecare 

  • last imported value is propagated through the end of the MTP horizon (Y+5)

Conversion Rate EUR → LCs

Conversion Rate is assigned from the CAR4 Currencies at <Any Level> level.

Then, this Conversion Rate is populated for all LCs available in DynaSys.

These data fields are used to updated the Unit of Measure Conversion in the hierarchy.

Conversion Rate EUR → Active L2

Each Conversion Rate EUR → LCs are summarized in Conversion Rate !EUR → !LC to update the Unit of Measure Conversion in the hierarchy and allow automatic conversion for all data fields.

Finally, the Conversion Rate !EUR → !LC (from structure) is fed by the hierarchy's conversion factor.


Process to Add New Currency

  • Add to BW
  • Add in Unit of measure conversion folder

  • Add manually to the LC master table
    • relaunch the import to ensure the CAR4 rates are imported correctly
  • Add new data field to the Currency Management | 1. Conversion Rate EUR → LCs

  • Update 2 rule bases
    • Currency Management:  Apply conversion
    • Currency Managment : Conversion rate EUR to LCs

 


  • No labels