Skip to Content
This question has been flagged
one2manysale.orderobject
1 Reply
12438 डेटा देखने का तरीका
अवतार
Krishna

in .py file--

class hotel_folio(osv.osv):


         _name = 'hotel.folio'
        _description = 'hotel folio new'
        _columns = {
            'sale_lines':fields.one2many('hotel.sale.line', 'folio_id', ondelete='cascade'),
            }

hotel_folio()

    class hotel_sale_line(osv.osv):

        _name = 'hotel.sale.line'
        _description = "Sale Line"
        _columns = {
                'order_line': fields.one2many('sale.order', 'order_line', 'Order Lines'),
                'folio_id':fields.many2one('hotel.folio'),
                }

hotel_sale_line()

And in .xml file--

                        <field name="sale_lines" colspan="4" nolabel="1">
                            <form string="Sale Order Line">
                            <separator string="Sale Order"/>
                            <field name="order_line" select="1" colspan="4" nolabel="1"/>                               
                            </form>
                            <tree string="Sale Order Line">
                            <field name="order_line" select="1"/>                               
                            </tree>
                        </field>

the error is---

File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\orm.py", line 4469, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\fields.py", line 557, in set File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\sale_stock\sale_stock.py", line 75, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\sale\sale.py", line 337, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server\openerp\addons\mail\mail_thread.py", line 242, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\orm.py", line 4469, in create File "C:\Program Files\OpenERP 7.0-20130627-231102\Server\server.\openerp\osv\fields.py", line 554, in set TypeError: 'long' object is not iterable

अवतार
खारिज करें
अवतार
saad
Best Answer

Hi,

  1. the ondelete attribure isn't in the right place
  2. we don't use select="1" in one2many fields
  3. You should create the relation id field (order_line) in sale.order object

Try this for your python file:

class hotel_folio(osv.osv):
         _name = 'hotel.folio'
        _description = 'hotel folio new'
        _columns = {
            'sale_lines':fields.one2many('hotel.sale.line', 'folio_id','Lines' ),
            }

hotel_folio()

class hotel_sale_line(osv.osv):

        _name = 'hotel.sale.line'
        _description = "Sale Line"
        _columns = {
                'order_line': fields.one2many('sale.order', 'order_line', 'Order Lines'),
                'folio_id':fields.many2one('hotel.folio','Related Folio', ondelete='cascade'),
                }
hotel_sale_line()
अवतार
खारिज करें
Krishna
लेखक

in sale.order, the relation was established already like this--------------------------- 'order_line': fields.one2many('sale.order.line', 'order_id', 'Order Lines', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}),

saad

This relation is between sale.order and sale.order.line. Your need is not clear, you may want that your 'hotel.folio' has many sale.order.line !!

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
One2Many relation - pass the parent id
one2many relationship sale.order
अवतार
0
मार्च 15
6276
how to add a tree view in openerp 7?
treeview one2many object
अवतार
अवतार
1
मार्च 15
10209
How to change tree view column structure on One2many selection?
one2many sale.order.line sale.order odoov11
अवतार
अवतार
1
अक्तू॰ 20
6255
Display field only for one company on list view Solved
sale.order
अवतार
अवतार
1
मई 25
3174
how pass value to on2many field from parent form via context
one2many
अवतार
अवतार
1
जन॰ 25
4383