How to set serial numbers for the sale order line

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

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Project
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

How to set serial numbers for the sale order line

sale

2 Trả lời

9855 Lượt xem

nishad

I want to inherit the existing sale module in to my new custom module which extends current sale module and adds a serial number column to my sale order line tree. But it throws an error like as follows , where am i went wrong ?

 File "parser.pxi", line 1468, in lxml.etree._parseDocFromFilelike (src/lxml/lxml.etree.c:81783)
 File "parser.pxi", line 1024, in lxml.etree._BaseParser._parseDocFromFilelike (src/lxml/lxml.etree.c:78830)
 File "parser.pxi", line 569, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:74567)
 File "parser.pxi", line 650, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:75458)
 File "parser.pxi", line 590, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:74791)
 XMLSyntaxError: AttValue: " or ' expected, line 31, column 28

view.py

        <record id="view_order_line_tree2" model="ir.ui.view">
        <field name="name">sale.order.line.tree.inherit</field>
        <field name="model">sale.order.line</field>
        <field name="inherit_id" ref=sale.view_order_form/>
        <field name="arch" type="xml">
            <xpath expr="//field[@name='order_line']/tree" position="attributes">
                <attribute name="sl_no"/>
            </xpath>
        </field>
       </record>

sale_modified.py file contents

    class sale_order_line2(osv.osv):

            _inherit = 'sale.order.line'

           _columns = {
              'sl_no': fields.integer("SL No", required=True)
                  }

             _defaults = {
                  'sl_no':1,
                   }

Any hint to solve the above mentioned issue is appreciated .. Thanks in advance

Sehrish

Sale Order Serial Numbers & Product Images | Auto Numbering & Custom Images in Reports in Odoo
This Odoo module automatically assigns serial numbers to sale order lines and displays product images in reports. If a serial number is manually set to a custom string (e.g., "A"), the next item resets numbering to 1. Additionally, if a product has no image, you can manually upload a custom image for the sale order line—without affecting the original product image.
https://apps.odoo.com/apps/modules/18.0/mh_display_serial_number_and_image

Xsias

Câu trả lời hay nhất

Are you sure that expr="//field[@name='order_line']/tree" is correct ? Try expr="//field[@name='order_line']".

==========

EDIT

Try this :

<record id="view_order_line_tree2" model="ir.ui.view">
        <field name="name">sale.order.line.tree.inherit</field>
        <field name="model">sale.order</field>
        <field name="inherit_id" ref="sale.view_order_form"/>
        <field name="arch" type="xml">
            <xpath expr="//field[@name='order_line']/tree/field[@name='product_id']" position="before">
                <field name="sl_no"/>
            </xpath>
        </field>
</record>

nishad

Tác giả

I tried this case but its not working....

Xsias

Can you try my edit ?

nishad

Tác giả

Hi Xsias , it works but a small change , instead of model "sale.order.line" we have to look in to "sale.order" ..... Thanks for your "xpath" expression too....... Hurray....... Thanks all..

nishad

Tác giả

"correct 1"

Xsias

I have edited with your comment. If it does work, don't hesitate to mark the answer as correct. This is to facilitate users future search.

wizardz

This works perfect, but you can't edit the field in the lines right now

Hiral Patel (hip)

Hello,

Just replace <xpath> </xpath> with :

<record id="view_sale_orderfor" model="ir.ui.view">
    <field name="name">sale.order.form.inherit5</field>
    <field name="model">sale.order</field>
    <field name="inherit_id" ref="sale.view_order_form"/>
    <field name="arch" type="xml">
        <field name="product_id" position="before">
            <field name="sl_no"/>
        </field>
        <xpath expr="//page[@string='Order Lines']/field[@name='order_line']/tree[@string='Sales Order Lines']/field[@name='product_id']" position="before">
            <field name="sl_no"/>
        </xpath>
    </field>
</record>

Thanks.

nishad

Tác giả

Hi Hiral unfortunately still the error remains the same ... I doubt am i inheriting the right view in my file ? <field name="inherit_id" ref=sale.view_order_form/>

Hiral Patel (hip)

Hello, I have updated code apply change and try it. You have inherited correct view. :)

nishad

Tác giả

Sorry still it is not showing the sl_no column in my tree .......?

Hiral Patel (hip)

<xpath expr="//page[@string='Order Lines']/field[@name='order_line']/tree[@string='Sales Order Lines']/field[@name='product_id']" position="before"> try this.

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
Issue After Migration: Unable to Save Sales Order in v18 Đã xử lý sale	1 thg 5 25	1045
〈〈강릉출장마사지〉〉(｛카톡pxp88｝강릉출장언니〖홈피pxp8,c0m〗강릉출장콜걸※강릉출장샵 강릉애인대행メ강릉출장아가씨 강릉출장만남 강릉섹파추천あ sale	0 thg 2 20	3
sales: change Currency symbol customer invoice Đã xử lý sale	4 thg 7 18	18369
How can i record sales return in OpenERP sale	2 thg 1 16	9166
Automatic inter-company sales sale	0 thg 10 24	4035

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!