Periodic Average Cost Details Report

Use the Periodic Average Cost Details report to review the transactions that contributed to the periodic average cost computation of the items in a given period. You can view the information for a selected cost organization, cost book, period, item, and valuation unit.

When to Use

You should run this process when you need to review the transactions that were considered for computing the periodic average cost of items in a period. 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 transactions for periodic average cost of the items.
Time of Day Any time.
Duration Runtime of this process will vary based on the number of inventory 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 transactions of an item belonging to 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 transactions 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 transactions for an item in a financial period. Period Name N/A N/A
Item Required Provide the item for which you want to review the periodic average cost transactions. Item Name N/A N/A
Valuation Unit Required Specify the valuation unit to review the periodic average cost transactions for an item. Valuation Unit Name N/A N/A
Valuation Type Optional Select the valuation type to review the periodic average cost transactions 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 None.

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.