Hi Experts,
We are on SAP BPC 7.5 NW, SP07
We are trying to calculate Opening Retained Earning (RE). Scenario is like below:
Year 1 (say first year of the company) (LC=USD, Group Currency = INR) (Y1 Avg rate 1USD=49 INR, Y1 Closing 1USD=50 INR)
Profit for Y1 in P/L = USD 100 (Avg (for P/L) = INR 4900 and Closing (for B/S) = INR 5000)
Therefore, RE in B/S balance will be INR 4900 and INR 100 (5000 - 4900)will go to Foreign Currency Translation Reserve (FCTR)
(Y2 Avg rate 1USD=50 INR, Y2 Closing 1USD=51 INR)
Year 2 in P/L = USD 200 (Avg (for P/L) = INR 10000 and Closing (for B/S) = INR 10200)
Therefore in closing RE for Y2 in BS balance will be INR 10000 and INR 200 (10200 - 10000) will go to FCTR
Opening RE of Y1 will be INR 4900 in Y2 in P/L and in B/S RE of Y2 will also be INR 4900 but INR 200 will go to FCTR (5100 - 4900).
Total RE balance will be INR 14900 (100004900) and FCTR balance will be INR 400 (200200)
We have written an Account Tranformation rule and its working fine but the only problem is we are inputting INR 4900 and INR 5100 manually through an input schedule. Ideally, we should be only be inputting INR 4900 manually (since it will always be a static amount based of closing of previous year) and INR 5100 (100*51) should be calculated by the FX conversion script logic but this is not happening. We have written Conversion business rule but its not working properly. Moreover, if we run FX conversion twice, it recalculates the figures again and again, how to stop it?
Kindly advise.
Alpana