Contents of the Print Purchase Price Variance Analysis Report Screen

Use the fields and options to configure the Print Purchase Price Variance Analysis Report screen.

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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on 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

Field Description
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

Field Description
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

Field Description
Print Report

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

Project

Field Description
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

Field Description
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

Field Description
Print Report

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

Project

Field Description
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.

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

Inv Project Type

Field Description
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.