Purchase Cost Matrix Inquiry

Menu Path: Purchasing Images\bluerarw.gif Inquiries Images\bluerarw.gif Inventory Images\bluerarw.gif Purchase Cost Matrix Inquiry

Purpose

View purchase cost matrix records.

Overview

Use Purchase Cost Matrix Inquiry to display and manage purchase order cost matrix information. For information on setting up cost matrixes, see Purchase Cost Matrix Maintenance.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Purchase Cost Matrix Inquiry window.

Show Data

Click this button to display purchase order cost matrix data on the Results tab, based on the selected criteria.

Select Tab Fields and Buttons

Field or Button

Description

All (Products)

Select this check box to display purchase order cost matrix information for all products. This check box is selected by default, and is only available if you select the Product radio button.

Product Code

Enter a product code for which to display purchase order cost matrix information, or click the Lookup button to select a product code. This field is only enabled if you clear the All check box, and is only available if you select the Product radio button.

Name (Product)

Enter a product name for which to display purchase order cost matrix information, or click the Lookup button to select a product name. This field is only enabled if you clear the All check box, and is only available if you select the Product radio button.

All (Cost Classes)

Select this check box to display purchase order cost matrix information for all cost classes. This check box is selected by default, and is only available if you select the Cost Class radio button.

Cost Class

Enter a cost class ID for which to display purchase order cost matrix information, or click the Lookup button to select a cost class. This field is only enabled if you clear the All check box.

All (Suppliers)

Select this check box to display purchase order cost matrix information for all suppliers. This check box is selected by default.

Supplier Code

Enter a supplier code for which to display purchase order cost matrix information, or click the Lookup button to select a supplier code. This field is only enabled if you clear the All check box.

Name (Supplier)

Enter a supplier name for which to display purchase order cost matrix information, or click the Lookup button to select a supplier name. This field is only enabled if you clear the All check box.

All (Cost Regions)

Select this check box to display purchase order cost matrix information for all cost regions. This check box is selected by default.

Cost Region

Enter a cost region for which to display purchase order cost matrix information, or click the Lookup button to select a cost region. This field is only enabled if you clear the All check box.

Country

This field displays the country associated with the cost region entered in the Cost Region field.

Primary Sort

Click the Lookup button to select the primary method for sorting purchase order cost matrix information.

Secondary Sort

Click the Lookup button to select a secondary method for sorting purchase order cost matrix information.

As Of

Select an effective date for which to display purchase order cost matrix information, or click the drop-down arrow to select a date. This field is only available if you select the Active or Expired radio buttons. This field defaults to today's date.

From

Enter the first date in a range of expiration dates for which to display purchase order cost matrix information, or click the drop-down arrow to select a date. This field is only available if you select the Future Expired radio button. This field defaults to tomorrow's date.

To

Enter the last date in a range of expiration dates for which to display purchase order cost matrix information, or click the drop-down arrow to select a date. This field is only available if you select the Future Expired radio button. This field defaults to 12/31/2999.

Cost Matrix Option

Select a specific cost matrix type (Product or Cost Class).

Cost Effective Dates

Select one of the following options:

  • Active - Display cost matrix records where the date entered in the As Of field is between the cost matrix start and end date. When this option is selected, enter a date in the As Of field.

Example If 12/1/2019 is entered in the As Of field, then a cost matrix record with a start date of 01/01/2019 and an end date of 12/31/2019 is displayed. A cost matrix record with a start date of 01/01/2020 and an end date of 06/30/2020 is not displayed.

  • Expired - Display expired cost matrix records where the date entered in the As Of field is after the cost matrix end date. When this option is selected, enter a date in the As Of field.

Example If 12/1/2019 is entered in the As Of field, then a cost matrix record with a start date of 01/01/2019 and an end date of 10/31/2019 is displayed. A cost matrix record with a start date of 01/01/2019 and an end date of 06/30/2020 is not displayed.

  • All - Display all cost matrix records regardless of the start and end dates.

  • Future Expired - Display cost matrix records where the cost matrix end date is between the dates entered in the From and To fields. When this option is selected, enter an expiration date range in the From and To fields.

Example If 12/31/2019 is entered in the From field and 12/31/2020 is entered in the To field, then a cost matrix record with an end date of 10/31/2020 is displayed. A cost matrix record with an end date of 06/30/2021 is not displayed.

Results Tab Fields and Buttons

Field or Button

Description

Results

This grid displays cost matrix information based on the criteria selected on the Select tab. Double-click a record to display Purchase Cost Matrix Maintenance, which allows you to view and edit the cost matrix for a supplier and product.