IC16.1 - Mass Copy by Location Use this form to set up mass copy and update requests using these forms: Mass Copy By Location (IC16.1), Mass Copy By Item (IC16.2), Mass Change (IC16.3), and Change by Item or Vendor. Mass copy and update requests are set up by company, request number, and effective date. Requests are processed by the same criteria in IC116 (Item Mass Update). Only requests with an effective date less than or equal to the date specified in IC116 (Item Mass Update) are processed. Important: Before you set up mass copy requests in IC16.1 (Mass Copy by Location) or IC16.2 (Mass Copy by Item), the locations involved in the copy process must share the same general ledger category(s). Otherwise, item records will not be copied. General ledger categories are set up by location in IC04.1 (General Ledger Category). Use IC16.1 (Mass Copy by Location) to mass copy items from an existing location (location A) to a new location (location B). This form also allows you to change values for the following fields at location B: Buyer Code, Automatic Purchasing, Allow Issues, Preferred Bin, Replenishment Location, and Replenishment Bin. If any of these fields are left blank, values defined for location A are copied to location B. Updated Files ICMASSUPD - Primary file maintained by program. Referenced Files ICBIN - Used to validate the existence of a bin. ICCOMPANY - Used to validate the existence of a company number. ICLOCATION - Used to validate the existence of a location. ITEMLOC - Used to validate the existence of an item at a location. IC16.2 - Mass Copy by Item Use this form to mass copy a new item to every location that stocks items for the same product line. Before you use this form, set up the new item in IC12.1 (Item Location) or IC10.2 (Item Master and Location). Then, using this form, enter the location where the item is set up as Location A, the new item as Item A and an existing item from the same product line as Item B. This form uses Item B to find and copy the new item to other locations that stock items for the same product line. This form also lets you indicate from which item record (A or B) to retrieve values for the following fields: Primary Vendor, Buyer, Forecast Number, Average Leadtime, Leadtime-Control, Automatic Purchasing, Movement Class, and Preferred Bin. For example, if you assign a different buyer to each location, enter the value B to update each item location record with the same buyer assigned to Item B at each location. Mass copy requests are set up by company, request number, and effective date. Requests are actually processed by the same criteria in IC116 (Item Mass Update). Only requests with an effective date less than or equal to the date specified in IC116 are processed. Important: Before you can set up mass copy requests in IC16.2, the locations involved in the mass copy must share the same general ledger category(s). Otherwise, item records will not be copied. General ledger categories are set up by location in IC04.1 (General Ledger Category). Updated Files ICMASSUPD - Primary file maintained by program. Referenced Files ICCATEGORY - Used to retrieve account information. ICCOMPANY - Used to validate the existence of a company number. ITEMLOC - Used to validate the existence of an item at a location. IC16.3 - Mass Change Use this form to mass change certain field values for a selected range of items. You can choose the items for change by location, sales class, inventory class and/or purchasing class. If you don't specify a location or class, all locations and classes are affected. You can change the following fields: Issues Allowed, Receipts Allowed, Automatic Purchasing, Bin Tracking, Future Standard Cost Percent, and Buyer. If you change the buyer code you can change all items selected in the change request or only those items currently set up with a specific value. Mass change requests are set up by company, request number, and effective date. Requests are actually processed by the same criteria in IC116 (Item Mass Update). Only requests with an effective date less than or equal to the effective date specified in IC116 are processed. Updated Files ICMASSUPD - Primary file maintained by program. Referenced Files ICCOMPANY - Used to validate the existence of a company number. ICLOCATION - Used to validate the existence of a location. MAJORCL - Used to validate item major classes. MINORCL - Used to validate item minor classes. IC16.4 - Change by Item or Vendor Use this form to mass change field values for one or more locations, for a selected item, or all items assigned to a selected primary vendor. If you do not enter a location, this form affects all locations. If you choose field values to change for an item, only that item is affected. If you choose a primary vendor for change, all items assigned to that vendor are affected. You can change the following fields: Buyer, Leadtime Control, Primary Vendor, Average Leadtime, Allow Issues, Allow Receipts, Automatic Purchasing, and Future Standard Cost. If you change the Buyer Code, Leadtime Control or Primary Vendor, you can change all items or only those items currently set up with a specific value. Also, you can change the Future Standard Cost value by an amount or adjust it by a percentage. Mass change requests are set up by company, request number, and effective date. Requests are processed by the same criteria in IC116 (Item Mass Update). Only requests with an effective date less than or equal to the effective date specified in IC116 are processed. Updated Files ICMASSUPD - Primary file maintained by program. Referenced Files APCOMPANY - Used in an Accounts Payable common routine. APCPYVND - The Vendor Company Codes file contains default codes assigned a vendor or alternate vendor location at the company level. APHLDINV - The Hold file contains records of vendors, invoices, and payments that are on hold. APVENCLASS - Used in an Accounts Payable common routine. APVENGROUP - Used in an Accounts Payable common routine. APVENMAST - Used in an Accounts Payable common routine. ICCOMPANY - Used to validate the existence of a company number. ICLOCATION - Used to validate the existence of a location. ITEMGROUP - Used to validate the item group. ITEMLOC - Used to validate the existence of an item at a location. ITEMMAST - Used to validate the existence of an item master record. |