Use the fields and options to configure the Recompute and Print Discrepancies 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
Use the options in this group box to select the basis for recomputing and/or printing.
Field | Description |
(Compute By)
|
From the drop-down list, select the basis for recomputing and/or printing:
- PO: Select this setting to recompute/print by purchase order. If you select this setting, data available in the lookup originates from the Manage Purchase Orders screen.
- Voucher: Select this setting to recompute/print by voucher. If you select this setting, data available in the lookup originates from the Manage Purchase Order Vouchers screen.
- Vendor ID: Select this setting to recompute/print by vendor ID. If you select this setting, data available in the lookup originates from the Manage Vendor screen.
- Vendor Name: Select this setting to recompute/print by vendor name. If you select this setting, data available in the lookup originates from the Manage Vendors screen.
|
Option
|
Use this drop-down list to select the range of values to be included. Valid options are:
- All: Select this option to include all available values. The
Start and
End fields are disabled for this option. This is the default.
- One: Select this option to include only one value and then enter that value in the
Start field. The
End field is disabled for this option.
- Range: Select this option to include a contiguous range of values. Enter the beginning value for the range in the
Start field and enter the ending value of the range in the
End field.
- From Beginning: Select this option to include a range of values that begins with the first of all the available values and ends with the value that you enter in the
End field. The
Start field is disabled for this option.
- To End: Select this option to include a range of values that begins with the specific value that you enter in the
Start field and ends with the last of all the available values. The
End field is disabled for this option.
|
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.
Note: 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.
Field | Description |
Option
|
Use this drop-down list to select the range of user IDs to be included. Valid options are:
- All: Select this option to include all available user IDs. The
Start and
End fields are disabled for this option. This is the default.
- One: Select this option to include only one user ID and then enter that user ID in the
Start field. The
End field is disabled for this option.
- Range: Select this option to include a contiguous range of user IDs. Enter the beginning user ID for the range in the
Start field and enter the ending user ID of the range in the
End field.
- From Beginning: Select this option to include a range of user IDs that begins with the first of all the available user IDs and ends with the user ID that you enter in the
End field. The
Start field is disabled for this option.
- To End: Select this option to include a range of user IDs that begins with the specific user ID that you enter in the
Start field and ends with the last of all the available user IDs. The
End field is disabled for this option.
|
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.
Note: 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
Field | Description |
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:
- All PO Vouchers: Select this setting to include all processed purchase order vouchers.
- PO Vouchers with Discrepancies: Select this setting to include only those purchase order vouchers that have a discrepancy. The discrepancies can be over or under the current amounts as specified in the
Discrepancies Allowed group box on the Configure Purchase Order Voucher Settings screen.
- PO Vouchers with Discrepancies Over User Thresholds: Select this setting to include only those purchase order vouchers that have a discrepancy greater than one of the amounts specified in the
Discrepancies Allowed group box on the Configure Purchase Order Voucher Settings screen.
|
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:
- Unit Price Discrepancy Amount: Invoice Unit Price minus
PO Unit Price
- Unit Price Discrepancy Percent: (Invoice Unit Price minus
PO Unit Price) divided by
PO Unit Price
- Total Discrepancy Line Amount: This calculation depends on the type of matching for the voucher line.
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
- Quantity Discrepancy Percent
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)
|