As-of Date Inventory Valuation Report

Use the As-of Date Inventory Valuation report to view and report on inventory values as of any selected date.

This report can be generated at the different levels listed here:

  • All cost organizations under a ledger

  • Item and valuation unit

  • Item and inventory organization

  • Item and subinventory.

This report is based on the cost reports processor data model and you must run the cost reports processor using the Create Cost Accounting Distributions process on a frequent basis to ensure that the data is current in the report and there are no mismatches with the period reports and the Inventory Valuation page.

When to Use

You can run this process anytime to view inventory value as-of a date in the past. The report augments existing Period Inventory Valuation Report and the Inventory Valuation page and should be used for viewing inventory valuation for a past date. For your accounting and month-end reconciliation purposes, use the existing period reports.

This report computes inventory balances for any as-of date by using the prior period ending inventory balance as base and adds value of receipts and issues from that date till the as-of date specified by you.

Privileges Required

  • Run Inventory Valuation Report (CST_RUN_INVENTORY_VALUATION_REPORT_PRIV)
  • Analyze Product Gross Margins (CST_ANALYZE_PRODUCT_GROSS_MARGINS)
  • Run Inventory Valuation Report (CST_RUN_INVENTORY_VALUATION_REPORT)

Specifications

Review the following before setting up this process:
Specification Description
Job Type Ad hoc job/on demand.
Frequency You can generate the report as and when required. You should avoid scheduling this process.
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
Summarization Level Required You can specify the level at which the inventory value must be summarized in the report.
  • Cost Organization
  • Item and Valuation Unit
  • Item and Inventory Organization
  • Item and Subinventory
N/A N/A
Cost Organization Required Provide the cost organization for which you want to view inventory value. Cost Organization Name N/A N/A
Cost Book Required Provide the cost book in combination with the cost organization to review the inventory valuation for a specific cost organization and cost book combination. Cost Book Name N/A N/A
Value As-of Date Required Provide the date for which you want to review the inventory valuation. Date N/A You can run this report for a past date.
Valuation Structure Type Required Use valuation type to review the inventory valuation for a specific type.
  • Asset (default)
  • Consigned
  • Expense
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. 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.