BPC 10.1 : loading transaction data into different accounts according to its value

[Former Member]

Hi BPC experts,

I would like to know if it is possible to load Transaction Data into 2 different accounts according to its positive or negative value from BW.

For instance :

In BW, account 400000 has a value of +100,00 and -50,00.

In BPC, there are 2 accounts : 400000D and 400000C (D = Debit and C = Credit).

Transaction data will be recorded as +100,00 for 400000D and -50,00 for 400000C.

I read in some posts that it is possible to develop this kind of logic in BW but the client does not want a solution done in BW.

Is it possible to write an *IF condition in the transformation file or a javascript in the conversion file ? Or is there another possibility ?

Thank you in advance,

Dat

[rishi4892]

you can try *IF condition

acc, signeddata {Source Column Name}

ACCOUNT=*IF( signeddata > 0 then acc+*str(D) ; acc+*str(C))

[former_member186338]

Have you tested you proposal yourself?

[Former Member]

Hello Rishi,

SIGNEDDATA > 0 doesn't work in transformation file, I did try this solution before writing a post about this issue 😞