PeopleSoft Cost Management 9.1 PeopleBook

Analyzing Financial Transactions

This chapter provides an overview of financial transaction analysis, lists prerequisites and common elements, and discusses how to:

Use the financial inquiry pages.
Generate reports of financial transactions.

Understanding Financial Transaction Analysis

Monitoring general ledger activity is very important in any environment. PeopleSoft Cost Management provides several tools to review financial transactions, including:

Using online inquiry pages to review transactions in an interactive mode.
Generating reports that give vital information on the financial health of an organization.

Prerequisites

You can begin to analyze financial information after PeopleSoft Cost Management accounting lines are created. To create accounting lines, you need to perform these functions:

Generate financial transactions by using PeopleSoft Distribution and Manufacturing.
Execute the Transaction Costing process (CM_COSTING) within the Cost Accounting Creation process to cost the financial transactions.
Execute the Accounting Line Creation process (CM_ALC) within the Cost Accounting Creation process to generate the accounting lines for the transactions.

Once the accounting lines are created, you can navigate, report on, and view accounting information within PeopleSoft Cost Management before it is processed through the Journal Generator.

After generating the accounting lines for the transactions, you can execute the Journal Generator process (FSPGJGEN) to prepare the transactions for posting to the journal. Once the Journal Generator process is completed, you have the ability to navigate from both PeopleSoft General Ledger and PeopleSoft Cost Management.

Setting Up for Journal Generator

Common Elements Used in This Chapter

	Click the View Related Links button to go to the Transfer Menu, where you can drill to general ledger and transaction details.
	Click the More Details button to view an additional page with more detailed information.
	Click the Download button to load the data that appears on the page to a Microsoft Excel spreadsheet.
FERC Code	Federal Energy Regulatory Commission identification codes. This field appears only if you select FERC reporting on the PeopleSoft Inventory Options page.
ChartFields	Chart of accounts that are used to record accounting entries and journal entries in PeopleSoft.
Cost Element	A code used to categorize the different components of an item's cost and also define the debit and credit ChartFields for accounting entries.
Transaction Group / Group	Predefined codes that are attached to different types of transactions, such as stocking, issues, adjustments, and so on.
Distribution Type	User-defined codes that are a subset of transaction groups. This enables you to break down a transaction group into customized categories.
Item Group	A grouping of items that enable you to design an accounting structure for a group of similar items, such as sporting equipment or dress shoes. The item group is attached to an item by using the Item Definition - General page.
Journal	The general ledger journal ID number. This is assigned when the journal entry is created.
Date	The journal date.
CM Unit	PeopleSoft Cost Management business unit, which is the same unit as the Inventory and Manufacturing business units.
Book Name	The cost book that is used to record the accounting entry.
Acctg Date (accounting date)	Date that the accounting line is created.
Base Amount	Transaction amount that is expressed in the base currency of the unit.
Base Quantity	The item's quantity in the standard unit of measure for the item.
Container ID	The identification number of the storage container that is used to stock this inventory.
Conversion Type	The type of conversion costs that are incurred in the manufacturing process. Conversion types include labor setup, machine setup, labor fixed run, machine fixed run, labor run, machine run, labor post production, machine post production, and manufacturing overhead.
OH Rate Type	Overhead rate type.
OH Lab/Mac	Overhead labor and machine.
Variance Type	Identifies the type of variance. The variances are: 01 configuration, 02 usage, 03 component yield, 04 labor lot size, 05 rtg var (process routing variance), 06 efficiency variance, 07 rate variance, 08 material lot size, 09 rework expense, 10 rework labor expense, 11 outside processing PPV, 12 mix variance, 13 teardown material expense, and 14 teardown conversion expense.
Variance Source	Indicates when the variance is recorded. A variance source of C (close) indicates that the variances are calculated when the production ID or schedule is closed for accounting by using Production Control, Close and Analyze Production, Close Production. A variance source of O (open) indicates that production is reopened and all previously recorded variances are reversed by using Production Control, Close and Analyze Production, Reopen Production.
Production Type	The type of production. The options are: PR (production), RW (rework), and TD (teardown).
TL Scrap	This-level scrap cost that is associated with the scrap cost transaction.
LL Scrap	Lower-level scrap cost that is associated with the scrap cost transaction.
Revalue Type	The types of revaluation include: 01 inv (inventory), 02 inspection, 03 WIP- component costs, 04 WIP - assembly costs, and 05 WIP - waste costs.
Shipping Charge Type	Shipping charge types include freight charges, miscellaneous charges, and non-stockable items.
CC Status	Options include: A (all), E (error), N (not budget checked), and V (valid).

