Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Accounts Receivable

Accounts receivable (AR) are the balance of money due to a firm for goods or services delivered or used but not yet paid for by customers. Accounts receivable are listed on the balance sheet as a current asset. Any amount of money owed by customers for purchases made on credit is AR.Accounts receivable are created when a company lets a buyer purchase their goods or services on credit.

Accounts Receivable Views

Serial no. View nameDescription
1AR Adjustment Distributions This view returns information about distributions for adjustments made to customer transactions in Oracle Fusion Receivables.
  • This information is accessible through Billing > Manage Transactions > Actions > Manage Adjustments.
  • A record is returned for each combination of a ledger names, a business unit names, an adjustment numbers, and an adjustment distributions identifier.
2AR Adjustments This view returns information about adjustments made to customer transactions in Oracle Fusion Receivables.
  • This information is accessible through Billing work area > Manage Transactions > Actions > Manage Adjustments.
  • A record is returned for each adjustment number.
3AR Bills Receivable Details This view returns information about bills receivable in Oracle Fusion Receivables.
  • This information is accessible through Accounts Receivable work area > Bills Receivable > Manage Bills Receivable Portfolio.
  • A record is returned for each combination of a bills receivable transaction identifier, transaction identifier, and transaction installment identifier.
4AR Bills Receivable Distributions This view returns information about distributions for bills receivable in Oracle Fusion Receivables.
  • A record is returned for each combination of a bills receivable transaction number and bills receivable distribution line identifier.
5AR Credit Memo Applications This view returns information about credit memo applications in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Transactions > Manage Transactions.
  • A record is returned for each combination of a business unit name, a credit memo source name, a credit memo number, a customer number, a customer account number, a credit memo line identifier, a credit memo line type, and an application identifier.
6AR Credit Memo Requests This view provides information about credit memo requests in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions.
  • A record is returned for each combination of a disputed transaction number and credit memo request identifier.
7AR Cust Acct Site Other Tax Profiles This view returns information about tax profile classifications and reporting codes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Sites > Tax Profile.
  • A record is returned for each combination of a tax profile identifier, tax reporting type identifier, and fiscal classification type identifier.
8AR Cust Acct Site Tax Exemptions This view returns information about customer tax exemptions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Sites > Tax Profile > Tax Exemptions.
  • A record is returned for each combination of a tax profile identifier and tax exemption identifier.
9AR Cust Acct Site Tax Registrations This view returns information about customer tax registrations including withholding tax registrations.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customers > Sites > Tax Profile > Tax Exemptions.
  • A record is returned for each combination of a tax profile identifier and tax registration identifier.
10AR Customer Account Site Uses This view returns information about customer account site uses.
  • This information is accessible through Receivables > Accounts Receivable > Customers > Manage Customers or through Receivables > Billing work area > Customers > Manage Customers.
  • A record is returned for each combination of a customer number, customer account number, customer site number, and customer account site use identifier.
11AR Customer Accounts This view provides information about customer accounts in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts.
  • A record is returned for each customer account identifier.
12AR Customer Balance Aging Summary This view returns information about aging customer balances in Oracle Fusion Receivables.
  • A record is returned for each combination of a business unit name, ledger name, ledger set name, customer name, customer account name, customer organization name, calendar year, calendar quarter, currency code base, and transaction currency code.
13AR Customer Contacts This view returns information about the representatives of customer accounts and customer account sites in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customer > Accounts > Communications and also through Receivables > Billing work area > Customers > Manage Customer > Sites > Communications.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, contact number, customer account site use, and contact point identifier.
14AR Customer Other Tax Profiles This view returns information about tax profile classifications and reporting codes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts > Tax Profile.
  • A record is returned for each combination of a tax profile identifier, tax reporting type identifier, and fiscal classification type identifier.
15AR Customer Payment Instruments This view returns information about bank accounts at the customer account and site levels in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts or through Sites > Payment Details > Payment Instruments.
  • A record is returned for each combination of a customer number, customer account number, customer site number, bank account number, and credit card number.
16AR Customer Profile History This view returns information about customer profiles, including the customer account and site histories in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Customers > Accounts > Profile History and through Receivables > Accounts Receivable work area > Manage Customers > Sites > Profile History.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, customer profile class name, customer profile currency code, customer profile class effective start date, and customer profile class effective end date.
17AR Customer Receipt Methods This view returns information about receipt methods at the customer account and site levels in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customers > Accounts or Sites > Payment Details > Receipt Methods.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, and receipt method name.
18AR Customer Tax Registrations This view returns information about customer tax registrations including withholding tax registrations.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Organization Information > Tax Profile > Tax Registrations.
  • A record is returned for each combination of a customer number, tax profile identifier, and tax registration identifier.
