Scenario:
The user wants to remove a vendor from an item record.
Solution:
Here are the steps to do so: (You can try it on just 1 item first just to make sure it works for you before doing a massive CSV import)
- Create CSV file with the following columns:
- Internal ID
- Vendor
- Code
- Preferred
- Purchase Price
- Navigate to Setup > Import/Export > Import CSV Records
- Import Type = Item
- Record Type = Inventory Item (choose the appropriate item type)
- Click Select, then chose the file to import.
- Click Next.
- Set the Data Handling to Update.
- Click on Advanced Options and put a check mark on Overwrite Sublists.
- Note: If the Overwrite Sublist preference is selected, the Import Assistant will completely replace all existing data/sublist values in the item record and replaces them with the new sublist data on the CSV file.
3. Click Next.
4. Map the following fields:
Item Name = Item Name/Number
Vendor = Item Vendors 1: Vendor
Preferred = Item Vendors 1 : Preferred
Purchase Price = Item Vendors 1 : Purchase Price
Code = Item Vendors 1 : Code
5. Click on Next and then Save and Run.
Note: Please keep in mind that this CSV import uses the Overwrite Sublists option. This means all existing vendor records in the item will be completely replaced by the data in your CSV file. Ensure that this is your intended action before proceeding.
-----
If you find this information useful, let us know by reacting or commenting on this post!