Previous  Next          Contents  Index  Navigation  Glossary  Library

Projected Gains and Losses Report

Use this report to review open foreign currency invoices, debit memos, and chargebacks revalued according to the revaluation rate that you specify. Receivables compares the revalued amount of each debit item with the entered amount and prints the unrealized gain or loss. Receivables automatically sorts report information by customer name and then by invoice type for each customer.

Receivables prints the total debit item foreign currency amount for each invoice type, by currency. Additionally, Receivables prints the unrealized gain or loss for each transaction type and subtotals for each transaction type and customer. This report includes a Currency Totals section so you can review your unrealized gain and loss totals by currency.

Report Parameters

Customer Name: Receivables prints your report information between the low value and high values you specify for your customer name range.

Customer Number: Receivables prints your report information between the low value and high values you specify for your customer number range.

Exchange Rate Date: The date that corresponds to the exchange rate to use as your revaluation rate. The rate date and the rate type determine the revaluation rate that Receivables uses to revalue your debit items. For example, if you are using the Spot rate for June 1, 1991, enter 01-Jun-91 here. If you are using Period Average as your rate type, enter a date that is within the receivables accounting period for the Period Average rate you defined. If you enter a rate type and rate date that does not exist for a currency, Receivables does not calculate unrealized gains or losses for that currency. The default is the current date.

Exchange Rate Type: The rate type you want to use as your revaluation rate. The rate date and the rate type determine the revaluation rate that Receivables uses to revalue your debit items. If you enter a rate type and rate date that do not exist for a currency, Receivables does not calculate unrealized gains or losses for that currency.

Foreign Currency: Receivables prints your report information for the currency code that you specify.

GL Date: Receivables prints your report information from the debit item GL date range that you specify.

Transaction Type: Receivables prints your report information for the transaction type you enter.

Report Headings

Functional Currency: The functional currency code for your set of books. Your functional currency is the currency for your set of books.

GL Date between (Date) and (Date): The GL date range you specified in the report parameters.

Order By: Receivables automatically prints customer as the sort by option for this report.

Row Headings

Total for Type: (Type): The total unrealized gain and unrealized loss for each transaction type and customer.

See Also

Running Standard Reports and Listings

Common Report Parameters

Receivables Standard Reports

         Previous  Next          Contents  Index  Navigation  Glossary  Library