Allocations

[nanda_raote]

[frown] Has anyone found a way to make indexed computations / allocations between Business Units in different currencies that do a conversion based on the current exchange rates?

I can only get the allocations to post the same absolute value, ignoring the currency code. It therefore for example generates a journal for USD100.00dr and GBP100.00cr.

Am I missing something - or is the software?

Thanks
Nanda

 

[John_Dickey]

Nanda,
Well, Indexed Allocations are supposed to handle converting currencies,
though JDE recommends that you use financial restatement instead of
allocations to convert currencies, probably because the allocation process
is more limited in its conversion logic (as compared to financial
restatement). In general accounting constants, do you have multi currency
conversion set to Y or Z?? That would be my first question. Are the
business units in difference companies? If not, no currency conversion
would happen. Currency code set at the company level. Is the ledger type
maybe messing you up here?? Just trying to think of some things that might
be causing the conversion to not happen. Unless someone else comes up with
something here, I would call on JDE support. The program should recognize
different currency codes. If it does not, maybe you have found a bug?? We
do a lot of indexed allocations here, but do not cross company lines and
thus don't get into currency conversions.

John Dickey
JDE Financial Systems Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[nanda_raote]

Re: RE: Allocations

Hi John

JDE support were no help!
Yes - we have currency set to 'Y'.
Yes - the BUs are in different companies with different currencies.
Yes - we tried both AA and CA as the destination ledger type.
No - it's not converting!

Anyone else any ideas or experiences?

Thanks
Nanda

 

[JeffWilson]

Nanda

Is triangulation set on? This can mess things up big time.

Jeff Wilson

 

[nanda_raote]

Hi Jeff

Yes - but I've been testing with non-legacy currencies. In any case it's not that the conversion is wrong, it's simply non-existent.

Nanda