cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10.0 SP20 : clearing an account after a carryforward

Former Member
0 Kudos
72

Hi BPC experts,

I have a question about clearing an account after having done a carryforward.

Let's take an example :

Let's say we are in 2015.12 and we have account CABE481 with an amount of 100,00 LC. We want to convert it in euros where the exchange rate is 0,8. So the amount in euros will be 80 euros.

So far everything is fine.

Afterwards we need a carryforward into 2016.01. In this case, the amount of 100,00 LC will just be copied from 2015.12 into 2016.01. Moreover, we also copy the amount in euros (80,00 EUR) from 2015.12 into 2016.01. This is to keep the value to its original (historical) rate.

Now, there is an operation in ECC where the account CABE481 must equal 0,00 LC. In this case, there will be a posting amounted to -100,00 LC in this account in 2016.01. However, the rate in 2016.01 is 0,9. This means that the posting which was used to nullify this account is also converted to this new rate. In other words, the operation would be 80,00 EUR - 90,00 EUR = -10,00 EUR.

Although everything is logically right, the account CABE481 must not equal -10,00 EUR but should be 0,00 EUR.

                        ACCOUNT             2015.12                                    2016.01                  

                         CABE481    100 LC (INPUT)    ---BCF-->          100,00 LC (BCF)

                                                                                                  -100,00 LC (INPUT)

                                                                                       TOTAL   0,00 LC 

                                             80 EUR (INPUT)  ---BCF--->           80,00 EUR (BCF)  

                                                                                                    -90,00 EUR (INPUT) 

                                                                                       TOTAL -10,00 EUR

  

How do you clear this account then in BPC ? A manual journal is not the right solution. It would involve too much time for the users if this happens to a lot of accounts.

Please any insight is welcome.

Thank you in advance,

Dat

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

You can have multiple rates for the period... opening, closing, average...

Please read: How to do Currency Translation for Financial Ap... | SCN