Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

Managing Product, Brand, Vendor and Prices for Warehouse and Inventory Management

Posted on by 60

In one of the implementation, we need to handle one scenario like we have generic products:

  1. Each product can have multiple brands
  2. Each product can be purchased from multiple vendors at different price and for multiple brands.

So, 1 brand can be available with multiple vendors and each vendor can sell multiple brands.

One example: Let’s say, we have Mouse as one of our product which is now short in our inventory. So, Mouse can be of any brand like Dell, HP, iball, etc. now, the price for the Mouse from any of these brands can vary based on the vendor from whom we are going to buy. So, may be the same Mouse with same spec is offered by vendor 1 at $60. While the same product is offered by vendor 2 at $55.

 So, how can we maintain product, brand, vendor and price together in the system and handle the inventory, warehouse and Purchase Ordering.

Any suggestions would be highly appreciated.

Thanks in advance!

  • Suggested answer
    RE: Managing Product, Brand, Vendor and Prices for Warehouse and Inventory Management

    Hi Kirti. Few thoughts.

    1. Generally, a product is something that comes off a production line and has a unique UPC code. Meaning, a Dell mouse model 123 would be one product, and a Microsoft mouse would be another product.

    2. For the dell mouse, as you mentioned, you may purchase from vendor 1 or 2. When you create a purchase order you can enter the price/cost the vendor quoted you, and it gets finalized when you create the PO bill (vendor invoice) where you have another chance to update the price.

    3. Each product has two fields, standard cost and current cost.

    2020_2D00_05_2D00_15_5F00_10_2D00_42_2D00_47.png

    4. When you create a purchase order and add a purchase order product, the price for that product defaults from one of these two fields based on your setting under field service settings

    2020_2D00_05_2D00_15_5F00_10_2D00_41_2D00_00.png

    5. You can change the price for the PO at this point, or wait until you receive the products and get the vendor bill when you create a PO receipt product. You can create the receipt product when you get the product from the vendor but can update pricing when you get the vendor bill.

    6. When you create PO bills I believe it should update the product current cost but I don't see that working so I'll check if something is broken or if I am misremembering. 

    7. You can link PO's to warehouses which updates inventory, if you track inventory on that product, or link directly to a work order which will show up on that work order. If you link it directly to a work order, the cost on the work order product comes from the actual cost on the PO.

    8. If you receive it to a warehouse, and then add it to a work order, the default cost comes based on the field service setting mentioned in step 4.

    Hopefully this helps. Here is a link to documentation on this area - https://docs.microsoft.com/en-us/dynamics365/field-service/inventory-purchasing-returns-overview

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans