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

[Catherine_Tee]

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.

After validate it become go to both accounts.

Is there any missing caused the rule not work properly?

[MarcusH]

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.

[Catherine_Tee]

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?

[MarcusH]

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.

[Catherine_Tee]

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

[MarcusH · Accepted solution]

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

[Catherine_Tee]

Thank you, is work now.