Detail Trial Balance in different Currency

rico1931

Hello everyone,

I found a previous post but it's a year old and wanted to make sure it's still the case. I'm trying to get a report of the Detail Trial Balance report (report #4) in different currency's that we have. The previous post said we would have to customize the report. Just wondering if this is still the case? Also if we have to customize it, can someone point me to how I might go about getting the report to display a different currency?

Thanks

ufuk

Do you want to display amounts in a currency user selected or you want to display amounts in applied currency? In each scenario, you have to customize.

First scenario: You have to replace the flowfield formulas with functions and calculate the fcy amounts using exchange rates or document rates (this may be a parameter in request form)
Second scenario: In Turkey we have Applied Currency Code but I don't know if you have a similar field in your version. It's easy in our version as we can group gl entry using this field. If you do not have this field, you may require check the currency in corresponding ledgers.

Isaland

Hello.
There is Table - 330 - Currency Exchange Rate and it have built-in functions:
ExchangeAmtLCYToFCY and ExchangeAmtFCYToLCY

LCY - local currency, FCY - foreign.

You must have four parameters for use this functions:
- Date
- Currency Code
- Amount
- Currency Factor

"Currency Factor" you can count with built-in function ExchangeRate

I hope it will help