See Also

Understanding PeopleSoft ChartFields

Using the Financial Inquiry Pages

Viewing financial transaction detail and its associated accounting entries is necessary when investigating a suspect entry in the general ledger or when performing daily monitoring of production activity. PeopleSoft Cost Management enables you to see this transaction information on different pages depending on the type of transaction that you are investigating.

The financial inquiry pages consist of:

Review Accounting Lines menu	Under this menu, three components enable you to review accounting entries, including, the Accounting Entries page, the Unposted Accounting Entries page, and the Posted Accounting Entries page.
Review Transaction Entries menu	Under this menu, nine separate pages give you the ability to view the most relevant information pertaining to the different types of transactions.
Review Transaction Details menu	Under this menu, nine separate pages give you the ability to review detailed information about the transaction that you select.

The Review Transaction Entries menu and the Review Transaction Details menu both include pages for you to review these types of entries:

Inventory transactions.
Earned conversion costs.
Production variances.
Production scrap costs.
Production actual costs.
Standard cost revaluations.
Average cost adjustments.
Actual cost adjustment.
Non-stock shipment transactions.

You choose how you want to view accounting entries on the pages that display them. Entries can display debits and credits in one column or two separate columns based on the selection of the Display Debit/Credit Amounts in Subsystems check box on the Overall Preferences page. This default is applied by user ID. In addition, ChartField security can be applied to these pages.

Enabling ChartField Security

Pages Used to View Transaction Entries

