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.
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
Reporting Currency: Choose the currency to report in. The report will show journal lines in the selected currency
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.