If you’re working with multiple vendors, keeping track of things like pricing or lead times can be tricky. Depending on the vendors you use, these can also vary between them.

Alternate Vendors available in QuickBooks Desktop Enterprise 2020 with a Platinum Subscription.

How To Access It

From the menu bar, select Vendor Center and click the Items tab to view items assigned to the selected vendor record as a Preferred or Alternate vendor. When creating a purchase order, select the View Vendor Price button on the top right to view vendor specific pricing and other details.

Feature benefits: Centralized information tab in the Vendor Center will list inventory items that were purchased from the selected vendor or where the selected vendor is assigned as a Preferred or Alternate vendor for that inventory item. Use the provided vendor-specific pricing details and past purchasing history to help make more informed purchasing decisions.

Quickbooks Alternate Venders Example Image 1

Listed under the Items tab for the selected QuickBooks vendor are items purchased from that vendor in the last twelve months.

Manage the individual vendors assigned to an item from the Manage button on the Item record.

Quickbooks Alternate Venders Example Image 2

Adding Alternate Vendor information manually in each inventory record would be time consuming. One method for efficiently adding this information would start with an export of the inventory items in QuickBooks to Excel. You can complete this by creating a report of your inventory items and exporting them to Excel, or from the menu bar select, Lists -> Item List and from the Excel drop-down menu at the bottom of the list, select Export All Items. You would then take the Excel spreadsheet details and add the Alternate Vendor information you wish to track.

Alternate Vendor details tracked by Enterprise include:

  • Added by QuickBooks automatically: Last Price, Last Qty, Last Order and Import Date (when information was imported)
  • Users can then add: Price (vendor-specific), Lead Time, Vendor PN (part number) and Notes

After updating the Excel spreadsheet you created to include information tracked for Alternate Vendors, you can efficiently copy and paste this information in the Lists ? Add/Edit Multiple List Entries and, from the List drop-down menu, select Vendor Items.

Quickbooks Alternate Venders Example Image 3

From a displayed purchase order in QuickBooks, click on View Vendor Price to view pricing details from other Preferred or Alternate Vendors.

Quickbooks Alternate Venders Example Image 4

Optionally, click the small icon (new) next to the selected item’s rate to view the Preferred and Alternate Vendor’s part pricing details.

Quickbooks Alternate Venders Example Image 5

Quickbooks Alternate Venders Example Image 6

Kemper has QuickBooks ProAdvisors in your area ready to help! Contact us today to learn more about the improvements to QuickBooks Desktop 2020

Quickbooks ProAdvisors Badges