コンテンツへスキップ
この質問にフラグが付けられました
salesale.order.linesale.order
13 返信
18812 ビュー
アバター
Pravitha

Hello, In sale.order.line I have a set a warning message. It pop-ups when the stock level is less than the requested quantity of product in the sale order. The message works perfectly. But the problem is even if the user is warnned that there is not enough stock the order can be confirmed. This should not happen.the order must not get confirmed. How can I do this? Someone please help. this is my warning message code: It is written in def product_id_change

if (qty > product_obj.available_qty):
    warn_msg = _('You requested %.2f.The available stock is %.2f !') %(qty,product_obj.available_qty)
    warning_msgs += _("Not enough stock ! : ") + warn_msg +"\n\n"
アバター
破棄
アバター
Sudhir Arya (ERP Harbor Consulting Services)
最善の回答

If you really want to stop the flow, you have to override product_id_change and write osv.except_osv instead of warning.

For example:

raise osv.except_osv(_('Error!'),_("Your Warning/Error Message."))

It will stop the execution and won't allow to proceed further until you solve it.

アバター
破棄
Pravitha
著作者

i did this but the result was the exception raised succesfully but the products description field went blank. and when I filled the description the everything worked normally. the order got confirmed even if there is no stock

Sudhir Arya (ERP Harbor Consulting Services)

It is because onchange is called when you change either product or quantity. But you are changing description only then onchange won't work and exception won't raise.

Pravitha
著作者

so wat should i do now? Is there any way?

Sudhir Arya (ERP Harbor Consulting Services)

You can make product_id mandatory.

Pravitha
著作者

is there any way i can do it on the confirm button defenition?

Sudhir Arya (ERP Harbor Consulting Services)

Yes, you can check is there product_id or not, if not then you can raise exception "Please Select Product".

アバター
Pravitha
著作者 最善の回答

Just add 

def action_wait(self, cr, uid, ids, context=None):
context = context or {}
for order in self.browse(cr, uid, ids):
    if not order.order_line:
        raise osv.except_osv(_('Error!'),_('You cannot confirm a sales order which has no line.'))
    # Raising exception to inform the user about the stock level before confirming the sale order
    for product in order.order_line:
        if (product.product_uom_qty > product.product_id.available_qty):
            raise osv.except_osv(_('Not enough stock !'), _('You requested %.2f.The available stock is %s !') %(product.product_uom_qty, product.product_id.available_qty))

in sale.py. The def action_wait is already defined. just add the code to into it. My problem got solved.

アバター
破棄
Sudhir Arya (ERP Harbor Consulting Services)

You should create your custom module Instead of changing core modules.

Pravitha
著作者

Yeah i have inherited sale.order and sale.order.line to do this

Alcaline

where did you get the available_qty?? because i got the same problem..

アバター
Omal Bastin
最善の回答

There is a module called warning. Please check it

アバター
破棄
アバター
davidvickyJ
最善の回答

Warning messages can be displayed for objects like sale order, purchase order, picking and invoice. The message is triggered by the form's onchange event.

http://1tour.vn

http://1tour.vn/khach-san/

http://1tour.vn/tour/

http://tainghebeats.vn

http://thuocla-dientu.com

アバター
破棄
関連投稿 返信 ビュー 活動
Odoo 19 - how does rounding work on Sales Order Lines? The Total isn't the sum of the order line totals 解決済
sale sale.order.line sale.order
アバター
アバター
1
11月 25
404
how to create sale order line on create of sale order
sale sale.order.line sale.order
アバター
アバター
1
4月 23
14408
Sale order copy problem in Odoo V15
product sale sale.order.line sale.order
アバター
0
12月 21
3176
How to affect special lot on product from sale.order.line
sale sale.order.line serial_number sale.order
アバター
0
3月 15
4118
How to generate line numbers on quotes 解決済
sale sale.order.line
アバター
アバター
1
1月 25
4403