WIP Inventory Value Report

Use the Work in Process (WIP) Inventory Value report to review and reconcile the WIP inventory value. You can review this information to analyze work orders that are in released, completed, or cancelled status.

When to Use

You should run this process when you need to review and analyze the WIP inventory value for a specific reporting period.

Privileges Required

• Run WIP Inventory Valuation Report (CST_RUN_WIP_INVENTORY_VALUATION_REPORT)

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 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	Use cost organization to review the WIP inventory value 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 WIP inventory value information for a specific cost organization and cost book combination.	Cost Book Name	N/A	N/A
Plant	Optional	Select a plant to include only the WIP inventory value information for a specific plant.	Plant Name	N/A	N/A
Work Method	Optional	Select the work method to review WIP inventory value information for a specific work method.	Discrete Manufacturing Process Manufacturing
Work Order Type	Optional	Select the work order type to review WIP inventory value information for a specific work order type.	Standard Nonstandard Rework Transform
Work Order Subtype	Optional	Select the work order subtype to further filter out WIP inventory value information for specific work order subtype.	Standard Production Prototype Repair Pilot Lot Test Lot		Default value is Standard.
Valuation Basis	Required	Select to review the costed or accounted value as of a given date.	Costed Accounted		Default value is Costed.
From Item	Optional	Use this option to define the initial point of the item number range for filtering the WIP inventory value information by item.	Item number	N/A	Only useful when your item numbers are defined in a sequence.
To Item	Optional	Use this option to define the end point of the item number range for filtering the WIP inventory value information by item.	Item number	N/A	N/A
From Item Category	Optional	Use this option to define the initial point of the item category range for filtering the WIP inventory value information by item category.	Item category number	N/A	Only useful when your item categories are defined in a sequence.
To Item Category	Optional	Use this option to define the end point of the item category range for filtering the WIP inventory value information by item category.	Item category number	N/A	N/A
Value As-of Date	Required	Provide the cut-off date for including the WIP inventory value in the report.	Date	N/A	N/A
Work Order Scope	Optional	Define the scope of work orders to be included in the report.	Contract Manufacturing work orders Work orders that are not contract manufacturing All work orders	N/A	N/A
Order By	Optional	Define the order of listing for the report.	Ascending Descending	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 Plant, Item By Plant, Item, Work Order By Item Category, Item, Work Order By Work Order Type, Work Order Subtype, Work Order Format: HTML (default), CSV, Excel, PDF, Data, RTF	Which layout to use: If you want to see the value of items for each plant in a specific cost organization, select By Plant, Item. If you want to see the WIP value of items but broken down by work order and plant, select By Plant, Item, Work Order. This gives you a more detailed view of how WIP balance is distributed across work orders and plants. If you prefer to see the WIP value of items grouped by item category and work order, select By Item Category, Item, Work Order. If you want to analyze the inventory value of items with even more detail, select By Work Order Type, Work Order Subtype, Work Order.
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.