Use this report to review all receipt applications that affect your customer balances.
You can review how your customers' receipts were applied to invoices and debit memos or reversed from invoices and debit memos. Receivables lets you specify the application date range so you can see the exact information you require. The Applied Receipts Register prints all applications within the date range that you specify, regardless of check date.
This report includes cash receipts, any discount information, and shows the possible exchange rate gain or loss for foreign currency receipts. Miscellaneous receipts are not included.
This report displays receipt-to-receipt applications as one receipt with a positive application and the other receipt with a negative application. Receipt amounts not applied to other types of transactions are displayed on the Unapplied Receipts Register.
Note: Items on the Other Receipt Applications report do not affect the customer balance, and are not recorded on the Applied Receipts Register.
When reconciling, the Applied Receipts Register's total should match the Applied Receipts Journal.
The Applied Receipts Register is an RXi report with a default attribute set and seven other available attribute sets: Apply Date, Batch, Customer, GL Date, Invoice Number, Receipt Number, and With Gain/Loss and Discount Information. The attribute set determines how information is ordered and what information is included in the report. You can copy any of the attribute sets and customize the layout to suit your reporting needs.
See: Using the RXi Reports Concurrent Program.
If comparing the Applied Receipts Register against the AR Reconciliation report, then use the attribute set that includes gain and loss and discount information.
Enter additional parameters to define the content of the report.
Note: See also: Common Report Parameters for Reconciliation Reports.
For more information, see: Oracle E-Business Suite Multiple Organizations Implementation Guide.
Apply Date: (Date) To (Date): The receipt apply date range, if you entered one.
Company: The company above all receipts belonging to this company.
Currency: The currency above all receipts belonging to this currency.
GL Date: (Date) To (Date): The application general ledger date range, if you entered one.
Order By: The sort by option.
Applied Amount: The receipt amount applied in your functional currency. Receivables prints a negative amount for receipt reversals.
Apply Date: The date of the receipt application or application reversal.
Batch: The receipt batch number.
Document Number: The document sequence number of the receipt. This column appears only if you submitted the report using the Document Number attribute set.
Exchange Rate Gain/Loss: The foreign currency exchange rate gain or loss amount. An exchange rate gain is shown as a positive (+) amount; a loss is shown as a negative (-) amount.
Earned Discount: The earned discount amount in your functional currency.
Related Customer: The customer name and number of the transaction to which the receipt is applied (usually the customer who remitted the receipt). This does not refer to a customer relationship that might be defined for this customer.
Unearned Discount: The unearned discount amount in your functional currency.
Total amount in functional currency: The total amount applied in functional currency.
Allocated Receipt Amount: Amount applied in receipt currency.
Company: Total for Currency: The total, by company and currency.
Company: Total Functional Amount for Currency: The total functional amount by company and currency.
Company: Total Functional Amount: The total functional amount by company.
Grand Total For Functional Currency: The total functional amount for all companies on this report.
Total for (Sort By Option): The total, by column, for the sort by option you select for your report.