Skip to main content
D
DTront
September 12, 2022
Solved

Organizing Item List with Multiple Vendors

  • September 12, 2022
  • 1 reply
  • 0 views

Using Quickbooks manufacturing edition and need advice on managing our item list. We are purchasing a vast variety of materials to create an end product. Sometimes the same material will be purchased from a different vendor. So Item A may be able to be bought from Vendor A, Vendor B, and Vendor C. Right now each item is listed individually, attached to a specific vendor, which is making our item list very cumbersome to sort through because there are a lot of duplicates. I would love to be able to list the item once and then select the specific vendor with specific vendor manufacturing number and vendor price.

Best answer by JenoP

Thanks for checking this out in the Community, DTront.

 

QuickBooks Enterprise or Manufacturing edition has a feature called Alter Vendors. This will allow you to assign multiple vendors to an item so you can easily compare and choose which vendor to purchase from at any given time.

 

First, turn on the Advanced Inventory feature to be able to see the option to use alternate vendors. Here's how:

 

  1. Go to the Edit menu and select Preferences.
  2.  Look for Items & Inventory in the left-hand panel, then go to the Company Preferences tab.
  3. Check the Inventory and Purchase Orders are Active box.
  4. Select the Advanced Inventory Settings button.
  5. Close and re-open the QuickBooks program.

 

Second, assign the item to an alternate vendor. Follow these steps on how to do it:

 

  1. Go to the Vendor Center and click the name of the vendor that you want to associate to an item.
  2. Proceed to the Items tab under the Vendor Information section.
  3. Click manage Vendor Items and select Add/Edit Vendor Items.
  4. Select Inventory under List, then select the item that you want to add in the Item Name column.
  5. Enter all the details you need including the manufacturer number and price.
  6. Choose Save Changes.

 

Finally, compare the prices and other vendor details when creating POs. Here's how: 

 

  1. Go back to the Vendors menu and select Create Purchase Orders.
  2. Select an inventory item, then click View Vendor Price.
  3. Choose to view the amount of the last purchase order or the price you imported from the vendor.
  4. Repeat step 3 if you’d like to see the total purchase order amount if you used a different vendor.

 

Additional details on how to use this feature are provided in this article: How to Use Alternate Vendors in QuickBooks Enterprise Solutions.

 

Feel free to post a reply and let me know if you're able to add other vendor details to your items. The Community is always here if you need anything else. 

1 reply

JenoP
JenoPAnswer
September 13, 2022

Thanks for checking this out in the Community, DTront.

 

QuickBooks Enterprise or Manufacturing edition has a feature called Alter Vendors. This will allow you to assign multiple vendors to an item so you can easily compare and choose which vendor to purchase from at any given time.

 

First, turn on the Advanced Inventory feature to be able to see the option to use alternate vendors. Here's how:

 

  1. Go to the Edit menu and select Preferences.
  2.  Look for Items & Inventory in the left-hand panel, then go to the Company Preferences tab.
  3. Check the Inventory and Purchase Orders are Active box.
  4. Select the Advanced Inventory Settings button.
  5. Close and re-open the QuickBooks program.

 

Second, assign the item to an alternate vendor. Follow these steps on how to do it:

 

  1. Go to the Vendor Center and click the name of the vendor that you want to associate to an item.
  2. Proceed to the Items tab under the Vendor Information section.
  3. Click manage Vendor Items and select Add/Edit Vendor Items.
  4. Select Inventory under List, then select the item that you want to add in the Item Name column.
  5. Enter all the details you need including the manufacturer number and price.
  6. Choose Save Changes.

 

Finally, compare the prices and other vendor details when creating POs. Here's how: 

 

  1. Go back to the Vendors menu and select Create Purchase Orders.
  2. Select an inventory item, then click View Vendor Price.
  3. Choose to view the amount of the last purchase order or the price you imported from the vendor.
  4. Repeat step 3 if you’d like to see the total purchase order amount if you used a different vendor.

 

Additional details on how to use this feature are provided in this article: How to Use Alternate Vendors in QuickBooks Enterprise Solutions.

 

Feel free to post a reply and let me know if you're able to add other vendor details to your items. The Community is always here if you need anything else. 

    Terms & ConditionsAccessibility statement