19   AR Customers   This view returns information about customers of the organization and person types in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers.
  • A record is returned for each customer identifier. Note: This view returns information only about customers while the Manage Customers page may display information about all parties, such as suppliers and customer contacts.
20AR Period Statuses This view returns information about account receivables period statuses in Oracle Fusion Accounts Receivable.
  • This information is accessible through General Accounting > Period Close work area > Receivables.
  • A record is returned for each combination of a report date, period name, and ledger name.
21AR Receipt Conversion Rate Adjustments This view returns information about receipt conversion rates, including exchange gain or loss amounts in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Receipts.
  • A record is returned for each combination of a receipt number, a receipt identifier, an old conversion rate type, and a new conversion rate type.
22AR Receipt Details This view returns information about receipts and the associated receipt applications in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Receipts > Manage Receipts.
  • A record is returned for each combination of a receipt identifier, receipt application identifier, business unit name, customer name, and customer account number.
23AR Receipt Distributions This view returns information about standards and miscellaneous receipts distributions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Receipts.
  • A record is returned for each combination of a ledger name, business unit name, receipt number, and distribution line identifier.
24AR Transaction Line Details This view returns information about transaction lines and transaction line taxes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions.
  • A record is returned for each combination of a transaction identifier, transaction line identifier, and transaction line tax line identifier.
25AR Transactions This view returns information about transactions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions > Review Transaction.
  • A record is returned for each transaction identifier.
26AR Transaction Installments This view returns information about transaction installments in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions > Review Installments.
  • A record is returned for each transaction installment.
27AR TransactionDistributions This view returns information about transactions distributions including revenue adjustment distributions in Oracle Fusion Receivables.
  • The transaction distribution information is accessible through Receivables > Billing work area > Manage Transactions and the revenue adjustment distribution information is accessible through Receivables > Revenue work area > Manage Revenue Adjustments.
  • A record is returned for each combination of a ledger name, business unit name, transaction number, transaction line number, and distribution identifier.
28AR Unapplied Receipts This view returns information about unapplied, unidentified, and on-account receipts in Oracle Fusion Receivables.
  • The information returned by the view is similar to the Unapplied Receipts Register report in Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable > Receipts > Manage Receipts.
  • A record is returned for each combination of a business unit name, receipt batch name, receipt number, receipt identifier, receipt application status, and receipt application general ledger date.
29SLA AR Adjustment Distributions This cross-functional view links accounting entries in Oracle Subledger Accounting to the corresponding adjustment distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for adjustments in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
30SLA AR Bills Receivable Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding bills receivable transaction distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for bills receivable transactions.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
31SLA AR Receipt Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding standard/miscellaneous receipts and their application distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for standard/miscellaneous receipts and their applications in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
32SLA AR Transaction Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding transaction distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for transactions in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
33SLA Receivables Reconciliation This view returns information about the reconciliation of accounting and transactional data recorded in Oracle Fusion Receivables and Oracle Fusion Subledger Accounting with the journals posted to Oracle General Ledger for open receivables balances.
  • This information is accessible through Receivables > Accounts Receivable > Accounting > Receivables to Ledger Reconciliation.
  • A record is returned for each combination of a ledger name, an accounting period, a reconciliation request name, and a reconciliation item.

Accounts Receivable Dashboards

A dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is intended to convey different, but related information in an easy-to-digest form. And oftentimes, this includes things like key performance indicators (KPI)s or other important business metrics that stakeholders need to see and understand at a glance. Dashboards are useful across different industries and verticals because they’re highly customizable. They can include data of all sorts with varying date ranges to help you understand: what happened, why it happened, what may happen, and what action you should take. And since dashboards use visualizations like tables, graphs, and charts, others who aren’t as close to the data can quickly and easily understand the story it tells or the insights it reveals.

Published:

Accounts Receivable

Accounts receivable (AR) are the balance of money due to a firm for goods or services delivered or used but not yet paid for by customers. Accounts receivable are listed on the balance sheet as a current asset. Any amount of money owed by customers for purchases made on credit is AR.Accounts receivable are created when a company lets a buyer purchase their goods or services on credit.

Accounts Receivable Views

