Cost Distribution Details Report

Use the Cost Distribution Details report to review the cost distributions and accounting information for cost transactions within a specified period.

The report provides a list of all cost distributions and accounting information such as accounting line type, account, and accounted amount along with basic transaction information in a spreadsheet friendly format. You also can run the report from the Review Cost Accounting Distributions page to review distribution in bulk for a given search criteria, such as purchase order reference number, work order reference number, costing status, and so on.

When to Use

The report is designed to help you extract insights from costing transactions. You should run this process when you need to review and analyze detailed cost distributions and accounting information within a specific reporting period. For optimal effectiveness, it's advisable to schedule this process to run once per reporting period.

Privileges Required

• Review Cost Distribution (CST_REVIEW_COST_DISTRIBUTIONS)

Specifications

Review the following before setting up this process:

Specification	Description
Job Type	Ad hoc job. Scheduled.
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	After the period end process is done.
Duration	Runtime of this process will vary based on the number of costing transactions and factors like items, valuation unit, and so on.
Compatibility	The process is designed to automatically detect incompatibilities and will gracefully branch around the incompatibility, log errors, and exit when necessary. However, it is 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
Search by	Required	Use the focused search by options to quickly search and review transactions.	Reference Number Item Number Costing Status Transaction Type	N/A	N/A
Cost Organization	Optional when Search by is Reference Number. Required for other search by options.	Use cost organization to review the distribution information for a specific cost organization.	Cost Organization Name	N/A	N/A
Cost Book	Optional when Search by is Reference Number. Required for other search by options.	Use cost book with cost organization to review the distribution information for a specific cost organization and cost book combination.	Cost Book Name	N/A	N/A
Period	Optional when Search by is Reference Number. Required for other search by options.	Use accounting period to further filter the distribution information for analysis.	Period Name	N/A	N/A
Transaction Date From	Auto-populated based on period.	Adjust the date range to filter the transactions.	Date	N/A	N/A
Transaction Date To	Auto-populated based on period.	Adjust the date range to filter the transactions.	Date	N/A	N/A
Reference Number	Required when Search by is Reference Number.	Search transactions by reference number such as, purchase order, transfer order, sales order, work order, or transaction reference. Optionally, you can use transaction date to limit search results.	Document Number	N/A	N/A
Item Number	Required when Search by is Item Number.	Search transactions by item number for a costing period. Optionally, you can use transaction date to limit search results when volume of data is high.	Item Number	N/A	N/A
Costing Status	Required when Search by is Costing Status.	Search for transactions in error or not processed status for a costing period.	Not processed Partially costed Fully costed Error Excluded	N/A	N/A
Transaction Type	Required when Search by is Transaction Type.	Search for transactions in a date range and, optionally, filter by transaction type.	Transaction Type	N/A	N/A
Accounting Line Type	Optional	Use accounting line type to further filter the distribution information for analysis.	Accounting Line Type	N/A	N/A

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: Cost Distribution Details 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 organizations.