Transformation rule: Possible 1 account map to 2 accounts with condition +/- amount?
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?
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 < xThen map 66000010T_POS to 45590010T and 66000010T_NEG to 66000010T
