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:
|
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. |