Hai,
I wanted to add a new field named as brand in purchase order line,so i created a new module and also i want to see this field in the corresponding invoice.
class purchase_order_line(osv.osv):
_inherit ='purchase.order.line'
_columns = {
'brand' : fields.text('Brand'),
}
def onchange_product_id(self, cr, uid, ids, pricelist_id, product_id, qty, uom_id,
partner_id, date_order=False, fiscal_position_id=False, date_planned=False,
name='', price_unit=False, context=None):
value = {}
if not product_id:
return value
names = self.pool.get('product.product').browse(cr, uid,product_id, context=context)
value.update({
'brand' : names.product_brand_id and names.product_brand_id.name or False,
'name' : names.product_brand_id and names.product_brand_id.name or False,
# 'sitelocation': names.sitelocation and names.sitelocation.id or False,
#
})
return {'value' : value}
purchase_order_line()
class purchase_order(osv.osv):
_inherit ='purchase.order'
def _prepare_inv_line(self, cr, uid, account_id, order_line, context=None):
"""Collects require data from purchase order line that is used to create invoice line
for that purchase order line
:param account_id: Expense account of the product of PO line if any.
:param browse_record order_line: Purchase order line browse record
:return: Value for fields of invoice lines.
:rtype: dict
"""
print 'helloooooooooooooooooooooooooooooooooooo',order_line.brand
return {
'name': order_line.name,
'account_id': account_id,
'price_unit': order_line.price_unit or 0.0,
'quantity': order_line.product_qty,
'product_id': order_line.product_id.id or False,
'brand':order_line.brand,
'uos_id': order_line.product_uom.id or False,
'invoice_line_tax_id': [(6, 0, [x.id for x in order_line.taxes_id])],
'account_analytic_id': order_line.account_analytic_id.id or False,
}
def action_invoice_create(self, cr, uid, ids, context=None):
print 'haiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii'
if context is None:
context = {}
journal_obj = self.pool.get('account.journal')
inv_obj = self.pool.get('account.invoice')
inv_line_obj = self.pool.get('account.invoice.line')
res = False
uid_company_id = self.pool.get('res.users').browse(cr, uid, uid, context=context).company_id.id
for order in self.browse(cr, uid, ids, context=context):
context.pop('force_company', None)
if order.company_id.id != uid_company_id:
#if the company of the document is different than the current user company, force the company in the context
#then re-do a browse to read the property fields for the good company.
context['force_company'] = order.company_id.id
order = self.browse(cr, uid, order.id, context=context)
pay_acc_id = order.partner_id.property_account_payable.id
journal_ids = journal_obj.search(cr, uid, [('type', '=', 'purchase'), ('company_id', '=', order.company_id.id)], limit=1)
if not journal_ids:
raise osv.except_osv(_('Error!'),
_('Define purchase journal for this company: "%s" (id:%d).') % (order.company_id.name, order.company_id.id))
# generate invoice line correspond to PO line and link that to created invoice (inv_id) and PO line
inv_lines = []
for po_line in order.order_line:
acc_id = self._choose_account_from_po_line(cr, uid, po_line, context=context)
inv_line_data = self._prepare_inv_line(cr, uid, acc_id, po_line, context=context)
inv_line_id = inv_line_obj.create(cr, uid, inv_line_data, context=context)
inv_lines.append(inv_line_id)
po_line.write({'invoice_lines': [(4, inv_line_id)]}, context=context)
#get invoice data and create invoice
inv_data = {
'name': order.partner_ref or order.name,
'reference': order.partner_ref or order.name,
'account_id': pay_acc_id,
'type': 'in_invoice',
'partner_id': order.partner_id.id,
'currency_id': order.pricelist_id.currency_id.id,
'journal_id': len(journal_ids) and journal_ids[0] or False,
'invoice_line': [(6, 0, inv_lines)],
'origin': order.name,
'fiscal_position': order.fiscal_position.id or False,
'payment_term': order.payment_term_id.id or False,
'company_id': order.company_id.id,
}
inv_id = inv_obj.create(cr, uid, inv_data, context=context)
# compute the invoice
inv_obj.button_compute(cr, uid, [inv_id], context=context, set_total=True)
# Link this new invoice to related purchase order
order.write({'invoice_ids': [(4, inv_id)]}, context=context)
res = inv_id
return res
purchase_order()
class invoice_line(osv.osv):
_inherit ='account.invoice.line'
_columns = {
'brand' : fields.char('Brand'),
}
invoice_line()
By doing this above code i get the wanted result,but while creating a purchase order i didn't getting the unit price and subtotal values. How can i solve this problem ?
Updated code:
from openerp.osv import fields, osv
class purchase_order_line(osv.osv):
_inherit ='purchase.order.line'
_columns = {'brand' : fields.text('Brand'),
}
def onchange_product_id(self, cr, uid, ids, pricelist_id, product_id, qty, uom_id,
partner_id, date_order=False, fiscal_position_id=False, date_planned=False,
name='', price_unit=False, context=None):
value = {}
if not product_id:
return value
value = super(purchase_order_line,self).onchange_product_id(cr, uid, ids, pricelist_id, product_id, qty, uom_id, partner_id, date_order, fiscal_position_id, date_planned, name, price_unit, context )
names = self.pool.get('product.product').browse(cr, uid,product_id, context=context)
value.update({
'brand' : names.product_brand_id and names.product_brand_id.name or False,
})
return {'value' : value}purchase_order_line()
When I updated like the above code it doesn't .show .the .Description field , .Scheduled Date field.Then what is wrong in my code.
