Detail Trial Balance in different Currency

rico1931
rico1931 Member Posts: 295
edited 2012-08-23 in NAV Three Tier
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
-rico1931

Comments

  • ufuk
    ufuk Member Posts: 514
    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.
    Ufuk Asci
    Pargesoft
  • Isaland
    Isaland Member Posts: 52
    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 :wink:
    MB7-840

Categories