Data Selection

The process involved in this application uses records from your logged in company. You can use the PO header company ID to determine the selection.

Eligible PO Receipts

The application only includes receipts associated with PO lines from PO types of Purchase Order and Release Order, respectively.

Costpoint excludes the following as eligible receipts:

  • Receipts associated with PO types of Subcontract Retainage PO, GFM/GFE Order, Subcontractor Agreement, and Subcontractor Agreement Release
  • Receipts associated with PO lines that have material issues to it for subcontractor work
  • PO lines that have parts of type Buy with Components
  • Archived PO lines (If PO is archived, then variance will not pick it up for variance calculations)
Note: You need to perform variance calculations before performing an archive.

The application also selects receipt transactions with transaction date within the fiscal year, period, and subperiod and receipts with asset inventory abbreviations are part of the selection.

The Project WIP variance only applies to asset inventory abbreviation; Journal entries are not created for expense inventory abbreviation, and is excluded on the Create Purchase Price Variance Journal Entry (INPPPV) screen. However, this option is available in the report on the Print Purchase Price Variance Analysis Report (INRPPV) screen.

Note: PO line status is irrelevant in the selection process.

Eligible PO Vouchers

When comparing standard costs against voucher costs, Costpoint excludes PO lines that have no associated PO vouchers. For total match PO lines, Costpoint selects all (posted and unposted) vouchers that are within the selected fiscal year, period, and subperiod based on the voucher header FY/PD/SPD.

For individual match PO lines, Costpoint selects the voucher (posted or unposted) that matches the receipt based on the voucher receipt line.