PeopleSoft Cost Management Reports: A to Z

CES5001

Update Production Costs

Lists all updates to the frozen standard costs that are used in production and associated with a specified cost type and version. Sort by standard cost group and item ID, descending variance, or item ID. When applied, these costs update the production standard cost record and revalue inventory by using the standard cost method in all storage areas including stores, inspection, finished goods, and work in process (WIP), as well as in process inventory. Options include printing the report without revaluing inventory, revaluing inventory and printing the report, or revaluing inventory without printing a report. The Report Only option previews the financial impact of the standard cost changes without affecting the current standard costs.

Cost Accounting > Item Costs > Update Costs > Cost Update/Revalue > Update Production

Select the Report Only-No Updates option or the Revalue Inventory and Report option.

RUN_CES5001

CES6000

Compare Cost Versions

Use to compare the item costs that are derived from a regular cost version to those of an engineering or simulation cost version, to analyze the impact of engineering changes to an item's cost, or to view the cost impact of changing the bill of materials (BOM) or process.

If you want to analyze the impact of BOM, routing, labor, machine, or overhead rate changes on item costs, you can roll up costs for a separate cost type and version. To see the impact of the changes, you can compare two different cost types for an item or two versions of a single cost type.

Cost Accounting > Item Costs > Reports > Compare Cost Versions > Compare Cost Version

RUN_CES6000

CMS1000

Average Cost Adjustments

Reports adjustments and updates to perpetual average costs and retroactive perpetual average costs. The report includes adjustments entered directly on the Adjust Average Cost page (CM_COST_ADJ) and the Adjust Retro Costs page (CM_COST_ADJ_RETRO) as well as the purchase price variance (PPV) and exchange rate variance (ERV) updates that occur automatically when the Transaction Costing process runs.

Cost Accounting > Item Costs > Reports > Average Cost Adjustments > Average Cost Adjustment/PPV

RUN_CMS1000

CMS2000

Item Cost Profiles

Lists cost profiles for items that are in a selected business unit.

Cost Accounting > Inventory and Mfg Accounting > Reports > Item Cost Profiles

RUN_CMS2000

CMS2001

Overridden Cost Profiles

Lists business unit items where the cost profile is different from what is specified in the cost profile group.

Cost Accounting > Inventory and Mfg Accounting > Reports > Override Cost Profiles

RUN_CMS2001

CMS2002

Item without Profiles

Lists business unit items that are not associated with a cost profile.

Cost Accounting > Inventory and Mfg Accounting > Reports > Items without Cost Profiles

RUN_CMS2002

CMS2010

On Hand Value Report

Lists on-hand quantity and value at the summary or detail level. Can be used for items with any cost method. The report can calculate WIP as of any point in time and is accurate to the extent that the Transaction Costing, Accounting Line Creation, and Journal Generator processes have been run. The report can also store snapshots of previously generated report data for historical reporting. Select the items that are to appear on the report by business unit, cost book, cost profile, item information, or accounting period. In addition, you can use it to compare the on-hand value by using floor and ceiling costs or last price used.

Cost Accounting > Inventory and Mfg Accounting > Reports > Inventory Value History

RUN_CMS2010A

RUN_CMS2010

RUN_CMS2011

CMS2015

Movement by Receipt

Summarizes depletions, and shows on-hand quantity and value by receipt line. The unit costs that are used to calculate receipt and depletion costs reflect costs at transaction time.

Cost Accounting > Inventory and Mfg Accounting > Reports > Movement by Receipt

RUN_CMS2015

CMS2016

Movement by Depletion

For each depletion line, this report prints the receipt that the system uses to deplete that transaction, by business unit, book, and item. The depletion cost is calculated based on the cost at processing time. The report does not display on-hand quantity or value.

Cost Accounting > Inventory and Mfg Accounting > Reports > Movement by Depletion

RUN_CMS2016

CMS2018

WIP Value History Report

Lists the inventory value of all actual WIP costs at a summary or detail level. The report can calculate WIP as of any point in time and is accurate to the extent that the Transaction Costing, Accounting Line Creation, and Journal Generator processes have been run. The report can also store snapshots of previously generated report data for historical reporting. Select the items that are to appear on the report by business unit, cost book, cost profile, item information, or accounting period.

Cost Accounting > Inventory and Mfg Accounting > Reports > WIP Value History

RUN_CMS2018A

RUN_CMS2018B

RUN_CMS2018C

CMS3000

Estimated vs. Actual Landed Costs

Lists the purchase price variances (PPV) for landed cost components.

Purchasing > Receipts > Reports > Estimate/Actual Landed Cost

RUN_CMS3000

CMS3010

Total Purchase Variance

Lists the purchase price variances (PPV) and exchange rate variances (ERV) for landed cost components.

