Hi BPC Experts,
We are using BPC 7.5NW version.
My project requirement is as given below -
1. When sales data gets loaded, it would do a Currency Conversion (CC) in reporting currency GBP.
2. When CC is executed for ACTUAL category data, the ACTUAL data should get converted to GBP with different rates.
Ex. CURRENT rate and simultaneously, it should aslo consider the BUDGET rate AND Year End Rate etc. and would generate those many records in the backend.
To achieve this we have created a user defined dimension say RATECATEGORY, which has RATE_PERIOD, RATE_CATEGORY, RATGE_YEAR properties. however, the CC doesn't work for all the RATECATEGORY types (like Budget Rate, Year End Rate etc)
How can we use user defined exchage Rates in CC logic?
Thanks & Regards,
Hi Rashmi -
As Ethan points out the rate selection is controlled by RATETYPE property in the ACCOUNT dimension. You could set up some kind of COPY process that moves values from one account to another, with each account having a different RATETYPE property ...but the process would create a lot of duplicated records. On the plus side you woud still be able to use the delivered currency translation process so it may be something you might want to consider.
A better recommendation would be to crate a custom BADI that is passed a user selection for the Ratetype to be used.
Usually I think we would use the CATEGORY dimension to manage different budget vs. actual rates, for example. On the other hand, to manage using year-end vs. average rate, we would usually use the RATETYPE property of the account dimension, since usually a particular account will use either the average rate or the year-end rate but not both.
If I'm not understanding what you are asking, then could you provide an example showing all the different conversions you would like to take place?