Transaction Register

Use the Transaction Register to review your customer transactions by business unit and accounting period. The report includes all transactions that increase or decrease the customer outstanding balance for the specified period.

You can optionally review transactions that update customer balances but don’t post to the general ledger by setting the Post to General Ledger Eligible parameter to No. Use this parameter option for your transactions that are imported into Receivables from non-Oracle billing systems that post directly to the general ledger. When you import these transactions into Receivables, the Post to GL option on the transaction types assigned to these transactions isn’t enabled, because they’re already accounted in the general ledger. Receivables is then used to track these transactions for payment and collection purposes.

Run the Transaction Register according to your customer account review requirements. You can also use this report to assist in reconciliation to the general ledger when a standalone report is needed.

Selected Report Parameters

Accounting Date

The transaction accounting date range to include in the report.

Transaction Currency

Confine the report to one transaction currency.

Transaction Class

Confine the report to invoices, credit memos, chargebacks or debit memos.

Post to General Ledger Eligible

  • Yes: Transactions eligible for posting to the general ledger. The Post to GL option on the transaction types assigned to these transactions is enabled.

  • No: Transactions that don’t post to the general ledger. The Post to GL option on the transaction types assigned to these transactions isn’t enabled.

Report Output

The report groups transactions by transaction class and accounting date, and provides subtotals by transaction class and business unit.

This table describes the report headings in the Transaction Register.

Report Heading

Description

Transaction Entered Amount

The amount of the transaction in the transaction currency.

Transaction Currency

The currency of the transaction.

Transaction Accounted Amount

The accounted amount of the transaction in the ledger currency.

[Transaction Class] Total

Total accounted amount for each transaction class.

[Business Unit] Total

Total accounted amount for each business unit.

Grand Total

Total accounted amount for the report.