Skip to main content
C
Catherine_Tee
February 27, 2024
Solved

Transformation rule: Possible 1 account map to 2 accounts with condition +/- amount?

  • February 27, 2024
  • 3 replies
  • 0 views

I would like to set a transformation rule that particular account can be map to 2 accounts with condition +/- amount.

Example, if positive go asset account, if negative go liability account.

I had tried derivative rule is seem not working.


Catherine_Tee_0-1709019944632.png

After validate it become go to both accounts.


Catherine_Tee_1-1709020021410.png

Is there any missing caused the rule not work properly?

 

 

 

 

Best answer by MarcusH

You had it right in the earlier version. The way I usually do this is create a new record for the negative and another one for the positive value. The original source record is set to Bypass in the maps, then the new negative record goes to the correct negative member and the same for the positive. So you would have something like this in derivative rules:

A#[66000010T]=66000010T_POS Create if > x
A#[66000010T]=66000010T_NEG Create if < x

Then map 66000010T_POS to 45590010T and 66000010T_NEG to 66000010T

 

3 replies

M
MarcusH
February 27, 2024

There is a problem with Map_Account_2: the source account and the account that it will create are the same. So I think it is working correctly. Change the account that will be created in Map_Account_2 to something else and rerun the import.

C
Catherine_TeeAuthor
February 27, 2024

Thanks. Is work if I change to another account under Map_Account_2.

How to resolve if I want negative is back to that same account?

M
MarcusH
February 27, 2024

The derivative rule is only creating a source data record. You can post the negative rule to another account (e.g. 66000010NEG) and then map that back to 66000010T.

C
Catherine_TeeAuthor
February 27, 2024

Under the rule expression, possible the source value is not register in dimension also can apply in rule?


Catherine_Tee_0-1709027924059.png

 

M
MarcusHAnswer
February 27, 2024

You had it right in the earlier version. The way I usually do this is create a new record for the negative and another one for the positive value. The original source record is set to Bypass in the maps, then the new negative record goes to the correct negative member and the same for the positive. So you would have something like this in derivative rules:

A#[66000010T]=66000010T_POS Create if > x
A#[66000010T]=66000010T_NEG Create if < x

Then map 66000010T_POS to 45590010T and 66000010T_NEG to 66000010T

 

C
Catherine_TeeAuthor
February 28, 2024

Thank you, is work now.

Terms & ConditionsAccessibility statement