Serial no. View nameDescription
1AR Adjustment Distributions This view returns information about distributions for adjustments made to customer transactions in Oracle Fusion Receivables.
  • This information is accessible through Billing > Manage Transactions > Actions > Manage Adjustments.
  • A record is returned for each combination of a ledger names, a business unit names, an adjustment numbers, and an adjustment distributions identifier.
2AR Adjustments This view returns information about adjustments made to customer transactions in Oracle Fusion Receivables.
  • This information is accessible through Billing work area > Manage Transactions > Actions > Manage Adjustments.
  • A record is returned for each adjustment number.
3AR Bills Receivable Details This view returns information about bills receivable in Oracle Fusion Receivables.
  • This information is accessible through Accounts Receivable work area > Bills Receivable > Manage Bills Receivable Portfolio.
  • A record is returned for each combination of a bills receivable transaction identifier, transaction identifier, and transaction installment identifier.
4AR Bills Receivable Distributions This view returns information about distributions for bills receivable in Oracle Fusion Receivables.
  • A record is returned for each combination of a bills receivable transaction number and bills receivable distribution line identifier.
5AR Credit Memo Applications This view returns information about credit memo applications in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Transactions > Manage Transactions.
  • A record is returned for each combination of a business unit name, a credit memo source name, a credit memo number, a customer number, a customer account number, a credit memo line identifier, a credit memo line type, and an application identifier.
6AR Credit Memo Requests This view provides information about credit memo requests in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions.
  • A record is returned for each combination of a disputed transaction number and credit memo request identifier.
7AR Cust Acct Site Other Tax Profiles This view returns information about tax profile classifications and reporting codes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Sites > Tax Profile.
  • A record is returned for each combination of a tax profile identifier, tax reporting type identifier, and fiscal classification type identifier.
8AR Cust Acct Site Tax Exemptions This view returns information about customer tax exemptions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Sites > Tax Profile > Tax Exemptions.
  • A record is returned for each combination of a tax profile identifier and tax exemption identifier.
9AR Cust Acct Site Tax Registrations This view returns information about customer tax registrations including withholding tax registrations.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customers > Sites > Tax Profile > Tax Exemptions.
  • A record is returned for each combination of a tax profile identifier and tax registration identifier.
10AR Customer Account Site Uses This view returns information about customer account site uses.
  • This information is accessible through Receivables > Accounts Receivable > Customers > Manage Customers or through Receivables > Billing work area > Customers > Manage Customers.
  • A record is returned for each combination of a customer number, customer account number, customer site number, and customer account site use identifier.
11AR Customer Accounts This view provides information about customer accounts in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts.
  • A record is returned for each customer account identifier.
12AR Customer Balance Aging Summary This view returns information about aging customer balances in Oracle Fusion Receivables.
  • A record is returned for each combination of a business unit name, ledger name, ledger set name, customer name, customer account name, customer organization name, calendar year, calendar quarter, currency code base, and transaction currency code.
13AR Customer Contacts This view returns information about the representatives of customer accounts and customer account sites in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customer > Accounts > Communications and also through Receivables > Billing work area > Customers > Manage Customer > Sites > Communications.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, contact number, customer account site use, and contact point identifier.
14AR Customer Other Tax Profiles This view returns information about tax profile classifications and reporting codes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts > Tax Profile.
  • A record is returned for each combination of a tax profile identifier, tax reporting type identifier, and fiscal classification type identifier.
15AR Customer Payment Instruments This view returns information about bank accounts at the customer account and site levels in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Accounts or through Sites > Payment Details > Payment Instruments.
  • A record is returned for each combination of a customer number, customer account number, customer site number, bank account number, and credit card number.
16AR Customer Profile History This view returns information about customer profiles, including the customer account and site histories in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Customers > Accounts > Profile History and through Receivables > Accounts Receivable work area > Manage Customers > Sites > Profile History.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, customer profile class name, customer profile currency code, customer profile class effective start date, and customer profile class effective end date.
17AR Customer Receipt Methods This view returns information about receipt methods at the customer account and site levels in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Customers > Manage Customers > Accounts or Sites > Payment Details > Receipt Methods.
  • A record is returned for each combination of a reporting level context, customer number, customer account number, customer site number, and receipt method name.
18AR Customer Tax Registrations This view returns information about customer tax registrations including withholding tax registrations.
  • This information is accessible through Receivables > Billing work area > Manage Customers > Organization Information > Tax Profile > Tax Registrations.
  • A record is returned for each combination of a customer number, tax profile identifier, and tax registration identifier.
