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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Product Unit of Measure Ratio Issue. Odoo creates unnecessary Backorder

inventory bom Unit of Measure

3 الردود

6546 أدوات العرض

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

الكاتب

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

الكاتب

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

الكاتب

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

الكاتب

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

Nihat Demir

الكاتب

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Odoo 11 Inventory, Unit of Measure and BOM for Restaurants & Bars تم الحل inventory bom Unit of Measure odoo11	4 نوفمبر 24	8791
How to display the correct UOM in delivery order ? bom Unit of Measure	0 يوليو 24	2010
How do you link the material items from the BOM to there respective product page? inventory bom	0 مارس 15	4529
How to Dropship Kits inventory bom kit	1 يوليو 25	1127
Multiple veriants of the same component. inventory bom component	0 ديسمبر 24	1916

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!