The Transaction Register includes all transactions (such as invoices, credit memos, debit memos, chargebacks, deposits, and guarantees) that increase or decrease a customer's outstanding balance for a specified period, including transactions that do not post or age. Receivables groups and prints transactions by company, currency, and postable status.
To gain a more complete picture of your transactions, use the Transaction Register in conjunction with the Invoice Exception report and the Adjustment Register. The Invoice Exception report displays any transactions that do not age. The Adjustment Register includes the applied amounts of commitments (deposits and guarantees).
When reconciling, the Transaction Register's posted total should match the receivables accounts on the Sales Journal. To ensure that the two reports match, run the Sales Journal by Account for the receivables account type.
For MFAR customer, you are able to match the Transaction Register report at the aggregate level not at the level of each company segment value.
The Transaction Register is an RXi report with a default attribute set and four other available attribute sets: Alternate Name, Customer, Document Number, and Invoice Number. You can copy any attribute set and customize the layout to suit your reporting needs.
Alternate Name: Sort customers according to the value you entered in the Alternate Name field of the Customers window. (Oracle Receivables only displays this option if the profile option AR: Sort Customer Reports by Alternate Fields is Yes.)
Customer: Sort information by the invoice type, then by customer.
Document Number: Sort information by the document sequence number of each transaction.
Invoice Number: Sort information by the invoice type, then by invoice number.
See: Working with Attribute Sets and Using the RXi Reports Concurrent Program.
Note: See also: Common Report Parameters for Reconciliation Reports.
Transaction Date: The transaction date range to include in this report.
Transaction Type: The transaction type range to include in this report.
Document Sequence Name: To include transactions associated with a specific document sequence, enter a document sequence name or select from the list of values.
Document Sequence Number From/To: If you entered a document sequence name, enter a range of document numbers to include in the report. Leave this parameter blank to include all document numbers for this document sequence name.
Company: The balancing segment for this group of transactions.
Currency: The currency code for this group of transactions.
Document Number: The document sequence number of the transaction. This column appears only if you submitted the report using the Document Number attribute set.
GL Date From (Date) to (Date): The range of general ledger dates you selected to print on this report.
Invoice Date From (Date) to (Date): The range of invoice dates you selected to print on this report.
Postable: The post to general ledger status for this group of transactions.