Period Inventory Valuation Report

Use the Period Inventory Valuation report for reviewing and reconciling inventory value at the item level for a combination of cost organization and cost book.

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

Item valuation level
Inventory Organization, Subinventory
Item Category, Inventory Organization, 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 view latest inventory valuation information.

When to Use

You can run this process anytime during the period to view current inventory value. You can also run this process for any prior periods and the report will provide inventory value as of the end of that period. You should run this process at the end of the period for reconciling inventory value on a periodic basis.

Privileges Required

Run Inventory Valuation Report (CST_RUN_INVENTORY_VALUATION_REPORT_PRIV)

Specifications

Review the following before setting up this process:

Specification	Description
Job Type	Ad hoc job/on demand.
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	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	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
Period	Required	Provide the period for which you want to review the inventory valuation.	Period Name	N/A	You can run this report for the current date or a prior period.
Inventory Organization	Optional	Provide the inventory organization for which you want to review the inventory valuation.	Inventory Organization Name	This parameter should only be used when the layout of report output is set to: By Inventory Organization, Subinventory By Item Category, Inventory Organization, Subinventory	Not applicable for the default By Valuation Unit, Item layout.
Subinventory Code	Optional	Provide the subinventory code for which you want to review the inventory valuation.	Subinventory Code	This parameter should only be used when the layout of report output is set to: By Inventory Organization, Subinventory By Item Category, Inventory Organization, Subinventory	Not applicable for the default By Valuation Unit, Item layout.
Item Type	Optional	Use item type to review the inventory valuation for a specific item type.	Item Type	N/A	N/A
Valuation Type	Required	Use valuation type to review the inventory valuation for a specific type.	Asset (default) Consigned Expense	N/A	N/A
Cost Summarization	Required	You can specify whether to summarize the total cost or show costs at the cost element level in the report.	Yes (default) No	N/A	N/A
From Item	Optional	Use this to define the initial point of the item number range for filtering the inventory valuation.	Item number	N/A	Only useful when your item numbers are defined in a sequence.
To Item	Optional	Use this to define the end point of the item number range for filtering the inventory valuation.	Item number	N/A	Using the From Item parameter without the To Item parameter may result in slower performance.
From Item Category	Optional	Use this to define the initial point of the item category range for filtering the inventory valuation.	Item category number	N/A	Only useful when your item categories are defined in a sequence.
To Item Category	Optional	Use this to define the end point of the item category range for filtering the inventory valuation.	Item category number	N/A	Using the From Item Category parameter without the To Item Category parameter may result in slower performance.
From Valuation Unit	Optional	Use this to define the initial point of the valuation unit range for filtering inventory valuation.	Valuation Unit Name	N/A	Only useful when your valuation units are defined in a sequence.
To Valuation Unit	Optional	Use this to define the end point of the valuation unit range for filtering inventory valuation.	Valuation Unit Name	N/A	Using the From Valuation Unit parameter without the To Valuation Unit parameter may result in slower performance.
Include Negative Inventory	Required	This attribute should be set to Yes if you are reconciling. You can set it to Negative Rows Only if you want to review items with negative inventory at valuation unit level.	Yes (default) No Negative Rows Only	N/A	N/A
Include Zero Cost Items	Required	Select Yes if you want to include items with zero cost	Yes (default) No	This parameter is applicable only if the layout of the report output is set to By Valuation Unit, Item.	N/A
Unaccounted Only	Required	Select Yes if you only want to filters items where inventory value is not entirely accounted.	Yes No (default)	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: By Valuation Unit, Item (default) By Inventory Organization, Subinventory - Costed and Accounted Value By Item Category, Inventory Organization, Subinventory - Costed and Accounted Value By Item Category, Inventory Organization, Subinventory - Inventory Value Format: HTML, CSV, Excel, PDF, Data, RTF	Which layout to use: To review the inventory valuation of items for each valuation unit, select By Valuation Unit, Item. To review the Costed and Accounted value for each subinventory and get a total at the inventory organization level, select By Inventory Organization, Subinventory - Costed and Accounted Value. To review the Costed and Accounted value of item categories within a subinventory and inventory organization, select By Item Category, Inventory Organization, Subinventory - Costed and Accounted Value. To review the inventory valuation of item categories within a subinventory and inventory organization, select By Item Category, Inventory Organization, Subinventory - Inventory Value.
Notification	Use this option to trigger notifications for the users.	Recipient Condition	N/A

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:
- By Valuation Unit, Item (default)
- By Inventory Organization, Subinventory - Costed and Accounted Value
- By Item Category, Inventory Organization, Subinventory - Costed and Accounted Value
- By Item Category, Inventory Organization, Subinventory - Inventory Value
Format: HTML, CSV, Excel, PDF, Data, RTF

Which layout to use:

To review the inventory valuation of items for each valuation unit, select By Valuation Unit, Item.
To review the Costed and Accounted value for each subinventory and get a total at the inventory organization level, select By Inventory Organization, Subinventory - Costed and Accounted Value.
To review the Costed and Accounted value of item categories within a subinventory and inventory organization, select By Item Category, Inventory Organization, Subinventory - Costed and Accounted Value.
To review the inventory valuation of item categories within a subinventory and inventory organization, select By Item Category, Inventory Organization, Subinventory - Inventory Value.

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.