Page Name	Definition Name	Navigation	Usage
Overall Preferences	OPR_DEF_TABLE_FS1	Set Up Financials/Supply Chain, Common Definitions, User Preferences, Define User Preferences, Overall Preferences	Based on user ID, specify overall default preferences, including the display of debits and credits in one column or two separate columns for the inquiries under the Review Transaction Entries menu and the Review Transaction Details menu. Select the Display Debit/Credit Amounts in Subsystems check box to display accounting entries in separate columns for debits and credits. Do not select this check box to display accounting entries in a single Monetary Amounts column that uses positive numbers to represent debits and negative numbers to represent credits.
Inventory On Hand	CM_OH_INQUIRY	Cost Accounting, Inventory and Mfg Accounting, Analyze Inventory Accounting, Inventory On Hand Value	View the accounting profile and current on-hand quantity for any item within a business unit. This inquiry page displays the item's book names, costing methods, on-hand quantity, and the value of the on-hand quantity.
Unposted to GL	CM_DRILL_UNPST_DET	Cost Accounting, Inventory and Mfg Accounting, Review Accounting Lines, Unposted to GL, Unposted Accounting Lines	View unposted accounting lines. Unposted accounting lines represent financial transactions that are not yet processed by the Journal Generator process so they are not posted in the journal in PeopleSoft General Ledger. The general ledger has no record of these transactions at this point. ChartField security can be applied to this page. See Enabling ChartField Security.
Posted Accounting Lines	CM_DRILL_JRNL_DET	Cost Accounting, Inventory and Mfg Accounting, Review Accounting Lines, Posted to GL, Posted Accounting Lines	View posted accounting lines. Posted accounting lines represent financial transactions that are processed by the Journal Generator process originating from PeopleSoft Order Management, Purchasing, Inventory, and Manufacturing. These entries can now be posted to the appropriated journal in the general ledger. ChartField security can be applied to this page. See Enabling ChartField Security.
Accounting Entries	CM_ACCTG_LINE	Cost Accounting, Inventory and Mfg Accounting, Review Accounting Lines, Accounting Entries	To view accounting entries, enter the search criteria and click the refresh button. This page displays the both the debit and credit sides of the accounting entry and the complete ChartField combinations. ChartField security can be applied to this page. See Enabling ChartField Security.
Inventory Transactions - Transaction Entries	CM_DRILL_ACCT_INV	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Inventory Transactions, Inventory Transaction Entries	View the accounting entries for inventory transactions and the accounting entries for route to production transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Earned Conversion Costs - Transaction Entries	CM_DRILL_ACCT_ERN	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Earned Conversion Costs, Transaction Entries	View the accounting entries for earned-cost transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Variances - Transaction Entries	CM_DRILL_ACCT_VAR	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Production Variances, Transaction Entries	View the accounting entries for variance transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Scrap Costs - Transaction Entries	CM_DRILL_ACCT_SCP	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Production Scrap Cost, Transaction Entries	View the accounting entries for scrap-cost transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Actual Costs - Transaction Entries	CM_DRILL_ACCT_MFG	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Production Actual Costs, Transaction Entries	View the accounting entries for actual-cost transactions in PeopleSoft Manufacturing. ChartField security can be applied to this page. See Enabling ChartField Security.
Standard Cost Revaluations - Transaction Entries	CM_DRILL_ACCT_REV	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Standard Cost Revaluations, Transaction Entries	View the accounting entries for revaluation transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Avg Cost Adjustment Entries- Transaction Entries	CM_DRILL_ACCT_ADJ	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Avg Cost Adjustment Entries, Transaction Entries	View accounting entries for cost adjustment transactions to perpetual average and retroactive perpetual average items. This includes value adjustments and change average adjustments stored in the CM_COST_ADJ record. ChartField security can be applied to this page. See Enabling ChartField Security.
Actual Cost Adjustment Entries- Transaction Entries	CM_DRILL_ACCT_UADJ	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Actual Cost Adjustment Entries, Transaction Entries	View accounting entries for value adjustment transactions to actual cost items. This includes only value adjustments stored in the CM_USER_CST_ADJ record. ChartField security can be applied to this page. See Enabling ChartField Security.
Non Stock Shipment - Transaction Entries	CM_DRILL_ACCT_NSS	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Entries, Non Stock Shipment, Transaction Entries	View the accounting entries for non-stock shipment transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
Inventory Transactions - Transaction Details	CM_DRILL_INV_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Inventory Transactions, Transaction Details	View detailed information about inventory transactions and the accounting entries for route to production transactions. ChartField security can be applied to this page. See Enabling ChartField Security.
More Transaction Details	CM_DRILL_INV_IN	Click the More Details button on the Inventory Transactions - Transaction Details page.	Displays additional information that is associated with the transaction.
Earned Conversion Costs - Transaction Details	CM_DRILL_ERN_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Earned Conversion Costs, Transaction Details	View transaction detail that is associated with the earned-cost transaction. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Variances - Transaction Details	CM_DRILL_VAR_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Production Variances, Transaction Details	View transaction detail that is associated with the variance transaction. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Scrap Costs - Transaction Details	CM_DRILL_SCP_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Production Scrap Cost, Transaction Details	View transaction detail associated with the scrap-cost transaction. ChartField security can be applied to this page. See Enabling ChartField Security.
Production Actual Costs - Transaction Details	CM_DRILL_MFG_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Production Actual Costs, Transaction Details	View transaction detail that is associated with actuals costs of production. ChartField security can be applied to this page. See Enabling ChartField Security.
Standard Cost Revaluations - Transaction Details	CM_DRILL_REV_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Standard Cost Revaluations, Transaction Details	View transaction detail that is associated with the revaluation transaction. ChartField security can be applied to this page. See Enabling ChartField Security.
Avg Cost Adjustment Detail - Transaction Details	CM_DRILL_ADJ_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Avg Cost Adjustment Detail, Transaction Details	View transaction detail associated with the cost adjustment transaction for perpetual average and retroactive perpetual average items. This includes value adjustments and change average adjustments stored in the CM_COST_ADJ record. ChartField security can be applied to this page. See Enabling ChartField Security.
Actual Cost Adjustment Detail - Transaction Details	CM_DRILL_UADJ_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Actual Cost Adjustment Detail, Transaction Details	View transaction detail associated with value adjustment transactions for actual cost items. This includes only value adjustments stored in the CM_USER_CST_ADJ record. ChartField security can be applied to this page. See Enabling ChartField Security.
Non Stock Shipment - Transaction Details	CM_DRILL_NSS_DET	Cost Accounting, Inventory and Mfg Accounting, Review Transaction Details, Non Stock Shipment, Transaction Details	View transaction detail that is associated with the non-stock shipment transaction. ChartField security can be applied to this page. See Enabling ChartField Security.

