# Getting result in the unit price column.

By
charlesraj
on 3/6/14, 9:05 AM 1,385 views

I have three fields in customer invoice form "Current reading(cr)" ,"Previous reading(pr)" ,"Free copies(fc)" , The three columns have values . Default value of Unit price is 0.15 Paise

cr=3000, pr=1000 , fc= 1000 unitprice="0.15"

((cr - pr)-(fc))*unit price of my product. = ((3000-1000)-(1000) * 0.15

I want to display 150 in my unit price field in customer invoice.

How can be make this.

#### Atul Kumar jain

--Atul Kumar jain--
934
| 5 3 7
Indore, India
--Atul Kumar jain--

.

Atul Kumar jain
On 3/7/14, 2:39 AM

create the unit_price field as functional field and define the function as calculation you want than you get the value as you want

``````def _get_total(self, cr, uid, ids, field_names, args, context=None):
res = {}
for line in self.browse(cr, uid, ids, context=context):
res[line.id] = (((line.cr-line.pr)-(linefc)*line.unit_price))
return res
``````

my field is

``````   'cr':fields.float("CR")
'pr':field.float("PR")
'fc':fields.float("FC")

'unit_price':fields.function(_get_total, string='Unit Price', type="float", readonly=True, store=True),
``````

Ashmsh.M
on 3/7/14, 5:41 AM

TypeError: _get_total() takes at least 8 arguments (7 given) What does it actually means..

Ashmsh.M
on 3/7/14, 5:42 AM

this error appears while press the "save" button in the invoice..

Ashmsh.M
on 3/7/14, 5:44 AM

Atul Kumar jain
on 3/7/14, 7:55 AM

Hello Athul thanks for your valuable time . i solved this , Below i paste my code.

Ashmsh.M
on 3/7/14, 8:07 AM

I use the onchange function to display the result..

Ashmsh.M
on 3/7/14, 8:11 AM

Hi, Atul i need an another help.On generating a report, Can you help me.

Ashmsh.M
on 3/11/14, 1:33 AM

what kind of help ? which type of report

Atul Kumar jain
on 3/11/14, 2:08 AM

NetbeamERP Technology
on 3/18/14, 9:34 AM

NetbeamERP Technology
on 3/19/14, 3:29 AM
Ashmsh.M
On 3/7/14, 8:08 AM
``````class rent_rent(osv.osv):

_inherit = 'account.invoice'

_columns = {
'fre_cop': fields.float('Free copies', size=64,),
'price': fields.float('Price',size=64,),
'total': fields.float('Total',size=64),
}

``````

rent_rent()

in my xml file.

``````<?xml version="1.0" encoding="UTF-8"?>
``````

<openerp> <data>

<record model="ir.ui.view" id="fleet_vehicle_form" &gt;="" <field="" name="name">account.invoice.form.inherit</field> <field name="model">account.invoice</field> <field name="inherit_id" ref="account.invoice_form"/> <field name="arch" type="xml">

``````    <!--  <form string="Vehicle" version="7.0">-->
<field name="date_invoice" position="after">
<field name="fre_cop"/>
<field name="total"/>
</field>
<!--</form>-->
</field>
</record>
``````

<record model="ir.actions.act_window" id="account_invoice"> <field name="name">Account</field> <field name="res_model">account.invoice</field> <field name="view_type">form</field> <field name="view_mode">tree,form</field> </record>

</data> </openerp>

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

### Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

0 follower(s)

### Stats

 Asked: 3/6/14, 9:05 AM Seen: 1385 times Last updated: 3/16/15, 8:10 AM