Oracle Fusion ERP · AR
Receivables reports
Every Receivables report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 50 reports.
Receivables data model
The module's conformed star — the fact every Receivables report rolls up to, surrounded by the dimensions shared across the module. See the full Receivables data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.
●— fact → dimension join
Reports
AR
AR Aging Detail Report
Open receivables aged by days past due, line by line — customer, transaction, due date, and bucket — with the …
AR
AR Applied and Unapplied Receipts Register Report
The receipts register — every receipt in a period showing what was applied to invoices and what remains unappl…
AR
AR Customer Query Report
A query of the customer master — accounts, sites, addresses, and key attributes — the lookup AR and credit use…
AR
AR Open Claim Summary and Detail Report
Customer claims and deductions — short-payments, disputed amounts, and unauthorized deductions — by reason and…
AR
AR Receivable Activity Report
Non-invoice receivables activity — adjustments, write-offs, discounts, and miscellaneous receipts — by activit…
AR
AR Transaction Register Summary and Detail Report
Every receivables transaction created in a period — invoices, credit memos, debit memos, and chargebacks — by …
AR
Cash Settlement Report
Cash settlement detail — how received cash settled against open transactions, by customer and sales rep, with …
AR
Customer Statement of Open Balance Report
Each customer's open balance as a statement — every unpaid invoice, debit memo, and chargeback, net of credits…
AR
Golden Tax Reconciliation Report
Reconciles Receivables to China's Golden Tax (VAT) system — AR invoice VAT against the Golden Tax invoices iss…
AR
Greece Customer Balance by Account Report
The Greek customer balance by general ledger account — each customer's receivable balance broken out by the ac…
AR
Greece Notes Receivable - Post Dated Checks and Drafts Report
Greek notes receivable — post-dated checks and drafts received from customers, by maturity date and customer, …
AR
Invoice Settlement Report
How each invoice was settled — the receipts, credit memos, adjustments, and write-offs that cleared it to zero…
AR
Open Closed Claim Detail Report
Open and closed customer claims in detail with reason codes — the full claim lifecycle from creation to resolu…
AR
Receipt History Report
The full life of each receipt — applied, unapplied, on-account, reversed, and cleared — with the transactions …
AR
SEPA Debit Authorization and Bank Detail Check Report
SEPA direct-debit mandates and a check of customer bank details — which customers have a valid signed mandate,…
AR
SEPA Letter for Italy Customer
The SEPA direct-debit pre-notification letter for Italian customers — the advance notice of the amount and dat…
AR
Transaction Resolution Report
Resolves Receivables transactions against China's Golden Tax (VAT) system — matching each AR invoice to its Go…
AR
Vietnam Receipt Voucher Report
The Vietnamese statutory receipt voucher (Phiếu thu) — each cash receipt in the local voucher format with paye…
AR
Receivables to General Ledger Reconciliation Report
Does AR tie to the GL receivables account, and which transactions explain any difference?…
AR
Receivables Aging Report
How much is owed, how overdue is it, and which customers concentrate the credit risk?…
AR
Bad Debt Provision Report
Estimates bad-debt exposure by applying each customer's percent-collectible to their open balance, listing tra…
AR
Invoices Posted to Suspense Report
Lists transactions whose revenue posted to a suspense account during AutoInvoice import, showing transaction c…
AR
Potential Reconciling Items Report
Flags journal items that may have posted to the wrong general ledger accounts — for example adjustments routed…
AR
Billing History Report
Summarizes each customer site's transactions and the activity against them over a date range — original amount…
AR
Import AutoInvoice Execution Report
Reports the outcome of the AutoInvoice import that brings transactions from external systems into Receivables,…
AR
Print Adjustments Report
Prints adjustments tied to specified transactions and customers, organized by business unit, adjustment number…
AR
Transaction Details Report
Lists invoices, credit memos, debit memos, and chargebacks with header, line, sales-credit, revenue-account, a…
AR
Receivables Aging by General Ledger Account Report
Ages outstanding receivables by general ledger account as of a chosen date, showing customer, transaction numb…
AR
Customer Account Status Report
Lists each customer's open items and total balance due based on account status, in the specified ledger curren…
AR
Customer Balances Revaluation Report
Shows the difference between a customer's original and revalued balance for manually adjusting the general led…
AR
Document Number Audit Report
Lists document numbers assigned to transactions, adjustments, and receipts to surface gaps in a sequence, with…
AR
Generate Late Charges Report
Prints late charges raised on overdue or late-paid transactions by batch, with transaction number, due date, a…
AR
Receivables Open Items Revaluation Report
Calculates the adjustment needed to restate open foreign-currency items to a revaluation rate, showing open or…
AR
Receivables Projected Gains and Losses Report
Compares the revalued amount of foreign-currency transactions to the entered amount and prints the projected u…
AR
Recognize Revenue Execution Report
Reports the outcome of the revenue-recognition process for transactions that use invoicing and revenue-schedul…
AR
Create Customer Statements Execution Report
Reports the customer-statement run and prints each customer's billing activity — invoices, debit memos, charge…
AR
Receipts Days Late Analysis Report
Measures the cost of slow-paying customers by computing weighted-average days late per customer, with transact…
AR
Receipts Awaiting Bank Clearance Report
Lists receipts still waiting to clear the remittance bank, with bank account, remittance batch date, maturity …
AR
Receipts Awaiting Remittance Report
Lists receipts ready to be remitted to the bank, with remittance bank account, maturity date, receipt number, …
AR
Bank Risk Report
Identifies receipts currently at risk with the remittance bank, showing remittance batch, receipt, and amount …
AR
Reversal Status Report
Reports the status of automatic receipt reversals in a settlement batch, with receipt date, number, amount, re…
AR
Automatic Receipt Creation and Remittance Execution Report
Reports the batch process that creates automatic receipts and remittances, listing generated and remitted rece…
AR
Clear Receipts Automatically Execution Report
Reports the auto-clearing process, listing receipts cleared by remittance bank account, receipt number, and cu…
AR
Create Automatic Receipt Write-offs Execution Report
Reports the process that writes off small unapplied amounts on receipts, by currency, customer, receipt number…
AR
Format Automatic Receipts Report
Prints the automatic receipts in a batch for customer confirmation, with receipt number, date, currency, and t…
AR
Process Receipts Through Lockbox Execution Report
Reports the lockbox process that creates receipts from bank-provided payment files, listing lockbox receipts a…
AR
Automatic Bills Receivable Remittance Execution Report
Reports the process that remits bills receivable to the bank for collection, detailing the bills sent.…
AR
Automatic Bills Receivable Transactions Batch Report
Reports the process that creates bills receivable from transactions, listing the transactions assigned to each…
AR
Close Matured Bills Receivable Execution Report
Reports the process that creates and applies receipts for matured remitted bills receivable and clears recours…
AR
Print Bills Receivable Report
Prints bills receivable individually, by batch, or by remittance batch.…