Using the Drilling Functions for Cost Accounting Audit Trails

By using the financial inquiry pages, you can track financial transactions throughout the audit trail by drilling up to the journal entries and drilling down to the accounting entries. You can analyze financial transactions in a few different ways, including:

Viewing an entry in the general ledger and drilling down to the actual transaction details or entries that created the entry.
Viewing the financial transaction details or entries and drilling up to the journal entries that are created in the general ledger.
Drilling between the actual transaction detail and the accounting entries for the transaction before or after you perform the Journal Generator process.
Viewing accounting entries that are created without using the drill-up and drill-down functionality.
Generating reports that display the accounting register, inventory value, and transaction register.

Note. If you have purge or archive production data, you cannot view production-related costs such as earned labor, scrap costs or variances.

This diagram illustrates the drill up and drill down flow between transactions and accounting entries:

Flow chart diagram of the drill up and drill down features of PeopleSoft Cost Management

Understanding the Transfer Menu

Transfer menus enable you to navigate between the different inquiry pages. The transfer menus can vary, depending on the inquiry page. To access the transfer menu, click the View Related Links button for any account line number. This example illustrates the transfer menu that is available from the Posted Accounting Lines page in PeopleSoft Cost Management.

The new window option in the transfer menu gives you the ability to have more than one window open at a time, enabling you to analyze several transactions at one time.

Drilling Down from PeopleSoft General Ledger to PeopleSoft Cost Management

The drill-down feature begins at the General Ledger inquiry pages in PeopleSoft General Ledger. Select an entry and click its View Related Links button to access a transfer menu. Select a drill option from the menu, and you can navigate to the Posted Accounting Lines page in PeopleSoft Cost Management. After you select a posted accounting line, you can use another transfer menu to access the originating transaction detail page or the transaction accounting entry page. These transaction pages give you the ability to see the transaction details or accounting entries for a selected transaction.

Drilling Up from PeopleSoft Cost Management to PeopleSoft General Ledger

When you want to trace an originating entry up to the general ledger, you can drill up. You begin by viewing the transaction detail or transaction accounting entries in PeopleSoft Cost Management. Then select the transaction and click the View Related Links button to access a transfer menu. Select Drill Up from the menu to drill up to the Posted Accounting Lines page (if the transaction is processed by the Journal Generator process) or to the Unposted Accounting Lines page (if it is not yet processed by the Journal Generator process). From the Posted Accounting Lines page in PeopleSoft Cost Management, you can drill up to journal entries by using a transfer menu. You cannot drill up to the journal entries from the Unposted Accounting Lines page because the journal entries do not yet exist for those accounting lines.

Drilling Between the Transaction Details and Transaction Accounting Entries

When you are interested in viewing the transaction detail and transaction accounting entries only within PeopleSoft Cost Management, you can drill between the different types of information. To go from the transaction details to the transaction accounting entries, you select Transaction Entries from the transfer menu. To go from the transaction accounting entries to the transaction details, you select Drill Down from the transfer menu.

