PRINT PURCHASE PRICE VARIANCE ANALYSIS REPORT

Use this screen to print or preview the Purchase Price Variance Detailed and Summary report before actually running the process that creates journal entries on the Create Purchase Price Variance Journal Entry screen.

The reports generated on this screen are the PPV Analysis Detailed report (Standard Costing and Average Actual Costing) and the PPV Analysis Summary report (Standard Costing and Average Actual Costing). The PPV Analysis Detailed report includes variances for Project WIP (if screen option is selected), regardless of the post project WIP variance value for the inventory abbreviation. However, journal entries for project WIP variance is created on the Create Purchase Price Variance Journal Entry (INPPPV) screen only if the option to post project WIP variance is selected for the inventory abbreviation. The PPV Analysis Summary report is similar to the first report except that it shows the summary by project with combined MO totals.

If a particular variance account/organization has not been set up or is inactive, or period of performance fiscal year/period (FY/PD) start/end is not within selected FY/PD, the amounts are included in the report with a note that indicates this condition.

This screen cannot be used to create journal entries.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Accounting Period

Option

This field displays the number of periods for variance calculations. This is always One.

Fiscal Year

Enter, or use to select, the fiscal year for which purchase price variance is calculated.

Period

Enter, or use to select, the period for which purchase price variance is calculated.

Subperiod

Enter, or use to select, the subperiod for which purchase price variance is calculated.

Ending Date

This field displays the end date of the fiscal year, period, or subperiod. The value loads from the selected fiscal year, period, or subperiod.

Inventory Burden Rate Calculation Date/Time

This field displays the date and time when the inventory burden was last calculated.

Options

Burden Rate Source

Select an option to use for burden amount calculations when raw material burdening is on receipt. Options are Target to specify previously calculated target or Actual for actual inventory burden rates.

Print Options - Standard Costing

Print Report

Select this check box to print the reports for standard costing projects.

Project

Option

Select a range option for the Project ID for which purchase price variance analysis is to be previewed or printed. Valid options are All, One, Range, From Beginning, and To End.

Start

Enter, or use to select the starting Project ID

End

Enter, or use to select the ending Project ID.

Compare Standard Cost against

Select whether variance calculation should based on PO Receipt Cost or PO Voucher Cost.

Exclude Zero Variance Amounts

Select this check box to exclude from the report rows with zero variance.

Exclude Variance Amounts less than

Select this check box to exclude from the report rows with variances that are less than the specified minimum variance amount. Enter the minimum variance amount in the field next to this check box.

Inv Project Type

Include Project WIP Asset Variance

Select this check box to include Project WIP variances in the report.

Include Common Inventory Projects Asset Variance

Select this check box to include common inventory projects variances in the report.

Include Project Expense

Select this check box to include project expense variances in the report.

Print Options - Average Actual Costing

Print Report

Select this check box to print the reports for average actual costing projects.

Project

Option

Select a range option for the Project ID for which purchase price variance analysis is to be previewed or printed. Valid options are All, One, Range, From Beginning, and To End.

Start

Enter, or use to select the starting Project ID

End

Enter, or use to select the ending Project ID.

Exclude Zero Variance Amounts

Select this check box to exclude from the report rows with zero variance.

Exclude Variance Amounts less than

Select this check box to exclude from the report rows with variances that are less than the specified minimum variance amount. Enter the minimum variance amount in the field next to this check box.

For Average Actual costing report, comparison is between PO line costs (receipts) and PO voucher costs.

Inv Project Type

Include Project WIP Asset Variance

Select this check box to include Project WIP variances in the report.

Include Common Inventory Projects Asset Variance

Select this check box to include common inventory projects variances in the report.

Include Project Expense

Select this check box to include project expense variances in the report.