RECOMPUTE AND PRINT DISCREPANCIES

Use this screen to recompute and/or print discrepancies between the purchase order voucher line and the purchase order line. The discrepancies are stored at the purchase order voucher line level. All purchase order vouchers that have not been posted by voucher distribution are eligible for inclusion.

Because the discrepancy report is not part of the Costpoint audit trial, you are not required to retain it. You may, however, find it useful to retain a printed copy for your records.

Screen Contents

This screen has three blocks:

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

Use the options in this group box to select the basis for recomputing and/or printing.

(Compute By)

From the drop-down list, select the basis for recomputing and/or printing:

Option

Use this drop-down list to select the range of values to be included. Valid options are:

Start

Enter, or click to select, the starting value for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending value for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.

When you select a numeric range to print, the beginning value in the Start field must be less than the beginning value in the End field. For example, if the beginning value in the Start field is 8 and the beginning value in the End field is 23, you must enter 08 in the Start field.

Entry User

Use the fields in this group box to select the range of user IDs whose purchase order vouchers should be included when you recompute or print discrepancies.

Option

Use this drop-down list to select the range of user IDs to be included. Valid options are:

Start

Enter, or click to select, the starting user ID for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending user ID for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.

When you select a numeric range to print, the beginning value in the Start field must be less than the beginning value in the End field. For example, if the beginning value in the Start field is 8 and the beginning value in the End field is 23, you must enter 08 in the Start field.

Options

Print Selection

From the drop-down list, select a setting to determine which purchase order vouchers are included in the report, provided that all other selection criteria are met:

Print/Recompute Discrepancies for Open  PO vouchers

Select this option when you click the drop-down list on the toolbar menu to recompute discrepancies for the selected open purchase order vouchers and print the results.

Recompute Discrepancies for Open PO vouchers

Select this option when you click the drop-down list on the toolbar menu to recompute the discrepancies and, after completion, print the discrepancy reports. After the process starts, you can still cancel the job.

The discrepancy calculations are as follows:

For 2-way matching:

Manage Purchase Order Vouchers' Total Before Discount Amount (for all vouchers of that purchase order line) minus Manage Purchase Orders' Total Line Amount (will not include sales tax if sales tax was not charged on the voucher)

For 3-way matching:

Manage Purchase Order Vouchers' Total Before Discount Amount (for all vouchers of that purchase order line) minus ((PO Accepted Amount plus PO Rejected Amount - Pay) times (1 + Ship ID Sales Tax Rate)) minus PO Line Charge Cost Amount minus PO Line Charge Sales Tax Amt

This calculation depends on the type of matching for the voucher line.

For 2-way matching:

(Manage Purchase Order Vouchers' Invoice Quantity (for all vouchers of that purchase order line) minus Manage Purchase Orders' Ordered Quantity) divided by Manage Purchase Orders' Ordered Quantity

For 3-way matching:

(Enter PO Vouchers' Invoice Quantity (for all vouchers of that purchase order line) minus (PO Accepted Quantity plus PO Rejected Quantity - Pay)) divided by (PO Accepted Quantity plus PO Rejected Quantity - Pay)