Period In-Transit Valuation Report

Use the Period In-transit Inventory Valuation report to reconcile end of period in-transit inventory balances. This report provides information to review the costed or accounted inventory balance in transit for a prior period or the current value of in-transit inventory in the current period.

When to Use

You should run this process when you need to review and reconcile the end of period in-transit inventory balances. This report is typically generated at the end of the financial reporting period.

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	Adhoc/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	Run time 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 the in-transit 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 in-transit inventory value 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 in-transit inventory value.	Period Name	N/A	N/A
Item Type	Optional	Use item type to review the in-transit inventory value 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 in-transit inventory value.	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 in-transit inventory value.	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 in-transit inventory value.	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 in-transit inventory value.	Item category number	N/A	Using the From Item Category parameter without the To Item Category parameter may result in slower performance.
Sending Organization	Optional	Use sending organization to review in-transit value for a specific shipping inventory organization.	Inventory Organization Name	N/A	N/A
Receiving Organization	Optional	Use receiving organization to review in-transit value for a specific receiving inventory organization.	Inventory Organization Name	N/A	N/A
Valuation Basis	Required	Provide valuation basis to indicate whether the report should be generated for the costed in-transit inventory value or accounted in-transit inventory value.	Costed (default) Accounted	N/A	N/A
Valuation Type	Required	Use valuation type to review the in-transit inventory value for a specific type.	Asset and Expense (default) Asset Consigned Expense	N/A	N/A
Flow Type	Required	Specify the flow type for which the report must be generated.	All (default) In Transit Interorganization transfer Transfer Order In Transit Interorganization transfer Transfer Order In Transit Intraorganization transfer Interorganization Transfer Order Issue to Expense with Receipt	N/A	N/A
Include Zero Cost Items	Required	Select Yes if you want to include items with zero cost	Yes (default) No	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-Total Costs (default) No–Cost Element Level	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 Inventory Organization, Category, Item, Shipment Detailed By Inventory Organization, Item Summary No Summarization (default) Format: HTML, CSV, Excel, PDF, Data, RTF	Which layout to use: To review the in-transit inventory value summarized for each item, item category at inventory organization level, select By Inventory Organization, Category, Item, Shipment Detailed. To review the in-transit inventory value summarized for item at inventory organization level, select By Inventory Organization, Item Summary. To review the values in a flattened view, select No Summarization.
Notification	Use this option to trigger notifications for the users.	Recipient Condition	N/A

Troubleshooting Information

• You can view the status of the process on the Scheduled Processes page.

• 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 page.

• To run the process, you must have data access to the appropriate cost organization.