One account in 2 nodes (based on Debit & credit balance)

[Former Member]

Hi,

We are configuring BPC 10.1 NW consolidation and in the process loading the account  masters and  hierarchy from BW.

A few accounts out of them appear in 2 hierarchies(Eg. 100000 Gl account if debit balance then should be in hierarchy Assets and if has credit balance it should goto liabilities).

How can I bring in this functionality in the BPC system. Kindly suggest.

Regards,

Shilpa

[Former Member]

Hi Shilpa,

Can you try member formulas with IF and include those 2 new members in your hierarchy? One will go in Assets and another in Liabilities.

But in general it's considered not a good accounting practice having such accounts. It's better to have 2 accounts - one on each side of the trial balance.

Regards,

Gersh

[former_member190109]

Hi,

As you know, Two hierarchies can not consist same members In your case it should be  as below

BPC can't handle the above scenario,

• If your requirement is in report or input schedule we can achieve it by using native excel formulas if < 0  then display in specific column

• Or you can use Local member formula which can be displayed by using customised formula

• Or you can use Script logic with if it is equal to specific amount then copy to another member  AssetGIAccount or it can be copied to LiabilityGIAccount in which you can create the both other members for your requirement.

Let me know if you find any solution for your requirement