Calculation of currency difference by payment schedule

If a receipt or payment schedule applies to an invoice, the invoice is received or paid in multiple payments, each with its own due date. When reporting open entries to assess risks on current assets and liabilities, these different due dates should be considered. If the invoice is in a foreign currency, then the reports must consider the different due dates when assessing the risk to a company from changes in currency rates.

These changes have been made:

  • In the Write off Currency Differences (tfacr2250m000) and Write of Currency Differences (tfacp2240m000) sessions, the currency differences are now recorded and posted per receipt or payment schedule line instead of per invoice. Existing unrealized currency differences that are posted on invoice level (old situation) are reversed and unrealized currency differences are calculated and posted by receipt/payment schedule line.
  • To view the currency differences by receipt/payment schedule line, fields to display amounts in the home currency have been added to the Receipt Schedules (tfacr1103m000) and Payment Schedules (tfacp1103m000) sessions.
  • On receipt or payment of a schedule line, these situations can apply:
    • For invoices for which currency differences are calculated and posted on schedule line level (new situation), the unrealized currency profit/loss to be reversed and the realized currency profit/loss are determined and posted by the received or paid schedule line.
    • For invoices for which currency differences are calculated and posted on invoice level (old situation), the realized currency differences to be posted and the reversal of the unrealized currency differences are calculated and posted on invoice level.
  • For invoices with schedule lines, the reversal of the unrealized currency differences and the calculation and posting of the realized currency differences, is now performed by receipt schedule line in these sessions:
    • Send Documents to Factor (tfacr2212m000)
    • Write Off Bad Debts (tfacr2255m000)
  • Various print and display sessions, such as the Calculate Aging Analysis (tfacp3525m000) and Print Aging Analysis (tfacr2420m000) sessions now consider the posted currency differences and report the correct amounts in the home currency.