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.