Calculate Currency Differences (tfgld5201m000)

Use this session to calculate currency differences for the amounts entered in ledger accounts for which the Currency Analysis field in the Chart of Accounts (tfgld0508m000) session is set to Required, Calculate Currency Diff..

LN creates an interim file that includes the history data and the opening balances concerning the currency code for which currency differences must be calculated.

This file is only created for ledger accounts with sublevel 0, for which the Currency Analysis field, in the Chart of Accounts (tfgld0508m000) session, is Required, Calculate Currency Diff..

This session uses the values included in the interim file. In this file, the total amount is expressed in the system currency at the original rate, and the new total amount is expressed according to the currency rate derived from the Rate Date field.

In case of a difference, transactions are created in the transaction file. These transactions are posted to an Exchange Gain and Loss account.

The ledger account type depends on whether a currency profit or a currency loss is concerned.

Note: If the Calculate Currency Difference if Non-Finalized Transactions exist check box is cleared in the Finance Company Parameters (tfgld0503m000) session, to write off currency differences, all non-finalized transactions within the selected period must be finalized. If this checkbox is selected, LN can write off the currency differences (including non-finalized transactions) for the selected period.

Field Information

Selection
Selection Range
Up to Fiscal Period

All the transactions up to this year are selected for the calculation of currency differences.

Upto Fiscal Period

All the transactions up to this period are selected for the calculation of currency differences.

The period entered is always compared with the first period. For example, if you enter a 9 , the currency differences are calculated for the first nine periods.

Rate Date

The date on which the currency difference is calculated.

Note: This date is defaulted with the last date of the Invoice Period (To).
Options
Local Currency

If this check box is selected, you can specify an exchange rate type.

Reporting Currency 1

If this check box is selected, you can specify an exchange rate type.

Reporting Currency 2

If this check box is selected, you can specify an exchange rate type.

Post Currency Difference

If this check box is selected, the calculated differences are posted to the ledger account as defined in the Finance Company Parameters (tfgld0503m000) session.

If this check box is cleared, LN only generates a report that shows the calculated (or posted) differences per home currency, ledger account or ledger currency.

Reverse Posting Next Period

If this check box is selected, the subsequent periods are defaulted and LN generates reverse postings for the beginning of the next fiscal period.

Note: You cannot reset the fiscal period to a previous fiscal period.
Create Transactions
Document Date

The date on which the currency difference transaction is created.

Fiscal Period

The fiscal year in which the transaction must be posted.

Fiscal Period

The period in which the transaction must be posted.

Fiscal periods are defined in the Periods (tfgld0105m000) session.

Reporting Period

The period in which the transaction must be reported.

Reporting Period

The reporting year and the period number determine the reporting period of the bank transactions.

Reporting periods are defined in the Periods (tfgld0105m000) session.

Tax Period

The tax year and period determines the period used to post the tax reports for bank transactions.

Tax periods are defined in the Periods (tfgld0105m000) session.

Tax Period

The tax year and period determines the period used to post the tax reports for bank transactions.

Tax periods are defined in the Periods (tfgld0105m000) session.

Transaction Reference

The reference linked to all the transaction lines.

With Batch Reference

The batch reference that describes a group of transactions.

Document

The transaction type for currency differences as defined in the Finance Company Parameters (tfgld0503m000) session.

Document

The document number by which the transaction is identified.

Purchase Invoices by Batch

The batch number.