Hi,

My recent post cannot show some of the code but I cannot edit it. Below is the complete post. Can you please help repost it. Thanks.

Hi,

I am developing with odoo 14. I would like to allow the user to select production lot from a dropdown menu when creating the delivery note but I only want to show production lot with non-zero quantity (postive qty).

Here's my code for the view:

    <record model="ir.ui.view" id="view_stock_move_line_detailed_operation_tree_inherited">

        <field name="name">stock.move.line.detailed.operation.tree.inherited</field>

        <field name="model">stock.move.line</field>

        <field name="inherit_id" ref="stock.view_stock_move_line_detailed_operation_tree"/>

        <field name="priority" eval="15"/>

        <field name="arch" type="xml">

                <xpath expr="//field[@name='lot_id']" position="replace">

                        <field name="lot_id" domain="[('product_qty','>',0)]" groups="stock.group_production_lot" attrs="{'column_invisible': [('parent.show_lots_text', '=', True)],

                                'invisible': [('lots_visible', '=', False)]}" context="{'default_product_id': product_id,

                                'default_company_id': company_id, 'active_picking_id': picking_id, 'display_qty': True}" optional="show"/>

                </xpath>

                <xpath expr="//field[@name='product_uom_id']" position="after"> 

                        <field name="no_of_outer" />

               </xpath>         

        </field>

    </record>

I got the following error:

Unsearchable field "stock.production.lot.product_qty" in path 'product_qty' in domain of <field name="lot_id"> ="[('product_qty','>',0)]"

Please advise how I can correct this. Thanks.

Regards,

Simon Lee