19   AR Customers   This view returns information about customers of the organization and person types in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Customers.
  • A record is returned for each customer identifier. Note: This view returns information only about customers while the Manage Customers page may display information about all parties, such as suppliers and customer contacts.
20AR Period Statuses This view returns information about account receivables period statuses in Oracle Fusion Accounts Receivable.
  • This information is accessible through General Accounting > Period Close work area > Receivables.
  • A record is returned for each combination of a report date, period name, and ledger name.
21AR Receipt Conversion Rate Adjustments This view returns information about receipt conversion rates, including exchange gain or loss amounts in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Receipts.
  • A record is returned for each combination of a receipt number, a receipt identifier, an old conversion rate type, and a new conversion rate type.
22AR Receipt Details This view returns information about receipts and the associated receipt applications in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Receipts > Manage Receipts.
  • A record is returned for each combination of a receipt identifier, receipt application identifier, business unit name, customer name, and customer account number.
23AR Receipt Distributions This view returns information about standards and miscellaneous receipts distributions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable work area > Manage Receipts.
  • A record is returned for each combination of a ledger name, business unit name, receipt number, and distribution line identifier.
24AR Transaction Line Details This view returns information about transaction lines and transaction line taxes in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions.
  • A record is returned for each combination of a transaction identifier, transaction line identifier, and transaction line tax line identifier.
25AR Transactions This view returns information about transactions in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions > Review Transaction.
  • A record is returned for each transaction identifier.
26AR Transaction Installments This view returns information about transaction installments in Oracle Fusion Receivables.
  • This information is accessible through Receivables > Billing work area > Manage Transactions > Review Installments.
  • A record is returned for each transaction installment.
27AR TransactionDistributions This view returns information about transactions distributions including revenue adjustment distributions in Oracle Fusion Receivables.
  • The transaction distribution information is accessible through Receivables > Billing work area > Manage Transactions and the revenue adjustment distribution information is accessible through Receivables > Revenue work area > Manage Revenue Adjustments.
  • A record is returned for each combination of a ledger name, business unit name, transaction number, transaction line number, and distribution identifier.
28AR Unapplied Receipts This view returns information about unapplied, unidentified, and on-account receipts in Oracle Fusion Receivables.
  • The information returned by the view is similar to the Unapplied Receipts Register report in Fusion Receivables.
  • This information is accessible through Receivables > Accounts Receivable > Receipts > Manage Receipts.
  • A record is returned for each combination of a business unit name, receipt batch name, receipt number, receipt identifier, receipt application status, and receipt application general ledger date.
29SLA AR Adjustment Distributions This cross-functional view links accounting entries in Oracle Subledger Accounting to the corresponding adjustment distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for adjustments in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
30SLA AR Bills Receivable Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding bills receivable transaction distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for bills receivable transactions.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
31SLA AR Receipt Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding standard/miscellaneous receipts and their application distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for standard/miscellaneous receipts and their applications in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
32SLA AR Transaction Distributions This cross-functional view links accounting entries in Oracle Fusion Subledger Accounting to the corresponding transaction distribution lines in Oracle Fusion Receivables.
  • This view returns information about subledger accounting distributions for all accounting events generated for transactions in Receivables.
  • A record is returned for each combination of an accounting event header identifier, an accounting event line number, a subledger accounting ledger name, and a subledger accounting distribution detail line number.
33SLA Receivables Reconciliation This view returns information about the reconciliation of accounting and transactional data recorded in Oracle Fusion Receivables and Oracle Fusion Subledger Accounting with the journals posted to Oracle General Ledger for open receivables balances.
  • This information is accessible through Receivables > Accounts Receivable > Accounting > Receivables to Ledger Reconciliation.
  • A record is returned for each combination of a ledger name, an accounting period, a reconciliation request name, and a reconciliation item.

Accounts Receivable Dashboards

A dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is intended to convey different, but related information in an easy-to-digest form. And oftentimes, this includes things like key performance indicators (KPI)s or other important business metrics that stakeholders need to see and understand at a glance. Dashboards are useful across different industries and verticals because they’re highly customizable. They can include data of all sorts with varying date ranges to help you understand: what happened, why it happened, what may happen, and what action you should take. And since dashboards use visualizations like tables, graphs, and charts, others who aren’t as close to the data can quickly and easily understand the story it tells or the insights it reveals.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk