1. Support Desk.
  2. Roles
  3. ERP Armor: Roles for ERP Cloud

More information about DUT047, Financials Subject Area - Receivables to Ledger Reconciliation Transaction

The following is additional information provided by Oracle... These are the business questions that can be answered from this (these) subject area(s) contained in this rule:

• What are the transaction details that make up the summary view for receivable and accounted amounts in the summary report?
• What is the differences between receivable transactional amount and accounted amount, and how to resolve or
reconcile the differences?
• What portion of transactions is made up of invoices, credit memos, chargeback, or debit memos?
• What adjustments are against which transactions?
• What are the most common reasons for credit memos?
• What are the receivable and accounting beginning and ending balances for the period?
• What is my total receipt amount by currency and remittance bank account?
• What is the payment schedule for installment invoices over time?
• What is the total amount of transactions for a specific customer?
• What is the total of all adjustments for the period, by business unit?
• What types of credit are generated most often by customers?
• What was the volume of credit card refunds and chargebacks for the period?
• When are receipts cleared?
• When were confirmed receipts remitted?
• Which invoices have been disputed?
• Which receipts are posted to the customer's account but not applied to invoices?
• What is the amount and count of miscellaneous receipts for the period by business unit, bank account name,
and bank account number?
• What is the total amount of all transactions for the period by business unit?
• What payables invoices for a given supplier have contributed to a given account balance for a given period?
• What unposted journals exist for a given period?
• Which transactions affect the customer open balance for collections purposes, but not the general ledger
account balance?
• What are the most prevalent reversal reasons that may indicate a process improvement is needed?
• What is the account balance for a given account and cost center for a given period?
• What is the accounted amount by bank for receipts for the period by business unit?
• What is the status of credit requests?
• What journals were created for a given period and category?
• What is the status of the open credit memo requests for the period by business unit?
• What transactions were my credit memos applied to for the period by Business unit?
• What types of credit are most frequently requested?
• What is the amount of open bills receivable pending acceptance for the period by business unit?
• What receipts were applied to other receipts allowing the combined balance to be applied to invoices?
• What receipts were reversed for a specific remittance bank over a range of reversal dates?
• What is the total amount of open credit memo requests for the period by business unit?
• Which adjustments require investigation or rejection?
• Which miscellaneous receipts from previous months were reversed this month?
• Have automatic receipts been approved?
• What credit memo requests were approved for the period by business unit?
• What journals were created for a given account by source for this period?
• What receivables invoices for a given customer have contributed to a given account balance for a given period?
• What unapproved journals exist for a given period?
• Which receipts do not have the customer identified?
• What are the period statuses for a given set of ledgers?
• What is the exchange gain and loss due to exchange rate conversions?
• What is the most common reason for an adjustment?
• What is the original amount due, remaining amount due by business unit, by customer, and by due date?
• What is the total amount of revenue adjustments by item and time period?
• What is the total of all adjustments for the period?
• What project costing transactions have contributed to a given account for a given period?
• Which customers generate the most credit memos?
• What are the journal entered and accounted amounts for a given account and period?
• What is the account balance for a given account for a given period and the journals that contribute to the
balance in the period?
• What is the amount and count of miscellaneous receipts for the period by business unit, general ledger account,
and cost center?
• What is the amount of open bills receivable pending remittance for the period by business unit?
• What is the total amount of receipt applications for the period by business unit?
• What journals were created for a given period for a given account?
• What receipts are not applied during the period by business unit?
• Which receipts had earned or unearned discounts and how much for each?
• Which sub ledger journals have posted accounting entries to a given account balance for this period?