Payment Worksheets

When you apply a payment to items, the items do not have to have the same currency, and the payment does not need to have the same currency as the items.

Worksheet totals appear in the payment currency. The system converts the sum of the selected items to the payment currency to match the deposit and payment totals at the bottom of the worksheet. When an item is partially or completely paid off on the payment worksheet, the system calculates realized gain or loss and generates the adjusting accounting entries.

If a rounding difference exists when the system converts the amount, the Receivables Update process posts the leftover amount using the rounding account code that you assigned to the business unit on the Receivables Definition - Accounting Options 1 page.

Example

Suppose that you have an invoice that is 12,565.39 USD, and you receive a EUR payment that converts to 12,565.40 USD. The Receivables Update process would post the .01 USD difference to the rounding account.

Note:

If the transaction involves a realized gain or loss, the rounding account is not updated.

When the system calculates a realized gain or loss amount for an item, it includes in the calculation any gain or loss amount that results from a difference in exchange rates.