1 ##############################################################################
3 # OpenERP, Open Source Management Solution
5 # 2004-2010 Tiny SPRL (<http://tiny.be>).
6 # 2009-2010 Veritos (http://veritos.nl).
9 # This program is free software: you can redistribute it and/or modify
10 # it under the terms of the GNU Affero General Public License as
11 # published by the Free Software Foundation, either version 3 of the
12 # License, or (at your option) any later version.
14 # This program is distributed in the hope that it will be useful,
15 # but WITHOUT ANY WARRANTY; without even the implied warranty of
16 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 # GNU Affero General Public License for more details.
19 # You should have received a copy of the GNU Affero General Public License
20 # along with this program. If not, see <http://www.gnu.org/licenses/>.
22 ##############################################################################
24 from osv import fields, osv
26 class account_invoice_line(osv.osv):
27 _inherit = "account.invoice.line"
29 def move_line_get(self, cr, uid, invoice_id, context=None):
32 res = super(account_invoice_line,self).move_line_get(cr, uid, invoice_id, context=context)
33 inv = self.pool.get('account.invoice').browse(cr, uid, invoice_id, context=context)
34 if inv.type in ('out_invoice','out_refund'):
35 for i_line in inv.invoice_line:
37 if inv.type == 'out_invoice':
38 # debit account dacc will be the output account
39 # first check the product, if empty check the category
40 dacc = i_line.product_id.product_tmpl_id.property_stock_account_output and i_line.product_id.product_tmpl_id.property_stock_account_output.id
42 dacc = i_line.product_id.categ_id.property_stock_account_output_categ and i_line.product_id.categ_id.property_stock_account_output_categ.id
45 # debit account dacc will be the input account
46 # first check the product, if empty check the category
47 dacc = i_line.product_id.product_tmpl_id.property_stock_account_input and i_line.product_id.product_tmpl_id.property_stock_account_input.id
49 dacc = i_line.product_id.categ_id.property_stock_account_input_categ and i_line.product_id.categ_id.property_stock_account_input_categ.id
50 # in both cases the credit account cacc will be the expense account
51 # first check the product, if empty check the category
52 cacc = i_line.product_id.product_tmpl_id.property_account_expense and i_line.product_id.product_tmpl_id.property_account_expense.id
54 cacc = i_line.product_id.categ_id.property_account_expense_categ and i_line.product_id.categ_id.property_account_expense_categ.id
58 'name': i_line.name[:64],
59 'price_unit':i_line.product_id.product_tmpl_id.standard_price,
60 'quantity':i_line.quantity,
61 'price':i_line.product_id.product_tmpl_id.standard_price * i_line.quantity,
63 'product_id':i_line.product_id.id,
64 'uos_id':i_line.uos_id.id,
65 'account_analytic_id':i_line.account_analytic_id.id,
66 'taxes':i_line.invoice_line_tax_id,
71 'name': i_line.name[:64],
72 'price_unit':i_line.product_id.product_tmpl_id.standard_price,
73 'quantity':i_line.quantity,
74 'price': -1 * i_line.product_id.product_tmpl_id.standard_price * i_line.quantity,
76 'product_id':i_line.product_id.id,
77 'uos_id':i_line.uos_id.id,
78 'account_analytic_id':i_line.account_analytic_id.id,
79 'taxes':i_line.invoice_line_tax_id,
81 elif inv.type in ('in_invoice','in_refund'):
82 for i_line in inv.invoice_line:
84 if i_line.product_id.product_tmpl_id.type != 'service':
85 # get the price difference account at the product
86 acc = i_line.product_id.product_tmpl_id.property_account_creditor_price_difference and i_line.product_id.product_tmpl_id.property_account_creditor_price_difference.id
88 # if not found on the product get the price difference account at the category
89 acc = i_line.product_id.categ_id.property_account_creditor_price_difference_categ and i_line.product_id.categ_id.property_account_creditor_price_difference_categ.id
91 if inv.type == 'in_invoice':
92 # oa will be the stock input account
93 # first check the product, if empty check the category
94 oa = i_line.product_id.product_tmpl_id.property_stock_account_input and i_line.product_id.product_tmpl_id.property_stock_account_input.id
96 oa = i_line.product_id.categ_id.property_stock_account_input_categ and i_line.product_id.categ_id.property_stock_account_input_categ.id
99 # oa will be the stock output account
100 # first check the product, if empty check the category
101 oa = i_line.product_id.product_tmpl_id.property_stock_account_output and i_line.product_id.product_tmpl_id.property_stock_account_output.id
103 oa = i_line.product_id.categ_id.property_stock_account_output_categ and i_line.product_id.categ_id.property_stock_account_output_categ.id
105 # get the fiscal position
106 fpos = i_line.invoice_id.fiscal_position or False
107 a = self.pool.get('account.fiscal.position').map_account(cr, uid, fpos, oa)
109 # calculate and write down the possible price difference between invoice price and product price
111 if a == line['account_id'] and i_line.product_id.id == line['product_id']:
112 uom = i_line.product_id.uos_id or i_line.product_id.uom_id
113 standard_price = self.pool.get('product.uom')._compute_price(cr, uid, uom.id, i_line.product_id.product_tmpl_id.standard_price, i_line.uos_id.id)
114 if standard_price != i_line.price_unit and line['price_unit'] == i_line.price_unit and acc:
115 price_diff = i_line.price_unit - standard_price
116 line.update({'price':standard_price * line['quantity']})
119 'name': i_line.name[:64],
120 'price_unit':price_diff,
121 'quantity':line['quantity'],
122 'price': price_diff * line['quantity'],
124 'product_id':line['product_id'],
125 'uos_id':line['uos_id'],
126 'account_analytic_id':line['account_analytic_id'],
127 'taxes':line.get('taxes',[]),
132 def product_id_change(self, cr, uid, ids, product, uom, qty=0, name='', type='out_invoice', partner_id=False, fposition_id=False, price_unit=False, address_invoice_id=False, currency_id=False, context=None):
136 return super(account_invoice_line, self).product_id_change(cr, uid, ids, product, uom, qty, name, type, partner_id, fposition_id, price_unit, address_invoice_id, currency_id, context)
138 res = super(account_invoice_line, self).product_id_change(cr, uid, ids, product, uom, qty, name, type, partner_id, fposition_id, price_unit, address_invoice_id, currency_id, context)
140 if type in ('in_invoice','in_refund'):
141 product_obj = self.pool.get('product.product').browse(cr, uid, product, context=context)
142 if type == 'in_invoice':
143 oa = product_obj.product_tmpl_id.property_stock_account_input and product_obj.product_tmpl_id.property_stock_account_input.id
145 oa = product_obj.categ_id.property_stock_account_input_categ and product_obj.categ_id.property_stock_account_input_categ.id
147 oa = product_obj.product_tmpl_id.property_stock_account_output and product_obj.product_tmpl_id.property_stock_account_output.id
149 oa = product_obj.categ_id.property_stock_account_output_categ and product_obj.categ_id.property_stock_account_output_categ.id
151 fpos = fposition_id and self.pool.get('account.fiscal.position').browse(cr, uid, fposition_id, context=context) or False
152 a = self.pool.get('account.fiscal.position').map_account(cr, uid, fpos, oa)
153 res['value'].update({'account_id':a})
156 account_invoice_line()
158 class account_invoice(osv.osv):
159 _inherit = "account.invoice"
161 def _refund_cleanup_lines(self, cr, uid, lines):
163 inv_id = line['invoice_id']
164 inv_obj = self.browse(cr, uid, inv_id[0])
165 if inv_obj.type == 'in_invoice':
166 if line.get('product_id',False):
167 product_obj = self.pool.get('product.product').browse(cr, uid, line['product_id'][0])
168 oa = product_obj.product_tmpl_id.property_stock_account_output and product_obj.product_tmpl_id.property_stock_account_output.id
170 oa = product_obj.categ_id.property_stock_account_output_categ and product_obj.categ_id.property_stock_account_output_categ.id
172 fpos = inv_obj.fiscal_position or False
173 a = self.pool.get('account.fiscal.position').map_account(cr, uid, fpos, oa)
174 account_data = self.pool.get('account.account').read(cr, uid, [a], ['name'])[0]
175 line.update({'account_id': (account_data['id'],account_data['name'])})
176 res = super(account_invoice,self)._refund_cleanup_lines(cr, uid, lines)
180 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: