Dynamics Community Forum Thread Details

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

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

Each product can have multiple brands
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!

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.

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

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

Quick Links