Skip to Content
Menu
This question has been flagged

???




UPDATE #1

Just to be sure we all talk the same thing. Here are screenshots.

The product :





The supplier :




The pricelist :



 

With a request for quotation, we get the right price of 1,52 $. 



With an invoice, always impossible to get our price of 1,52 $.


Is it the same thing for you?


Avatar
Discard
Best Answer

Pricelists are used only in sale, purchase, pos forms, not in invoice form, for that, the field should be add to the invoice form, to override methods product_id_change depending pricelist (eventually onchange_partner_id to get automatically the good pricelist) .


Difference between product price inherited from sale, purchase, pos in an invoice (without do a product onchange after creation of this invoice), and created an invoice directly without inherithing sale, purchase, pos, is due to onchange on field product_id.

Example :

for sale, pricelist is used to calculate price :


def product_id_change(self, cr, uid, ids, pricelist, product, qty=0,

uom=False, qty_uos=0, uos=False, name='', partner_id=False,

lang=False, update_tax=True, date_order=False, packaging=False, fiscal_position=False, flag=False, context=None):

.....................


price = self.pool.get('product.pricelist').price_get(cr, uid, [pricelist],

product, qty or 1.0, partner_id, {

'uom': uom or result.get('product_uom'),

'date': date_order,

})[pricelist]


...............................


for invoice, no pricelist used :


def product_id_change(self, product, uom_id, qty=0, name='', type='out_invoice',

partner_id=False, fposition_id=False, price_unit=False, currency_id=False,

company_id=None):

..................


if type in ('in_invoice', 'in_refund'):

values['price_unit'] = price_unit or product.standard_price

else:

values['price_unit'] = product.list_price

..................


It is enough clear ?


bye

Avatar
Discard

@Pascal Can you try to modify the pricelist by adding the product (or category) you are buying

Clear! thanks. would'nt it be a bug? if you make a sale with a price depending of the pricelist that you are not able to invoice with the same price.

when you have an order or a picking, you push a button to create invoice, the called function by the button takes values of the order to create the invoice, in this case, the onchange of product is not called, and values correspond to the sale, more, never modify invoice line by changing values in popup product because in this case, values will no more correspond to the order if you use special pricelist, bye

Author

Thanks a lot for all. I print all of it. We will use it soon.

Hello I have build a module, which uses the price lists on direct invoice-creation. The module has some addition features. Have a look at http://www.itis-odoo.de/en_US/page/preislisten-modul regards Frank

Best Answer




The parner form (your client) has a field where you state which pricelist will be applied for the transaction with this partner.

Same functionality for the suppliers



Avatar
Discard
Author

By chance, would you have a url of an example?

I don't know the reason why the picture (screen shot) I have added to my comment is not showing on the forum. Is there a limitation in size?

Author

not easy to put image on forum on this time. I have updated my post. Pricelists are well set in my supplier form. thanks

update my answer which explain why you have not same price in sale and invoice, bye

Related Posts Replies Views Activity
0
Mar 15
3463
2
Mar 15
5905
0
Aug 17
3352
0
Jun 17
3133
0
Jan 16
3517