Hi Kenneth,
Why do you include the IC in the Account mapping then? It is not the IC that defines the netting, right?
I also have a question regarding your point on the first post : if you use a derivative it will create a new line, but is that an issue for you?
Creating the extra row for derivative it not a problem.
But as mentioned below:
I might be able to skip ICP, so each ICP goes to different accounts.
But same question remains more or less, if I then have
A#12345:U1#ABC = -2000
A#12345:U1#DEF = 3000
Acc. 12345 maps to acc. A1234 or L1234 depending on the total amount.
UD1#ABC = U1#IT
UD1#DEF = U1#HR
But no matter what the department is, then it should look at the total of the account and base this for each row.
If I add a derivative rule saying A#12345=12345_PrefixCheck:U1#*=UD1_ALL
Then I will loose my UD1 details, right - but if I do not add the UD1_ALL then I will not get the right total of the account, right.
