QuickBooks HelpQuickBooksHelpIntuit

Use alternate vendors in QuickBooks Enterprise Solutions

by Intuit•1• Updated 3 months ago

Learn how to use alternate vendors in QuickBooks Enterprise Solutions 20.0.

If you work with multiple vendors, it's important to keep track of prices and lead times. You can use alternate vendors to match vendor items with inventory, and compare and choose vendors with ease.

Important: To use alternate vendors, you’ll need to turn on Advanced Inventory for QuickBooks Enterprise Solutions (QBES).

The vendor item list shows all inventory and non-inventory purchases from vendors in the last 12 months in just a few steps. It includes the price, date, and quantity of each purchase.

  1. Go to Vendors, then select Vendor Center.
  2. Select the vendor from the Vendors tab.
  3. Select the Items tab.

If you’re working with a new vendor, you can import their price list. It includes ‌item pricing, lead time, unit of measure, and part numbers.

  1. Go to Vendors, then select Vendor Center.
  2. Select the Items tab, then select the Excel icon.
  3. From the Excel ▼dropdown menu, select Import from Excel….

You can add or change the vendor item list in the Add/Edit Multiple List Entries manually, or you can paste it from Excel.

  1. Go to Vendors, then select Vendor Center.
  2. Select the Items tab, then select Manage Vendor Items.
  3. Select Add/edit vendor items to open the Vendor Items list in the Add/Edit Multiple List Entries window.

Tip: You can also conveniently map ITEM NAME and VENDOR TYPE with a dropdown.

You can select a preferred vendor and up to 4 alternate vendors for each item in your inventory. The preferred and alternate vendors for each item also show when you make a purchase order.

  1. Go to Lists, then select Item list.
  2. Select an inventory item, then select Edit item. You can also select Edit Item from the Item â–Ľdropdown.
  3. Assign preferred and alternate vendors:
    • To assign preferred vendors, select options from the Preferred Vendor â–Ľdropdown. 
    • To assign alternate vendors:
      1. Select Manage next to Alternate Vendor. 
      2. In the Manage alternate vendors window, select Alternate from the Status ▼dropdown next to your preferred alternate vendor. 
      3. Select Save & Close.

Tip: You can also simplify this setup process using Add/Edit Multiple List Entries.

You can select a preferred vendor and up to 4 alternate vendors for each item in your inventory. The preferred and alternate vendors for each item also show when you make a purchase order.

You can compare alternate vendors with your preferred vendor with ease when you purchase inventory. Here’s how:

  1. Create a purchase order and add at least 2 items.
  2. Find the purchase order you created, then select an inventory item.
  3. In the RATE column, select the Compare vendors icon. This shows your vendor price lists and all vendors you’ve purchased from in the last 12 months.
  4. In the Create Purchase Orders window, select a vendor from the VENDOR â–Ľdropdown. Then, select View Vendor Price.

Tips:

  • You can view the LAST PRICE from your last purchase order and the PRICE you imported from the vendor. 
  • If you’d like to see the total purchase order amount for a different vendor, select the Compare vendors icon again.

Use this info to select the best vendor for your items and update your purchase order.

If you have enabled barcodes, you can add the item's barcode in the purchase order.

Note: Before you select Save & Close, follow these steps:

  1. From the Create Purchase Orders window, select Formatting. Then, select Customize Data Layout.
  2. Select the Columns tab, then select the boxes for Screen/Print for your display preferences.
  3. Select OK.
QuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise Platinum