Receivables - Miscellaneous Receipts Real Time

Description

Real time information on miscellaneous receipts, such as non-AR trade related receipts, credit card refunds and credit card chargebacks, including the associated distributions, accounting details and remittance bank information.

Business Questions

This subject area can answer the following business questions:

• What was the volume of credit card refunds and chargebacks for the period?

• What is the amount and count of miscellaneous receipts for the period by business unit, bank account name, and bank account number?

• What are the most prevalent reversal reasons that may indicate a process improvement is needed?

• Which miscellaneous receipts from previous months were reversed this month?

• What receipts were reversed for a specific remittance bank over a range of reversal dates?

• What is the amount and count of miscellaneous receipts for the period by business unit, general ledger account, and cost center?

Job Roles

The following job roles secure access to this subject area:

• Accounts Receivable Manager

• Accounts Receivable Manager Segregated Role

• Accounts Receivable Specialist

• Accounts Receivable Specialist Segregated Role

• Billing Manager Segregated Role

• Billing Specialist Segregated Role

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• Receivables Receipts Transaction Analysis Duty

• Receivables to Ledger Reconciliation Transaction Analysis Duty

Primary Navigation

Home > Receivables > Accounts Receivable > Manage Receipts

Time Reporting

This subject area supports non-AR trade related receipts, credit card refunds and credit card chargebacks history.

Time dimension is linked to Receipt Date.

Transactional Grain

This subject area returns data at the grain of Receipt Distribution with these filter conditions applied:

AR_CASH_RECEIPTS_ALL.Type='MISC' (Key Join at the lowest grain -> AR_DISTRIBUTIONS_ALL.SOURCE_ID = AR_MISC_CASH_DISTRIBUTIONS_ALL.MISC_CASH_DISTRIBUTION_ID AND AR_DISTRIBUTIONS_ALL.SOURCE_TABLE = 'MCD' AND AR_MISC_CASH_DISTRIBUTIONS_ALL.CASH_RECEIPT_ID = AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID AND AR_CASH_RECEIPTS_ALL.TYPE = 'MISC').

Note that Fusion Financials data security may further restrict the data being returned in OTBI as OTBI uses the same data security as Oracle Fusion Financials.

Special Considerations

None.