Opening balances (Balance Sheet) in USD Incorrect

[Former Member]

Hi all,

I just finished loading the opening balances for November 2012 in USD and they are incorrect. The local currency opening balance is correct.

October 2012 data is correct as well. What can be the issue that is causing the opening balance just in USD causing an out of balance issue?

Cheers~

[Former Member · Accepted solution]

Hi

Since the LC values are correct for Nov 2012 & problem is in USD after running conversion currency rule..I think you can check RATETYPE in ACCOUNT dimension & you can see different account have different rate type ( AVG . END ..)

Now check the RATE Application whether the value maintain for LC <-> USD is same for different rate type ie (AVG , END ..)

JAck

[Former Member · Accepted solution]

hi Jack , thank you for the input. at this time i am the user and not aware where i would check the RATETYPE in ACCOUNT dimension and the rate application. Could you guide a little?

[Former Member · Accepted solution]

Which version you are using BPC 7.5 NW or BPC 10 NW ?

[Former Member · Accepted solution]

BPC 10 NW

[Former Member · Accepted solution]

Hello,

How did you load USD to Nov 2012?

Did you load LC and convert to USD or used Copy opening?

Check the rates in the Rate model.

Check the RE account and OCI.

Thanks,

Bala

[Former Member · Accepted solution]

Basically we are checking that if the RATETYPE property in Account dimension for BS ID are AVG/END and if the Values for Nov 2012 maintain in RATE model(application) for AVG & END are different then it might show difference..I am not 100% sure but we can check this once.

1)For RATETYPE :

Go to BPC Admin page (link at right side of home page) ->click Dimension on left ->click on Account dimension (name might be different like C_ACCOUNT or something with type Account - A)

Now you will see members of dimension , in which Column have properties .. now locate the Rate type property.. now you need to verify for all ID of Balance sheet whether Rate type is same or different (ie AVG or END)

ID are similar to GL in SAP ECC.

If some ID have AVG and other have END then only we will check RATE model(application)

2) For Rate model:

check the values stored in rate application for LC<->USD for Oct 2012 & Nov 2012 for AVG & END Rate type..for this you need to open template/report in Rate model & select the year 2012..

Under Home page -> click EPM Add-in Excel ->Select connection RATE model..

If it directly get login then change connection ... follow  tools ->more->change connection-> select RATE model.

Once Rate model is open then open your template/report which shows Rate details

you can use below link to get better understading of BPC 10 & how to check above :

http://www.youtube.com/watch?v=1BM28pGLMUc

& other videos you can get on youtube & also you can refer this link http://wiki.sdn.sap.com/wiki/display/CPM/EPM+Add-in+Academy

I hope it helps

JAck