Reports and Analytics for Receipt Accounting

You can use the Reports and Analytics work area to access predefined reports and analytics that are related to your role.

The reports available for Receipt Accounting are listed here. You can generate these reports for a specific business unit. You can optionally specify an item range or item category range, supplier, and supplier site to filter the information in the reports.

• Accrual Clearing Report

  The Accrual Clearing Report provides a list of accrual clearing transactions, for a purchase order and accrual account, that have been automatically or manually cleared. As a cost accountant, you would typically use this report during period end to review the accruals cleared. You must specify a date range within which the transactions occurred will be considered for generating the report. You can optionally specify the accrual account for which the report must be generated.

• Accrual Reconciliation Report

  The Accrual Reconciliation Report provides information for reviewing and reconciling accrual balances. You can manage the balance of accrued supplier liabilities for a business unit. As a cost accountant, you would typically use this report during period end to review balances in the accrual account.

  You must specify a date range within which the transactions occurred will be considered for generating the report. You can optionally specify the accrual account for which the report must be generated.

  You can also opt to specify an accrual tolerance amount and a comparison operator. For example, if Accrual Tolerance Amount > 0 means the received amount is greater than the invoiced amount. If Accrual Tolerance Amount = 0 means invoiced and received amounts are same. If Accrual Tolerance Amount < 0 means invoiced amount is greater than received amount.

  You can either generate a Detail report or a Summary report by specifying the layout during report generation.

• Uninvoiced Receipt Accrual Report

  The Uninvoiced Receipt Accrual Report provides information for reviewing uninvoiced purchase order receipts due for accrual or already accrued in a business unit for a given period. As a cost accountant, you would typically use this report during period end to review the receipt accruals.

  You must specify the accounting period for which you want to generate the report. You can also opt to specify an accrual tolerance amount and a comparison operator. For example, if Accrual Tolerance Amount > 0 means the received amount is greater than the invoiced amount. If Accrual Tolerance Amount = 0 means invoiced and received amounts are same. If Accrual Tolerance Amount < 0 means invoiced amount is greater than received amount.

  You can either generate a Detail report or a Summary report by specifying the layout during report generation.

  As a best practice, you must run the Create Uninvoiced Receipt Accruals process in the Report mode, to view the report data and then run the Create Uninvoiced Receipt Accruals in the Accounting Mode after the numbers are clean.

You can also manually generate these reports or schedule automatic generation of these reports from the Scheduled Processes work area.

Predefined OTBI Reports

You can also use the various predefined OTBI reports to generate, review, and analyze the relevant information. These reports, which you can modify as per your requirements, can be accessed from Shared Folders/Supply Chain Management/Cost Management/Transactional Analysis Samples.

• Goods Received Not Invoiced: This dashboard is available under the Receipt Accounting Distributions subfolder.

• Receipt Accounting Period End Validation Error Transactions: This dashboard is available under the Period End subfolder.

• Receipt Accounting Period End Validation Summary: This dashboard is available under the Period End subfolder.

• Uninvoiced Period End Receipt Accruals: This dashboard provides these reports:

  • Uninvoiced Receipts Period End Accrual Summary

  • Uninvoiced Receipts Period End Accrual Details

  • Accrue at Period End Purchases Receipt Details

  • Accrue at Period End Purchases Invoice Details

  You must run the Create Uninvoiced Receipt Accruals process either in the Report or Accounting mode for the data to be available for analyzing and reporting in OTBI.

OTBI Subject Areas

In addition to the predefined reports, you can generate custom reports and analytics by using the subject areas listed here:

• Receipt Accounting Real Time

• Receipt Accounting Period Close Real Time

• Receipt Accounting Uninvoiced Receipt Accruals Real Time

• Landed Costs Real Time

For more information on accessing and modifying reports and analytics, refer to the guide Creating and Administering Analytics and Reports.