02-27-2024
02:51 AM
- last edited on
02-27-2024
05:24 AM
by
JackLacava
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?
Solved! Go to Solution.
02-27-2024 06:05 AM
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
02-27-2024 03:41 AM
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.
02-27-2024 04:11 AM
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?
02-27-2024 04:39 AM
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.
02-27-2024 05:03 AM
Under the rule expression, possible the source value is not register in dimension also can apply in rule?
02-27-2024 06:05 AM
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
02-27-2024 09:33 PM
Thank you, is work now.