Period Layer Inventory Valuation Report
Use the Period Layer Inventory Valuation Report to review all receipt layers with quantity remaining that make up the inventory balance at the valuation unit level. You can run this report for the current date or any prior periods.
When to Use
You can run this process anytime during the period to review receipt layers with remaining quantity, unit cost and value. This report is most applicable for actual cost method but can also be used for perpetual average and standard cost methods.
Privileges Required
- Run Layer Inventory Valuation Report (CST_RUN_LAYER_INVENTORY_VALUATION_REPORT)
Specifications
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 layer transactions. | Cost Organization Name | N/A | N/A |
Cost Book | Required | Provide the cost book in combination with the cost organization to review the inventory layer transactions for a specific cost organization and cost book combination. | Cost Book Name | N/A | N/A |
Inventory Organization | Optional | Provide inventory organization to review the inventory layer transactions for a specific inventory organization. | Inventory Organization Name | N/A | N/A |
Subinventory Code | Optional | Provide subinventory code to review the inventory layer transactions for a specific subinventory. | Subinventory Code | N/A | N/A |
Period | Required | Provide the period for which you want to review the inventory layer transactions. | Period Name | N/A | N/A |
Valuation Type | Required | Use valuation type to review the inventory layer transactions for a specific type. |
|
N/A | N/A |
Valuation Unit | Optional | Provide valuation unit to further filter the inventory layer transactions for by specific valuation unit. | Valuation Unit Name | N/A | N/A |
Project Number | Optional | Provide project number to review the inventory layer transactions for a specific project. | Project Number | N/A | N/A |
Country of Origin | Optional | Provide country of origin to filter the inventory layer transactions by specific country of origin. | Country Name | N/A | N/A |
Item Type | Optional | Use item type to review the inventory layer transactions for a specific item type. | Item Type | N/A | N/A |
From Item | Optional | Use this to define the initial point of the item number range for filtering the inventory layer transactions. | 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 layer transactions. | 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 layer transactions. | 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 layer transactions. | Item category number | N/A | Using the From Item Category parameter without the To Item Category 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. |
|
N/A | N/A |
Include Zero Cost Items | Required | Select Yes if you want to include items with zero cost |
|
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. |
|
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. |
|
N/A |
Output | Use this option to control the layout & output file format of the report. |
|
Which layout to use:
|
Notification | Use this option to trigger notifications for the users. |
|
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.