Skip to main content

Enhanced Reporting - Journal Lines by Currency

The Journal Lines report in any selected currency to display debit and credit values in that currency

Travis Lander avatar
Written by Travis Lander
Updated this week

Description

The Journal Lines by Currency report includes the same details from the standard Journal Lines report, but in addition includes the ability to select a currency to see the transaction lines denominate the debit and credit values in that currency. This display of debit and credit values in any currency converts the existing posted currency of the journals to the selected currency using the spot rate exchange rate of the transaction date of the journal lines from the posted currency to the selected currency.

Caution: This report is informational, and is not used for any foreign currency processes like foreign currency remeasurement or entity consolidation of locations reporting in different currencies.

Report Configuration

Select the Journal Lines by Currency from the Report Type dropdown, and make subsequent selection for the Location(s) of Journal Lines to view, and the currency to display the debit and credit values in.

Journal Lines By Currency Config
  1. Location: Choose the location to focus on for your report. The report will show journal lines for the selected location and its child locations.

    • Defaults to the Location Context Picker if not set

  2. Reporting Currency: Choose the currency to report in. The report will show journal lines in the selected currency

  3. Posted Debit/Credit values will be multiplied by the FX Rate for the transaction date to get the reporting currency values.

    • debit = debit * FX Rate

    • credit = credit * FX Rate

Note: You can not select a custom currency for the debit and credit currency display in this report.

For more details on the fields, filtering, sorting, export, and table actions available for this report, review the standard Journal Lines report.

Did this answer your question?