Instead of individually inspecting each item, you can evaluate and maintain plural cost masters through this feature. The system prompts for a spectrum of criteria for the range of cost masters. The selected cost masters and summary information will be displayed on the screen where you can add, remove or drill down the records.
(Figure 29) Cost Master List Selection Screen
Name | Type and Description |
Starting Item No | 15 alphanumeric characters. Enter the starting item number for a range of cost masters to update. Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description. Defaults to All. |
Ending Item No | 15 alphanumeric characters. Enter the ending item number for a range of cost masters to update. Press the F7 Keyto search for an item by item number or press the F8 Key to search for an item by item description. Defaults to the starting item number. |
Starting Product Cat | 3 alphanumeric characters. Enter the starting product category for a range of cost masters to update. Press the F7 Key to search for an existing product category. Press the F1 Key to select items that have no product category only. Defaults to All. |
Ending Product Cat | 3 alphanumeric characters. Enter the ending product category for a range of cost masters to update. Press the F7 Key to search for an existing product category. Press the F1 Key to select items that have no product category only. Defaults to the starting product category. |
Buyer Code | 2 alphanumeric characters. Enter the buyer/analyst code for a range of cost masters to update. Press the F7 Key to search for an existing product category. Press the F1 Key to select items that have no buyer code only. Defaults to All. |
Material Cost Type | 2 alphanumeric characters. Enter the material cost type for a range of cost masters to update. Press the F7 Key to search for an existing material cost type. Press the F1 Key to select items that have no material cost type only. Defaults to All. |
Manufacture or Purchase | 1 alphanumeric character. Valid entries are: M – Manufactured items only P – Purchased items only B – Both Defaults to B. |
Select Obsolete Cost Master? | Y or N. Enter Y to include obsolete items. Defaults to N. |
Select by Total Cost Variance | 1 alphanumeric character, followed by a two digit percentage amount. Valid entries are: N – No selection for total cost variance. O – Select records with a positive total cost variance falling within the specified range. U – Select records with a negative total cost variance falling within the specified range. B – Select records with an absolute value of total cost variance falling within the specified range. Enter the method to select records by total cost variance. If you select O, U or B, you need to enter the range of the variance to include. Defaults to N. |
Select by V/A Cost Variance | 1 alphanumeric character, followed by a two digit percentage amount. Valid entries are: N – No selection for total cost variance. O – Select records with a positive value added cost variance falling within the specified range. U – Select records with a negative value added cost variance falling within the specified range B – Select records with an absolute value of value added cost variance falling within the specified range. Enter the method to select records by value added cost variance. If you select O, U or B, you need to enter the range of the variance to include. Defaults to N. |
(Figure 30) Cost Master List Screen
This screen displays a list of selected items and their cost master information. You can review the cost and the cost variance from the last update. You can add or remove a cost master. You can also drill down on an item for more detail.
Several functions are available in this screen: