Running currency reports

Note: Detailed information about currency reports can be found in the Currency User Guide.

Ledger companies inherit their base and report currencies from the General Ledger companies. They can use any transaction currency. If the General Ledger company is defined as using Exchange and Translation on Company (GL10.1), both the General Ledger company and its counterpart ledger companies must run revaluation and translation programs at the end of each accounting period.

You must have Yes selected in the Currency Exchange and Currency Translation fields on Company (GL10.1) to perform those tasks using this procedure. You must also perform the Currency setup tasks described in the Currency User Guide. You must run the revaluation and translation programs in General Ledger and in Multi-Book Ledger before you close the accounting period.

Note: This program parallels Currency Revaluation (GL191), which you must also run for your General ledger company. For more information, see the Currency User Guide.

Run currency reports

  1. Run Ledger Currency Revaluation (ML191) for each ledger company that processes nonbase currency transactions to calculate base amounts for nonbase currency amounts.
  2. Perform currency translation using one of the two following methods:
    Note: This program parallels Translation Calculation (GL195) and requires the use of a consolidation company. For more information, see the Currency User Guide.
    • Run Ledger Translation Calculation (ML195) to translate one company base currency balance to the base currency of another company for reporting and consolidation. This process is also known as intercompany currency translation.

      – or –

      Note: This program parallels Currency Translation (GL196). For more information, see the Currency User Guide.
    • Run Ledger Report Currency Translation (ML196) to translate the company base currency amounts into report currency amounts based on the translation table rates you defined. This process is also known as intracompany currency translation.

  3. Run Ledger Journal Posting (GL190) to post the entries created by these reports.