Menu Path: Purchasing Inquiries Inventory Purchase Cost Matrix Inquiry
View purchase cost matrix records.
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.
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Select this check box to display purchase order cost matrix information for all suppliers. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display purchase order cost matrix information for all cost regions. This check box is selected by default. |
|
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. |
|
This field displays the country associated with the cost region entered in the Cost Region field. |
|
Click the Lookup button to select the primary method for sorting purchase order cost matrix information. |
|
Click the Lookup button to select a secondary method for sorting purchase order cost matrix information. |
|
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. |
|
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. |
|
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. |
|
Select a specific cost matrix type (Product or Cost Class). |
|
Select one of the following options:
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.
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.
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. |
Field or Button |
Description |
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. |