Product Unit of Measure Ratio Issue. Odoo creates unnecessary Backorder

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Product Unit of Measure Ratio Issue. Odoo creates unnecessary Backorder

inventory bom Unit of Measure

3 Odpowiedzi

6053 Widoki

Nihat Demir

I create Bottle of Drink 750ml product with UOM Bottle 750ml (see below). Then created Glass of 250ml product which will be using Bottle of Drink 750ml in the BOM (see below). Issue is if I make sale of Glass 250ml and check SALES ORDER and Delivery Order RESERVED Quantity doesnt not match with Initial Demanded Quantity. (see below) I think Bottle 750ml Unit of Measure ratio is the issue here. Therefore, Odoo ask to create BACKORDER because of not matched quantities. (see below). question is

HOW CAN I MAKE RESERVED QTY (997.50ml) SAME AS ORDERED QTY (1000ml) AND NO BACKORDER CREATED?

HERE IS THE SALES ORDER and DELIVERY ORDER LOOK LIKE.

Nihat Demir

Autor

I configured the UOMs as you mentioned. ml is reference and 250ml, 750ml bigger than Reference UOM. Created new products and applied new UOMs to the products. Created BOM for Glass 250ml. Used Bottle products and 1x 250ml UOM. I made purchase of 750ml Bottles everything is fine. Then made a sale of Glass 250ml. see below.

Ray Carnes (ray)

4 Bottles of Wine is 12 glasses. An order for 3 glasses needs only two Bottles. In this example, what happens to the 2/3 of the second Bottle that is left after pouring three glasses? Can it be used for the next order of Wine?

Nihat Demir

Autor

Hi Ray, 3 Glass of 250ml = 1x Bottle of 750ml. Yes 2/3 opened Bottle can be used for future Glass 250ml Orders. Why doesnt Odoo RESERVE 4x 250ml but reserves 3.99x 250ml? In this example, Why is Reserved Qty never be same to Initial Qty?

Nihat Demir

Autor

I have just tested, ordered 3x 250ml, Delivery Order is correct this time, Initial qty and reserved qty 3x 250ml are same. BUT when ordered 1x Glass, Initial qty 1x 250ml and RESERVED qty is 0.99x Glass. Again some how not matching.

Ray Carnes (ray)

You will get what you expect if you define the Reference Unit of Measure as milliliters instead of using Liters.

Deactivate Liters (as well as the other Volume Units of Measure) and define the following Units of Measure:

Nihat Demir

Autor

Thanks Ray. I tried what you said. See below screenshots. I think there is bug in Odoo.

Nihat Demir

Autor

By the way, I have latest build of Odoo 12 as of today

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Odoo 11 Inventory, Unit of Measure and BOM for Restaurants & Bars Rozwiązane inventory bom Unit of Measure odoo11	4 lis 24	8137
How to display the correct UOM in delivery order ? bom Unit of Measure	0 lip 24	1444
How do you link the material items from the BOM to there respective product page? inventory bom	0 mar 15	3927
How to Dropship Kits inventory bom kit	1 lip 25	419
Multiple veriants of the same component. inventory bom component	0 gru 24	1142

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!