PeopleSoft Cost Management Selected Reports

This section provides detailed information about individual reports, including important fields. The reports are listed alphabetically by report ID.

Field or Control

Description

As of Date

Determines which items to include in the report. Items open on the as of date are included.

The process page that you use to generate this report includes these fields:

Field or Control

Description

Date From/Date To

Specify a range of dates for all transactions that are to be included in the report. If you fail to enter a date from, the report includes all transactions that are on file from the start of history. If you fail to enter a date to, the report includes all transactions up to the end of the existing history.

Cost Adjustments

Select to include the cost adjustments that are made through the Adjust Average Cost page.

PPV Updates

Select to include the adjustments that are made to the perpetual weighted average cost because of purchase price variances and exchange rate variances. These adjustments are made when you run the Transaction Costing process (within the Cost Accounting Creation process) after you select the Apply Perpetual Average Adjs check box.

Select a Cost Profile Group option:

Field or Control

Description

All

Items that are associated or not associated with a cost profile group.

None

Items that are not associated with any cost profile group.

Specific

Items that are associated with a specific cost group profile.

The process page that you use to generate this report includes these fields:

Field or Control

Description

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.

On the Other Criteria tab, select a report type of Summary, or Detail. The summary report shows totals by business unit, book, and item. The detail report displays costs broken down by business unit, book, item, and cost element.

The process page that you use to generate this report includes these fields:

Field or Control

Description

From Transaction Date/To

Specify a range of dates for all transactions that are to be included in the report.

View

Select to view data on the report by:

Component: The cost component. Also called the miscellaneous charge code.

Group: The landed cost group ID. This option groups one or more miscellaneous charge codes.

The process page that is used to generate this report includes these fields:

Field or Control

Description

From Transaction Date/To

Specify a range of dates for all transactions that are to be included in the report.

View

Select to view data on the report by:

Component: The cost component. Also called the miscellaneous charge code.

Group: The landed cost group ID. This option groups one or more miscellaneous charge codes.

Tolerance %

You can enter tolerance percentage to report only variances exceeding a certain percentage of the standard component cost. The tolerance is defined by cost component (miscellaneous charge code) on the Misc Charge/Landed Cost Definition page.

The process page that you use to generate this report includes these fields:

Field or Control

Description

From Transaction Date/To

Specify a range of dates for all transactions that are to be included in the report.

Tolerance %

You can enter tolerance percentage to report only variances exceeding a certain percentage of the standard component cost. The tolerance is defined by cost component (miscellaneous charge code) on the Misc Charge/Landed Cost Definition page.

The report includes:

Field or Control

Description

Adjustments

This column includes differences between onhand quantities in PeopleSoft Cost Management and PeopleSoft Inventory. Reasons for these differences include:

  • Inventory transactions from the TRANSACTION_INV table which have not yet been captured into PeopleSoft Cost Management. These uncosted transactions occur when inventory movement that has not yet been processed by the Transaction Costing process.

  • Inventory items that have been picked but not shipped. The item's onhand quantity in PeopleSoft Inventory is updated, but a TRANSACTION_INV row has not been created. Instead, the information resided in the IN_DEMAND table and the DEMAND_PHYS_INV table. These picked but not shipped items must be included in the comparison of PeopleSoft Cost Management and PeopleSoft Inventory onhand quantities since they have already changed inventory quantities, but not the Cost Management quantities.

Prior to running the inventory value report:

  • Use the Complete Putaway process to put away all pending inventory in the appropriate storage areas, ensuring that the system has accounted for all inventory in the enterprise.

  • Run the complete shipping and Deplete On Hand Qty processes to ensure that the item's quantities at the business unit level match the item's quantities at the location level.

You do not need to run the Transaction Costing process for this report to be accurate.

Field or Control

Description

Inventory Cost Type

Options are: Perpetual Weight Avg Costed (perpetual weight average costed), All Costed Inventory Items, and Standard Costed. This report is not intended for actual cost items.

Consigned Items

Select whether to include consigned items (this field is available only if any of the items that are to be reported are consigned). Options are: Consigned Inventory Only, Exclude Consigned Inventory, and Include Consigned Inventory.

Item Options

You can choose to report based on All or on a Single Item ID. If you select All, you can restrict the items that are reported by Item Group or by Family.

The Date Optiongroup box offers several choices:

Field or Control

Description

Today

Report transactions for today's date only.

As Of Date

Report transactions as of the date that is specified.

Date Range

Report transactions occurring between the two dates that are specified.

The Date Option group box offers several choices:

Field or Control

Description

Today

Report transactions for today's date only.

As Of Date

Report transactions as of the date that is specified.

Date Range

Report transactions occurring between the two dates that are specified.

The process page that you use to generate this report includes these fields:

Field or Control

Description

Variance Posting Date

The dates that production is closed for accounting.

Prdn Due Date/Shift

Enter a beginning and end production due date and shift. The Shift field value must be between 1 and 3.

Variance Tolerance Amount

Enter the minimum monetary amount on which you want to display report results. By specifying a minimum monetary amount, you can focus in on those production IDs or production areas with significant variances. Enter 0.00 to report all variances for the production that is selected.

The process page that you use to generate this report includes these field:

Field or Control

Description

Report Variance Above Amount

Enter the lower limit for variances that you want to see. If, for example, you enter 1000.00 here, only those production IDs and schedules with a variance over 1000.00 are reported. To see variances on all production, enter 0.00. A favorable or unfavorable variance above the specified amount is reported.

The process page that you use to generate this report includes these fields:

Field or Control

Description

Detail or Summary Report

A detail report displays the earned and actual labor reported by production ID or production schedule for the work center. The summary report displays earned and actual labor by work center without the production ID or production schedule detail.

Entry Date

Specify the date range for which you want to report efficiency variances and utilization. The report includes all earned labor or machine hours or all actual hours that are recorded within the dates that are specified.