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.
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.
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) to cost the financial transactions.
Execute the Accounting Line Creation process (CM_ALC) 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.
See Also
Costing Transactions and Creating Accounting Entries
Setting Up for Journal Generator
|
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 Enterprise ChartFields
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.
See Also
Defining Cross-Application User Preferences
Page Name |
Definition Name |
Navigation |
Usage |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
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.
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. |
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) |
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 |
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 |
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 |
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). |
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. |
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. |
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. |
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).
See Also
Defining Cross-Application User Preferences
Page Name |
Definition Name |
Navigation |
Usage |
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). |
|
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. |
|
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. |
|
RUN_CMS2011 |
Cost Accounting, Inventory and Mfg Accounting, Reports, Inventory Value History, Other Criteria |
Define additional criteria for 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.