Understanding Inventory Transactions

Inventory transactions are any material movement transactions that have a financial affect on inventory balances, such as purchase receipts, adjustments, and issues. Inventory transactions include route to production kits transactions. Route to production kits transactions occur when an assembly item is completed on a production ID or schedule, and it can be routed to another production ID, where it is used as a component on the next-higher-level assembly. The component's issue method must be set to Kit in order for you to route directly to production. This inventory transaction information is derived from the transaction history records (TRANSACTION_INV and TRANS_INV_CM). Transactions that can be viewed on the Inventory Transactions inquiry pages are these transaction groups:

Transaction Group	Description
010	Receipt to Inspection.
012	Return to Vendor.
013	Return to Vendor from Inspection.
020	Putaway.
021	Receipts from Production.
022	IBU Transfer Receipts.
024	Customer Returns.
025	InterCompany Receipts.
026	Expensed Issue Return.
030	Usages & Shipments.
031	InterBU Transfer Shipments.
032	Non Stock Shipments.
034	Ship on Behalf of Other BU.
035	InterCompany Transfers.
036	InterUnit Expensed Issue.
037	VMI Interunit shipment
038	VMI Consumption
040	Physical Count Adjustments.
041	Cycle Count Adjustments.
042	IBU Transfer Adjustments.
050	User Adjustments.
051	Inventory Scrap.
052	Shipping Adjustment.
053	Floor Stock Issues/Ret.
054	Inventory Scrap for RTV.
060	Bin-To-Bin Transfers.
220	Component Kit
221	Route To Production Kit
222	Waste Completion.
223	Component/Output Transfers.
230	Component Consumption.
231	WM Usage (Maintenance Management Usage).
300	Gain/Loss on Trans Price.
301	InterCompany Cost of Goods.
302	ShipOnBehalf Gain/Loss.
400	Std Cost Variance Receipts.
402	Std Cost Exchange Rate Var.
461	PO Voucher Variance.

Understanding Earned Conversion Cost Transactions

Earned conversion costs account for all earned labor, machine, subcontracting, and overhead costs. The information that is on the Earned Conversion Costs inquiry pages is derived from the Earned Conversion Cost record (SF_EARNCONCOST). The transactions that create entries in this table are:

Transaction Group	Description
240	Earned Labor
211	WIP Revalue (Conv Costs)

Understanding Production Variance Transactions

Production variance transactions represent material variances and conversion variances that are incurred on a production ID or schedule when production is closed for accounting. The information is derived from the Production Variance record (SF_VARIANCES). The Production Variances inquiry pages use these variances:

Transaction Group	Description	Comprised of Variance Type	Description
261	Material Variances.	01	Configuration Variance.
		02	Usage Variance.
		03	Component Yield Variance.
		08	Material Lot Size Variance.
262	Conversion Variances.	04	Labor Lot Size Variance.
		05	Routing Process Variance.
263	Rework Expense.	09	Material Rework Expense.
		10	Labor Rework Expense.
264	Outside Processing PPV.	11– For standard cost makeable items, this transaction group records the variance between the standard cost and the purchase order price of the subcontracted service.	Outside Processing PPV.
265	Teardown Variance.	13	Teardown Material Expense.
		14	Teardown Conversion Expense.
407	Subcontract Standard Cost PPV2		For subcontracted purchases using standard costing, this is the purchase price variance that records the price difference between the purchase order and the voucher.
408	Subcontract Standard Cost PPV2 ERV		For subcontracted purchases using standard costing, this is the purchase price variance that records the exchange rate difference between the purchase order and the voucher.
415	RTV Variances.	Records the difference between the inventory value of goods being returned and the amount of the vendor refund recorded in accounts payable.	Return to Vendor Variance.
601	Wt Avg Upd Production Var.		Weighted Average Update Production Variance.
661	Actual Cost Variances.	For actual cost makeable items, this transaction group records the variance between the actual cost of the components and the standard cost of the end items.	Production Actual Cost Writeoff.
664	Subcontracted Cost.	For actual cost makeable items, this transaction group records the variance between the purchase order price and the voucher price of the subcontracted service for actual cost components.	Subcontracted Cost

