Reviewing Invoices in a Foreign and As If Currency

Access the Work with Customer Ledger Inquiry form.

On the Work with Customer Ledger Inquiry form:

  • The system displays foreign amount totals only if you limit the search to invoices with the same transaction currency.

    It does not display foreign amount totals if the transaction currencies are different.

  • The system displays gross amount totals only if you limit the search to invoices with the same base currency.

    It does not display gross amount totals if the base currencies are different.

  • The system calculates and displays amounts in a currency different from the domestic and foreign currencies if you set a processing option accordingly and the As If Curr Code field appears on the form. The system calculates the as if amounts based on the base (domestic) currency of the invoice. You can change the currency code to view amounts in a different as if currency.

Trans Curr (transaction currency)

Displays the currency in which the invoice was entered. The invoice is foreign when the transaction currency code is different from the base currency code; otherwise the invoice is domestic.

Base Curr (base currency)

Displays the currency code that is assigned to the company associated with the invoice. This is the domestic currency of the invoice.

Exchange Rate

Displays the exchange rate at the time that the invoice was entered.

Foreign Amount

Displays the gross amount of the invoice based on the transaction currency and exchange rate.

Foreign Open Amount

Displays the foreign amount of the invoice that has not been paid.

Foreign Disc Available (foreign discount available)

Displays the foreign amount by which the invoice amount is reduced if it is paid by the due date.

Foreign Disc Taken (foreign discount taken)

Displays the foreign amount of the discount that was applied to the receipt.

As If Curr Code (as if currency code)

Enter the currency code to use to display invoice amounts.

The system displays this field if a value is entered in the As If Currency processing option for the Customer Ledger Inquiry program. The system converts the gross amount, open amount, and the amount of the discount available to the currency specified and displays them in the as if fields. The system uses the date in the Exchange Rate Date processing option to retrieve the exchange rate and calculate as if amounts.

As If Amount

Displays the converted gross amount of the invoice to the currency specified in the As If Curr Code (as if currency code) field.

As If Open Amount

Displays the converted open amount of the invoice to the currency specified in the As If Curr Code (as if currency code) field.

As If Disc Avail (as if discount available)

Displays the converted discount amount of the invoice to the currency specified in the As If Curr Code (as if currency code) field.