Work Order Plus Advanced Feature Manual 5
Maintenance by List of Cost Masters
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.
Selection Screen
(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. |
List Screen
(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:
- Up/Down/Page Up/Page Down Key – Navigate the highlight bar among different items.
- Enter Key – Drill down to Cost Master Maintenance.
- Insert Key – Add a new Cost Master. The highlight bar will be moved to the end of the list and you are required to enter an item number.
- Delete Key – Delete a Cost Master.
- F2 Key – Drill down to Cost Audit Inquiry for the highlighted item.
- F3 Key – Drill down to Routing Inquiry for the default routing of the highlighted item. This inquiry program will display the operations and, if allowed, the cost of the routing. The program will use the current total cost from cost master to calculate material cost.
- F4 Key – Drill down to Stock Inquiry for the highlighted item.
- F5 Key – Legend.
Inquiry
Cost Audit Inquiry
Every time the system updates the unit cost of an item from a cost master (through Current to Standard Roll), an audit record will be created. The audit records the cost value before and after the update so you can review them later. The Cost Audit Inquiry program provides an interface to review the audit history of one item. It will list all audit records and allow you to drill down for more detail.
(Figure 31) Cost Audit Inquiry, Item Number Entry
If you bring up Cost Audit Inquiry from the Cost Master Main Menu, the system will prompt for an item number first. Otherwise, the program will directly display the audit history.
(Figure 32) Cost Audit Inquiry, Audit History
After an item number is given, the screen will display all audit records of the item. Each line shows the new value, the old value and the value variance in cost for one update. You can press the Enter key to drill down for more detail of one audit record. In the detail screen, you can use the F1 key to toggle between the main screen, which shows both total value and value added amount, and the Percentage of Total screen, which shows the percentage of one type amount to total amount.
(Figure 33) Cost Audit Inquiry, One Audit Record – Main Screen
(Figure 34) Cost Audit Inquiry, One Audit Record – Percentage Screen