Understanding Production Scrap Cost Transactions

Production scrap cost transactions account for the cost of assemblies that are scrapped in process while recording operation and assembly completions. The information that appears on the Production Scrap Costs inquiry pages is derived from the Assembly Scrap Cost record (SF_SCRAPCOST). The transaction groups that are used to record scrap are:

Transaction Group	Description
212	WIP Revaluation (Scrap)
250	Assembly Scrap

Understanding Production Actual Cost Transactions

Production actual cost transactions account for the actual cost of production when the make item uses an actual or average cost method. Actual production costs include the actual cost of materials, conversion costs, conversion overhead costs, subcontracted components, and additional costs. The information that appears on the Production Actual Costs inquiry pages is derived from the CE_ACTUAL_COST record. These transaction groups are used:

Transaction Group	Description
622	Actual Waste Cost
630	Overhead
640	Actual Labor Costs
645	Actual Machine Costs
651	Production Cost Writeoff
661	Actual Cost Variances
664	Subcontracted Cost

Understanding Standard Cost Revaluation Transactions

Standard cost revaluation transactions occur when you change standard costs and update the production cost record with the new version of costs. At that time, the system:

Calculates the change in inventory value by determining the change in cost and multiplying that difference by the quantity on hand in inspection, stores, and WIP locations.
Determines the change in WIP inventory by calculating the change in cost of components that are remaining in process, as well as the associated labor, machine, subcontracting, and overhead costs that are earned to that point.

The WIP revaluation information that appears in the Standard Cost Revaluations inquiry pages is associated with the revaluation of the components that are issued to the production ID or schedule as well as the revaluation of the assembly item itself. Detail information is derived from the Posted Item Cost Variance record (CE_ITEMCVAR_PST). The transaction groups are:

Transaction Group	Description
200	Inventory Revalue.
201	Inventory Reval-Inspection.
210	WIP Revalue (Comps, Assys).

Understanding Average Cost Adjustment Transactions

Average cost value adjustment transactions occur when adjusting the cost of the perpetual weighted average cost or the retroactive perpetual weighted average cost items and the resulting change in inventory value. Value adjustments for items using perpetual weighted average costing or retroactive perpetual weighted average costing can be:

Manually created using the Adjust Average Cost page or the Adjust Retro Costs page.
System created by the Transaction Costing subprocess within the Cost Accounting Creation process.

The information that appears in the Average Cost Adjustment inquiry pages is derived from the CM_COST_ADJ record. The transaction groups are:

Transaction Group	Description
205	Value Adjustment.
401	Wt Avg Updates from AP.
403	Wt Avg Cost Updates - ERV.
405	Wt Avg Update Writeoffs.

Understanding Actual Cost Adjustment Transactions

Actual cost value adjustment transactions occur when adjusting the cost of the actual cost items and the resulting change in inventory value. Actual cost items are adjusted using the Adjust Actual Cost component. The information that appears in the Actual Cost Adjustment inquiry pages is derived from the CM_USER_CST_ADJ record. The transaction group is:

Transaction Group	Description
206	Value Adjust/ActCost Items.

Understanding Non-stock Shipment Transactions

Non-stock shipment transactions occur when you specify a non-stocked item on a sales order in PeopleSoft Order Management and mark it for PeopleSoft Billing. The information on the Non Stock Shipment inquiry pages is derived from the Non-Stock Shipments record (CM_CST_NSSHIP). The transaction group is:

Transaction Group	Description
032	Non Stock Shipments.

Generating Reports of Financial Transactions

PeopleSoft Cost Management includes these reports to assist with the accounting and PeopleSoft Cost Management review:

