Accrual Reconciliation Report

When to Use

You should run this process when you need to review balances in the accrual account. This report is typically generated at the end of the financial reporting period.

Privileges Required

Run Accrual Reconciliation Report (CMR_RUN_ACCRUAL_RECONCILIATION_REPORT)

Specifications

Review the following before setting up this process:

Specification	Description
Job Type	Ad hoc job/On-demand
Frequency	You are encouraged to generate this report at least once per reporting period. You should avoid scheduling this process more often than necessary for your business purposes. Avoid scheduling the process on a frequency that might overlap. Ensure that you maintain a lag between the end of a scheduled process and the start of the next scheduled process.
Time of Day	Any time.
Duration	Runtime of this process will vary based on the number of transactions in the period.
Compatibility	The process is designed to automatically detect incompatibilities and will gracefully branch around the incompatibility, log errors, and exit when necessary. However, it's highly recommended to schedule the processes in such a way as to avoid overlapping process runs.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Business Unit	Required	You can run this process for a specific business unit to review the accrual balances.	Business Unit Name	N/A	You can run this report only for the business units you have access to.
Accrual Account	Optional	You can use an accrual account in combination with business unit to review the accrual balances.	Account Name	N/A	N/A
From Transaction Date	Required	Start date of a date range to filter the accrual balances.	Date	N/A	N/A
To Transaction Date	Required	End date of a date range to filter the accrual balances.	Date	N/A	N/A
From Item	Optional	Use this option to define the initial point of the item number range for filtering accrual balances by item.	Item number	N/A	Only useful when your item numbers are defined in a sequence.
To Item	Optional	Use this option to define the end point of the item number range for filtering accrual balances by item.	Item number	N/A	Using the From Item parameter without the To Item parameter may result in slower performance.
From Item Category	Optional	Use this option to define the initial point of the item category range for filtering accrual balances by item category.	Item category number	N/A	Only useful when your item categories are defined in a sequence.
To Item Category	Optional	Use this option to define the end point of the item category range for filtering accrual balances by item category.	Item category number	N/A	Using the From Item Category parameter without the To Item Category parameter may result in slower performance.
Supplier	Optional	Use this to review the accrual balances for a specific supplier.	Supplier Name	N/A	N/A
Supplier Site	Optional	Use this to review the accrual balances for a specific supplier site.	Supplier Site Name	N/A	N/A
Accrual Tolerance Amount Operator	Optional	A comparison operator to be used along with the specified Accrual Tolerance Amount	Operator	Used in combination with Accrual Tolerance Amount.	N/A
Accrual Tolerance Amount	Optional	Specify the accrual tolerance amount to filter the balances based on the specified Accrual Tolerance Amount Operator.	Amount	Used in combination with Accrual Tolerance Amount Operator.	N/A
Age of Last Transaction	Optional	Specify the age of the transaction to filter the accrual balances.		N/A	N/A

Here's how the Age of Last Transaction parameter is used by the process. The formula used is:

(Last Process Run Date – Latest Transaction Date) >= Age of Last Transaction

Here,

Last Process Run Date is the latest date on which any receipt accounting process such as Create Receipt Accounting Distributions, Uninvoiced Receipt Accrual Report, Match Receipt Accrual, and so on was run against the business unit for which you're generating the Accrual Reconciliation Report.

Latest Transaction Date is the maximum transaction date from receiving transactions, invoices, and retro price events.

Age of Last Transaction is the numeric value that you've entered when generating the report.

So, if you've entered the Age of Last Transaction as 30, then all the transactions where (Last Process Run Date - Latest Transaction Date) >= 30, will be considered when generating the Accrual Reconciliation Report.

You can optionally set the advanced parameters listed here.

Option	Description	Value	Notes
Schedule	Use this option to select the frequency of generating the report.	As soon as possible Using a schedule	N/A
Output	Use this option to control the layout & output file format of the report.	Name: User-defined Layout: Detail (default), Summary Format: HTML (default), CSV, Excel, PDF, Data, RTF	N/A
Notification	Use this option to trigger notifications for the users.	Recipient Condition	N/A

Troubleshooting Information

You can view the status of the process in the Scheduled Processes work area.
Error and warning messages encountered while running the process are displayed in the process log file.
When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.
To run the process, you must have data access to the appropriate cost organization.
If the report balance doesn't match with the accounted amount in General Ledger, ensure that you've interfaced all the invoices accounted in the period to Receipt Accounting by running the Transfer Costs to Cost Management process and also ran the Create Receipt Accounting Distributions process. Also review and resolve errors, if any, by running the Run Receipt Accounting Period End Validations process.