Costing Account Balances Report

Use the Costing Account Balances report to review and reconcile account balances at the end of a financial period. You can review the outstanding balances for the accounts by specifying the account type and the starting and ending periods for which you want to generate this report.

When to Use

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

Privileges Required

  • Run Costing Account Balances Report (CST_RUN_COSTING_ACCOUNT_BALANCES_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 frequently 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
Cost Organization Required Provide the cost organization for which you want to view the account balances. Cost Organization Name N/A N/A
Cost Book Required Provide the cost book with the cost organization to review the account balances for a specific cost organization and cost book combination. Cost Book Name N/A N/A
Account Type Required Select the account type for which you want to review the balances Account Type Name N/A N/A
From Period Required Provide the starting period from which you want to review the account balances. Period Name N/A N/A
To Period Required Provide the ending period to which you want to review the account balances. Period Name N/A N/A
From Item Optional Use this to define the initial point of the item number range for filtering the account balances. Item number N/A Only useful when your item numbers are defined in a sequence.
To Item Optional Use this to define the end point of the item number range for filtering the account balances. 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 to define the initial point of the item category range for filtering the account balances. Item category number N/A Only useful when your item categories are defined in a sequence.
To Item Category Optional Use this to define the end point of the item category range for filtering the account balances. Item category number N/A Using the From Item Category parameter without the To Item Category parameter may result in slower performance.

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: Default
  • Format: HTML, 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.