Accounting Register (INS7050).
Inventory Value (INS7000).
Transaction Register (INS7100).
Item Cost Profiles (CMS2000).
Items with Overridden Profiles (CMS2001).
Items with no Profiles (CMS2002).
Inventory On Hand Value (CMS2010).
WIP Value History (CMS2018).
Movement by Receipt Line (CMS2015).
Movement by Depletion Line (CMS2016).
On Hand Balance Validation (CMS9010).

Pages Used to Report on Financial Transactions

Page Name	Definition Name	Navigation	Usage
Floor and Ceiling Values	CM_VALUE_REF	Cost Accounting, Item Costs, Define Rates and Costs, Floor and Ceiling Costs, Floor and Ceiling Values	To establish floor and ceiling values, use the Floor and Ceiling Values (CM_VALUE_REF_PGRP) component. These values are used when you run the Inventory On Hand Value report (CMS2010).
On Hand Value Report	RUN_CMS2010A RUN_CMS2010 RUN_CMS2011	Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History	Lists on-hand quantity and value at the summary or detail level. The report can also store snapshots of previously generated report data for historical reporting.
On Hand Value Report-Selection Criteria	RUN_CMS2010	Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History, Selection Criteria	Enter the data selection criteria for the on-hand value report.
On Hand Value Report-Other Criteria	RUN_CMS2011	Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History, Other Criteria	Define additional criteria for the on-hand value report.

Using the On Hand Value Report

Use this component to run the On Hand Value report, which shows on-hand quantity and value at the summary or detail level. This report can be used for items with cost profiles having any cost method. This report displays transactions that have been costed and posted to accounting lines as well as transactions that are posted to the general ledger.

The report can also store snapshots of previously generated report data for historical reporting. In addition, you can also use it to compare the on-hand value by using floor and ceiling costs or last price used.

Select Report Options

Access the On Hand Value Report process page (Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History).

Print, Don't Store Snapshot	Print the report that is to be generated, but do not store a snapshot of the report data for subsequent reprinting.
Print, Store Snapshot	Print the report that is to be generated, and store a snapshot of the report data for subsequent reprinting.
Don't Print, Store Snapshot	Generate the report and store a snapshot of the data, but do not print a report.
Print Stored Snapshot	Reprint a previously stored snapshot of the report.
Purge Stored Snapshot	Delete a previously stored snapshot of the report.

To print or purge a previously stored snapshot, select a process instance by number, business unit, or as of date.

Enter Selection Criteria

Access the On Hand Value Report-Selection Criteria page (Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History, Selection Criteria).

On the Selection Criteria tab: Select a Currency Code. Select a specific cost book to report on, or select All to include all of the books in the business unit. Select All, None, or a specific single cost profile group that is associated with the cost book. None applies to all items that have no association with a cost profile group. Select All or a specific cost profile that is associated with the book.

Also on the Selection Criteria tab: Select either All or Range (for a range of items). For an item range, enter the from item ID and the to item ID. Select an item group and an item family.

Complete the Selections on the Other Criteria tab

Access the On Hand Value Report-Other Criteria page (Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History, Other Criteria). Select whether to include consigned items. The choices are:

Consigned Inventory Only: Include only consigned items.
Exclude Consigned Inventory: Include only owned items.
Include Consigned Inventory: Include both owned and consigned items.

If its included, consigned inventory appears at the bottom of the items for each book.

The Sort option enables you to sort the On Hand Value report by several different methods.
Enter a storage area to limit the report to a specific storage area that is within the business unit.
Select the Include zero On Hand Qty Items check box to include items with no quantity in the report.
Select the as of date for which you are requesting the on-hand value. Select a system date or choose an accounting period.
Cost comparison: These options are only available for detail reports.

The choices are:
- None
  
  No cost comparison.
- Floor and Ceiling
  
  Compare floor and ceiling costs with the unit cost. You maintain floor and ceiling costs in the Floor and Ceiling Values page.
- Last Price Used
  
  Compare the last price used on a voucher or purchase order with the unit cost.
Report Type - Select Summary, or select Detail. The summary report shows totals by business unit, book, and item. Select to report by either Cost Category or Cost Element.