Added to NDS Applications, version 7.5.2
Program VEMC, Item Mass Change Capabilities, is used to change item master information, item planning information, and vendor item information for selected items.
* Item master information is entered in program ICMM, Inventory Master Maintenance.
* Item planning information is entered in program ICPM, Inventory Planning Data Maintenance. Vendor information is entered in program VEQM, Vendor Quote Maintenance.
* When a plant record exists in on the Plant Tab in program ICPM, Inventory Planning Data Maintenance, for the plant that you are logged into, this program will update the plant record.
* If no plant record exists in on the Plant Tab in program ICPM, Inventory Planning Data Maintenance, the enterprise record will be updated on the Default ME Tab in program ICPM, Inventory Planning Data Maintenance.
If you enter selection information in the Purch UM field or the Vendor Lead time field, only items with vendor item records in program VEQM, Vendor Quote Maintenance, will be selected to have changes applied. Changes will be made to the item planning record for the items selected, if those changes are entered.
When the information displayed in the lower block is from the item planning record, the words Item Planning will be displayed in blue in the upper right corner of the Main Tab.
When the information displayed in the lower block is from the vendor item record, the words Vendor Item will be displayed in blue in the upper right corner of the Main Tab.
Selecting Items for Mass Change
1. The program can only have one record at a time. The existing record is queried upon entering the program. You can either modify the existing record or press the [Clear Selection] button to start with a new record.
2. In the Selection Criteria section, enter the values for which items will be selected.
3. If you are modifying a range of items only, enter the first item in the range in the From Item No field.
4. If you are modifying a range of items only, enter the last item in the range in the To Item No field.
* If you leave these fields blank, all items will be considered for selection.
5. In the Prod Group field, enter the product group by which items will be selected.
6. In the Ctry of Origin field, enter the country code for the country of origin by which items will be selected.
7. In the Master Planner field, enter the master planner code by which items will be selected.
8. In the Planner field, enter the planner code by which items will be selected.
9. In the Order Policy field, enter the order policy by which items will be selected.
10. In the Order Code field, enter the order code by which items will be selected.
11. In the Mfg Method pop-list, select the manufacturing method by which items will be selected.
12. In the Buyer Code field, enter the buyer code by which items will be selected.
13. In the Preferred Vendor field, enter the preferred vendor by which items will be selected.
14. In the Statistical Fcast pop-list, select the statistical forecast setting by which items will be selected.
15. In the Forecast Group field, enter the forecast group by which items will be selected.
16. In the Make or Buy pop-list, select the setting by which items will be selected.
17. In the Item Price Group field, enter the item price group by which items will be selected.
18. In the Fcast Alpha field, select the forecast alpha setting by which items will be selected.
19. In the Fcast Base field, select the forecast base setting by which items will be selected.
20. In the Purch UM field, enter the purchase unit of measure by which items will be selected.
21. In the Stock UM field, enter the stock unit of measure by which items will be selected.
22. In the Safety Stock field, enter the safety stock value by which items will be selected.
23. In the Alt Curr Cd field, enter the vendor's alternate currency code by which items will be selected.
* If you make an entry in this field, only items with a vendor item record for this alternate currency code will be selected.
24. In the Vendor Lead Time field, enter the vendor delivery lead time by which items will be selected.
* If you make an entry in this field, only items with a vendor item record for this vendor lead time will be selected.
25. In the Lead Time1 field, enter the lead time by which items will be selected. This field refers to the first Lead Time field in program ICPM, Inventory Planning Data Maintenance.
26. Press the [Make Selection] button to select the items that meet the entered criteria.
27. The program will display an alert box telling you how many records meet the selected criteria. These records can be viewed on the Results Tab.
* The status of the selection, the number of items selected, and the table to be updated are displayed in the upper right corner of the screen.
* For example:
Set New Values For Selected Items
## Items Selected
Item Planning
28. In the New Values for Selected Records section, enter the values that you are changing for the selected items.
29. In the Prod Group field, enter the new product group to be applied to the selected items.
30. In the Ctry of Origin field, enter the new country code for the country of origin to be applied to the selected items.
31. In the Master Planner field, enter the new master planner code to be applied to the selected items.
32. In the Planner field, enter the new planner code to be applied to the selected items.
33. In the Order Policy field, enter the new order policy to be applied to the selected items.
34. In the Order Code field, enter the new order code to be applied to the selected items.
35. In the Mfg Method field, enter the new manufacturing method to be applied to the selected items.
36. In the Buyer Code field, enter the new buyer code to be applied to the selected items.
37. In the Preferred Vendor field, enter the new preferred vendor to be applied to the selected items.
38. In the Statistical Fcast pop-list, select the statistical forecast setting to be applied to the selected items.
39. In the Forecast Group field, enter the new forecast group to be applied to the selected items.
40. In the Make or Buy pop-list, select the new setting to be applied to the selected items.
41. In the Item Price Group field, enter the new item price group to be applied to the selected items.
42. In the Fcast Alpha pop-list, select the new forecast alpha setting to be applied to the selected items.
43. In the Fcast Base pop-list, select the new forecast base setting to be applied to the selected items.
44 In the Purch UM field, enter the new purchase unit of measure to be applied to the selected items.
45. In the Stock UM field, enter the new stock unit of measure to be applied to the selected items.
46. In the Safety Factor field, enter the new safety factor to be applied to the selected items.
47. In the Alt Curr Cd field, enter the new alternate currency code to be applied to the selected items.
* If you make an entry in this field, any vendor item record for this item will be updated with this alternate currency code.
48. In the Vendor Lead Time fields, you have two choices. You can enter a new vendor lead time to replace the existing vendor lead times for the existing records, or you can add to the existing vendor lead times for the records.
* In the New field, enter the delivery lead time that you wish to assign to the item/vendor record in program VEQM, Vendor Quote Maintenance. When the mass change occurs, this delivery lead time will replace the current delivery lead time for the item.
* In the Add field, enter the number of days that you wish to add to the vendor's delivery lead time for the item in program VEQM, Vendor Quote Maintenance. This is the field to use if you are adding to an existing lead time for the item.
For example, if all items needed to have 2 days added to their current delivery lead time, you would enter 2 in this field, and when the mass change occurred, 2 would be added to each item's existing delivery lead time. An item with 3 as the lead time would have 5, an item with 2 as the lead time would have 4, and so on.
49. In the Lead Time1 fields, you have two choices. You can enter a new lead time to replace the existing lead time 1 for the items in the item planning records, or you can add to the existing lead time 1 for the items in the item planning records.
* In the New field, enter the lead time that you wish to assign to the item record in program ICPM, Inventory Planning Data Maintenance. When the mass change occurs, this lead time will replace the current existing lead time for the item.
* In the Add field, enter the number of days that you wish to add to the lead time for the item in program ICPM, Inventory Planning Data Maintenance. This is the field to use if you are adding to an existing lead time for the item.
For example, if all items needed to have 2 days added to their current lead time, you would enter 2 in this field, and when the mass change occurred, 2 would be added to each item's existing lead time. An item with 3 as the lead time would have 5, an item with 2 as the lead time would have 4, and so on.
50. Press the [Set Changes] button to enter the changes on the Results Tab for the items that were selected previously.
51. The program will display an alert box telling you that the changes have been entered. Go to the Results Tab and press F8 to view the changes.
* If an item is selected that you do not wish to change, you can un-select it by clicking in the Item field for the item and pressing [Delete Record].
* You can change any of the New values for any of the selected items.
52. When all desired changes have been made, press the [Apply Changes] button on the Main Tab to perform the changes.
* The status of the selection, the number of items selected, and the table to be updated are displayed in the upper right corner of the screen.
* For example:
Mass Changes Applied
## Items Selected
Item Planning
Press this button to make the entered changes to the selected items on the Results Tab.
Press this button to clear the current selection and start with a new record.
Press this button to select items according to the entered parameters in the Selection Criteria section.
Press this button to enter the new values in the New fields on the Results Tab for the selected items.