Skip to Content
0
Former Member
Jun 10, 2009 at 08:43 PM

ANYBODY used the Currrency Conversion / Translation Rules Table yet??? Thx

23 Views

hi guys,

we are working on the BUSINESS RULE: CURRENCY CONVERSION TABLE.

here we have a easy three row table:

Account Rate Type: AVG; Formula: [AVG]

Account Rate Type: END; Formula: [END]

Line 3: Account Rate Type: TRANS: Destination Account: XYZ; >> Formula:[END]-[AVG]

this works fine and great!!!!! differences within accounts of AVG and accounts of END between AVG to END rate are being posted in Account XYZ.

here the is the requirement we trying to establish:

for Line 3: using the AVG (of ACTUALS) and the AVG (of BUDGET) ... so different VERSIONS of the SAME ACCOUNT_1. We like to have the same differences (but differen versions) posted to XYZ account.

what calculation do i put in the Formula field in the chart???

anybody done this? got an idea? -


thanks a lot, max (BPC 7.0 NW)

Edited by: Maximilian Weisheit on Jun 10, 2009 10:43 PM

Edited by: Maximilian Weisheit on Jun 10, 2009 10:47 PM