Purchasing > Receipts > Reports > Total Purchase Variance

RUN_CMS3010

CMS3020

Standard Purchase Variance

For frozen standard items only, lists the purchase price variances (PPV) that are recognized at receipt of the item.

Purchasing > Receipts > Reports > Standard Purchase Variance

RUN_CMS3020

CMS9010

On Hand Balance Validation

Verifies that the quantities tracked by PeopleSoft Cost Management are the same as the quantities tracked by PeopleSoft Inventory. This report serves as an audit tool to help verify that every change to PeopleSoft Inventory quantity balances has been accounted for in the PeopleSoft Cost Management system.

Cost Accounting > Inventory and Mfg Accounting > Reports > On Hand Balance Validation

RUN_CMS9010

ENS1011

Costed Routing Report or Costed Eng Routing Report

Displays costs by item routing, including conversion and overheard conversion costs that are attached to the item routing by task or work center. Material costs can also be displayed if a BOM code is entered. Enter unit, item ID, cost type, cost version, routing code, and BOM code. All routing codes and BOM codes are available; the Cost Rollup process does not have to be run to retrieve the costs.

• Manufacturing Definitions > Resources and Routings > Routings > Costed Routing Report

• Engineering > Routings > Costed Eng Routing Report

RUN_ENS1011

INS7000

Inventory Value

Provides realtime, on-hand quantities and values for items using standard costing or perpetual weighted average costing. This report is not intended for actual cost items.

Cost Accounting > Inventory and Mfg Accounting > Reports > Current Inventory Value

RUN_INS7000

INS7050

Accounting Register

Lists accounting transactions with item information, transaction dates, and the posted ChartFields.

Cost Accounting > Inventory and Mfg Accounting > Reports > Accounting Register

RUN_INS7050

INS7100

Transaction Register

Lists all transactions by item ID.

Cost Accounting > Inventory and Mfg Accounting > Reports > Item Transaction Register

RUN_INS7100

SFS1000

WIP Inventory Value

(standard cost items only) Lists the value of all WIP items by production type sorted by account, item ID, or production area. Lists the value of all items that are in various stages of assembly, including material that is consumed from the WIP locations or issued as part of a production kit. This report also lists labor, machine, overhead, and outside processing costs that are incurred up to the point that the WIP inventory value report is run. This report does not include the costs of any scrapped components or assemblies, or assemblies that are completed to stock. You can select owned items and consigned items. Includes a line for waste costs.

Production Control > Close and Analyze Production > WIP Inventory Value Rpt

RUN_SFS1000

SFS1100

Close Production

Closes production schedules or production IDs, and calculates the variances that are incurred. Use the Report Only mode to view the production that can and cannot be closed as well as the variances that can be generated as a result of an accounting close. Combining numerous sort options assists in narrowing down the production close information that is reported.

Production Control > Close and Analyze Production > Close Production

RUN_SFS1100

RUN_SFS1100A

SFS1200

Reopen Production

Enables production to be reopened to record additional completions, material consumption, or actual hours. Use the Report Only mode to provide a preview of the financial impact of reopening production without creating reversing entries. Combining numerous sort options assists in narrowing down the production reopen information that is reported.

Production Control > Close and Analyze Production > Reopen Production

RUN_SFS1200

SFS1500

Production Variance Report

Lists variances for production IDs or production schedules for a specified production due date and shift and above a minimum monetary amount. Variances include configuration, usage, component yield, lot size, routing process, rework, teardown, production mix variance, and outside processing.

Production Control > Close and Analyze Production > Production Variance Report

RUN_SFS1500

SFS1600

Potential Production Variance Report

Lists potential production variances that exist in production above a monetary amount before closing for accounting production IDs and schedules. The report can be generated when in a production status of in process, pending complete, complete, and closed for labor. Variances include configuration, usage, component yield, lot size, routing process, rework, teardown, production mix variance, and outside processing.

Production Control > Close and Analyze Production > Potential Prdn Variance Rpts

RUN_SFS1600

SFS2005

Efficiency and Utilization Report

Details efficiency variances and utilization by work center. Within work centers, the production ID or schedule that utilizes the work center is specified.

Efficiency variance is the difference between the actual hours that are expended for an operation and the earned hours for the operation. Utilization compares the available hours for a work center to the actual hours that are recorded for a work center.

Production Control > Close and Analyze Production > Efficiency and Utilization Rpt

RUN_SFS2005

CM_EOM_VALUE

Inventory Cost Balancing Report

Compares changes in Inventory values [item and account level] to those on Inventory distribution accounting lines, to identify variances, for a given accounting period.

Cost Accounting > Inventory and Mfg Accounting > Reports > Inventory Cost Balancing Rpt

CM_EOM_VALUE_1

CM_EOM_VALUE_2

CM_EOM_VALUE_3