Periodic Average Cost Report

Use the Periodic Average Cost report to review the periodic average cost information for a given cost organization, cost book, and period.

When to Use

You should run this process when you need to review the periodic average cost information. This report is typically generated at the end of the financial reporting period.

Privileges Required

  • View Item Cost (CST_VIEW_ITEM_COST_PRIV)

Specifications

Review the following before setting up this process:
Specification Description
Job Type Ad hoc job/on demand.
Frequency You can generate this report at the end of a reporting period to review item costs for any outliers. You should avoid scheduling this process and run it on demand as and when there's a need to review the periodic average cost of the items.
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 Use cost organization to review the periodic average cost information for a specific cost organization. Cost Organization Name N/A N/A
Cost Book Required Use cost book in combination with cost organization to review the periodic average cost information for a specific cost organization and cost book combination. Cost Book Name N/A N/A
Period Name Required Use period name to review the periodic average cost information for a financial period. Period Name N/A N/A
Category Name Optional Use category name to review the periodic average cost information for a specific item category. Item Category Name N/A N/A
Item Optional Use item to review the periodic average cost information for a specific item. Item Name N/A N/A
Include Items with No Change in Cost from Prior Period Optional Select this parameter value to Yes, if you want to include items for which periodic average cost didn't change. Yes/No N/A Default value is No.
Valuation Type Optional Select the valuation type to review the periodic average cost information for a specific valuation type.
  • Asset
  • Consigned
  • Expense
N/A N/A
Cost Summarization Option Optional Use the cost summarization option to define the level of summarized information required.
  • Summarized
  • None
  • Cost Element Type
N/A Default value is Summarized.

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: Periodic Average Cost Default Report
  • Format: HTML (default), CSV, Excel, PDF, Data, RTF, PowerPoint
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.