Skip to Content
Menu
This question has been flagged
4 Replies
6675 Views

For example:

In AssemblyA there is screwA.

ScrewA is sold in:
packs of 25 for $10
packs of 50 for $18

If we have 0 inventory and want to build 25 assemblies or less then it would be best to purchase with a UOM of 25

But if we want to build 25 or more assemblies it would be best to purchase with a UOM of 50

The product form only allows for 1 type of purchase UOM. 

Any suggestions would be great!

Thanks



Avatar
Discard
Author

Thank you for your reply. I have attached a couple of pictures of what I am trying to accomplish. ​

Our part number 20-100-0331_A has multiple different vendor quantity options.

These different quantity options have different vendor part numbers.

For this example, it is the same screw but in quantity 10 or in quantity 25. These different quantities have different price breakdowns (ie 0.01 each for 10 screws or 0.008 each for 25 screws) as different vendor part numbers

https://secure.mybrayman.com/acr/external/odoo_purchase_types.png

When I create the PO it automatically selects the first vendor PN of quantity 10

https://secure.mybrayman.com/acr/external/odoo_rfq.png​

My questions are:

Is there a way for the system to know that if I need more than quantity 10 to go ahead and purchase the vendor item with a quantity 25, or is this something that a human will have to do?

And if it is, then how do you select the vendor item with a quantity of 25?

Best Answer

Hi,
If you are looking how to purchase the same products in different unit of measures, you can see the option to select the unit of measure inside the purchase order line.


Thanks

Avatar
Discard
Best Answer

Hi Mike:

The links posted by you are not accessible, so taking a shot at this based on your description of the requirements.

As suggested by Niyas, you can enable the multiple UoM feature and use it by doing the following:

  1. Go to Inventory > Configuration > Settings and enable "Units of Measure" (Sell and purchase products in different units of measure).

  2. The purchase UoM on your product template should be "Unit(s)".

  3. Define 2 new UoM (Pack of 10 and Pack of 25) by going to Inventory > Configuration > UoM. For example, the settings for "Pack of 25" would be:

    1. Category: Unit

    2. Type: Bigger than the reference unit of measure

    3. Ratio: 25

  4. You can use any of the 3 UoM's when you create the PO and Odoo will automatically do the conversion between them.

You can also check if the "Minimal Quantity" attribute is useful for driving which vendor item to pick by setting them to 10 and 25 for the vendor part numbers/sku for the 2 packs. However, you will need to specify the average per unit price in the product template when you set up the vendor for the product and then manually change the UoM to Pack of 10/25 in the PO before confirming it. This may allow you to at least automate the portion for picking the correct vendor SKU.

Avatar
Discard
Author Best Answer

bump

Avatar
Discard
Related Posts Replies Views Activity
1
Dec 19
2422
1
Dec 24
37
2
Dec 24
47
1
Dec 24
56
4
Dec 24
2622