As If Currency Invoices

Regardless of whether you enter an invoice in a domestic or foreign currency, you can review amounts as if they were entered in a different currency.

To review amounts in an as if currency, you must enter a default currency code and an exchange rate date in the processing options for the Customer Ledger Inquiry program. This activates the As If Currency Code field on the Work with Customer Ledger Inquiry form.

The system retrieves the corresponding exchange rate from the F0015 table and calculates the as if currency amounts based on the base (domestic) currency of the invoice. For example, assume that you enter foreign currency invoices for a customer in USD and the company base currency is CAD. You want to review the invoice amounts as if they were entered in EUR. The system retrieves the CAD to EUR exchange rate from the F0015 table to calculate the as if amounts in EUR.

The As Of Date field on the inquiry form works in conjunction with the As If Currency field. The system calculates open amounts for the as if currency based on the as of date. If a receipt has been applied to the invoice, the system compares the as of date with the general ledger date of the receipt to determine the invoice amount that was open as of that date.

The system retrieves the corresponding exchange rate from the F0015 table and calculates the as if currency amounts based on the base (domestic) currency of the invoice. For example, assume that you enter foreign currency invoices for a customer in CAD and the company base currency is EUR. You want to review the invoice amounts as if they were entered in the Japanese yen (JPY). The system retrieves the EUR to JPY exchange rate from the F0015 table to calculate the as if amounts in JPY.