Solved

Alternate Vendor Item Tab

Forum|Forum|5 years ago
August 13, 2020
1 reply
0 views

I recently updated to 2020 QuickBooks Enterprise Wholesale & Manufacturing from the 2018 version and there is the new "Alternate Vendor Items" Tab. So my question is if you update the "cost" of an item in "Item Edit" why does that not reflect the "cost" in the Vendor Item Tab? Is there no way to push that information over?

This same question goes for if you update the "description" or "item name"?

If this is true do you literally have to export your items by vendor and re import them back in to the Vendor Items tab?

QuickBooks Desktop

Best answer by KlentB

@mv32

I totally understand what you are saying but if the "cost" in inventory center doesn't reflect to the Vendor Item List tab you can't really compare on a purchase order, correct?

So for example lets say item "x" had a price of $1.00 in the "Vendor Item" tab and in Inventory Item List/Center which is the amount that shows on the compare on a Purchase Order but then the price in the Item List/Item Center is $1.25 because there was a price increase and the accurate price is $1.25. By this example you would have to manually update the price in 2 locations (Vendor Item Tab & Item List/Center).

Am I missing something?

I'm here to clear things out for you, MickeyK.

You're right with your example. When we modify an item in the Inventory Center, the changes on the cost won't be applied to the Alternate Vendor Item tab. Only the changes on the item name will reflect to your alternate vendors.

Please know that the main purpose of the alternate vendor is to match your vendors' items with your inventory. This way, you can easily compare their prices and choose which vendor to purchase from at any given time.

If the price of that particular item changes, we'll have to manually update the cost of the item in the Item List tab/Inventory Center and Alternate Vendor Item tab.

Feel free to read this article to learn how to compare alternate vendors in the program.

With QuickBooks Enterprise, you can also track inventory stored at different sites or locations.

Do you have any other questions in mind? Feel free to leave them below and I'll get back to you as soon as possible.

Angelyn_T

Happy to have you here on the Community page, @MickeyK.

I'm here to share some information about the items added from the Item List and the alternative vendors in QuickBooks Desktop Enterprise.

When updating the items from the Item List, the changes are only applicable if you're about to create a transaction or for the incoming entries that you'll be creating. The update won't take effect on those transactions created before changing the cost or item name.

To learn more about this feature, check out this link: How to use alternate vendors in QuickBooks Enterprise Solutions.

Also, read the topics from this article for additional guides about managing your item list, vendors, and QuickBooks in the future.

I'm always here to help if you have any other questions. Just add a comment below. Keep safe, @MickeyK!

MickeyKAuthor

@Angelyn_T Maybe I didn't clarify but I am referring to if "cost" changes and that is entered into "Inventory Center" > "Item Edit" it does not reflect on the Vendors Item Tab under vendors. So in our industry we get new pricing from each vendor so we have to import those prices in every January. So we would have to do more work to get pricing to reflect under "Vendor Items Tab".

But then this also goes for if you are creating a Purchase Order and click on the "compare vendors" it only shows the price that was imported on the Vendors Item tab and not the "Cost" in the Inventory Center > Item Edit". Make sense?

M

mv32

Thanks for your prompt response, @MickeyK.

The Vendor Item Tab's purpose is to allow you to use multiple vendors, depending on pricing and availability. It is why the cost isn't present in the Vendor Item Tab when you edit the item in the Inventory Center or List of Items.

Once set up for Vendor Item List is done, you'll visit the main item Lists to designate the primary and alternate vendor.

The purpose of this new feature is to compare the vendor prices for the related items when you create Purchase Orders. That's why the cost isn't showing in the Purchase Order when using the compare vendor's function.

For more details, you can check this video article to learn more about this feature: How to use alternate vendors in QuickBooks Enterprise.

I've added this page as your reference in handling your inventory, products, and services in QuickBooks: Manage inventory.

You know you can always share your progress here if you need more assistance. I'll be around to help. Take care!

Sign up

Login with SSO

Login to the community

Login with SSO