Partner assigned Price List is not applied with the creation of a customer/supplier invoice.

[Salvi Angjeli]

Price List should be consider from partner in Invoice line product onchange.

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Salvi,

Would you please explain your scenario with proper example so I can check the problem easily.
Here I have checked this specified issue successfully with different Currency Pricelist.

Thanks.

[Salvi Angjeli (salvi-angjeli)]

Hi Vinay,

In my case the company currency is 'USD' and the product price currecy is 'EUR'.

Example (
1. create a product with sale price=50 ( in this case are 50 EUR).
2. create an invoice for a customer, the currency of invoice is 'USD'.
3. create an invoice line for this invoice, choose the product created before, here the price unit is still
  50 but is not correct because this is the sale price of product in EUR and not in USD (my invoice is in USD and the currency rate is # from 1)
)

I hope i was clear

Thanks

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Salvi,

When you defined the product price in product form in that time this price should be consider in company currency. So If you assigned USD as a company currency in your DB then The price is considered as an USD and product on change the price remains to 50 USD.

If you want to change this in to EUR then simply need to call Change currency wizard from Invoice Form.

One more thing I need to include here, If you needed this price in EUR simply define a pricelist in EUR and assign this in to Sale Order. So in product on change the correct converted price will be taken and It will pass into Invoice.

Hope this is enough for you.

This is not a bug It's a wrong configuration issue from your end.
If you have any problem with that you can post your view.

Thanks.

[Salvi Angjeli (salvi-angjeli)]

Hello Vinay,

Yes when we create a new db, and choose a currency for our company the system automatically assigned to product unit price the same currency, but from the administration menu we can change the company currency (this is not going to affect product unit price currency), so in this case we are going to consider the company currency, or the product unit price currency assigned in the db for our products?

I think that this is a bug because in some case the company currency should be different from product unit price currency for example:
( 1. The company currency we need in most of the case for the account declaration: like USD
  2. The base currency for product unit price could be in another currency like: EUR, ( yes of course we can play with the pricelist currency, but the price change always when the currency rate change), for this reason we need to have a base currency for product that could be different.
)

Create an invoice from the sale order is ok ( because the system take in consideration the pricelist of the customer), but if i would like to create an invoice directly ( not passing from the sale order) the system doesn't take in consideration the pricelist, why?

Thanks

[Vinay Rana (OpenERP) (vra-openerp)]

Hello Salvi,

There is not any direct relational field exist in Invoice object which makes to connect directly with price list object.
In SO and PO you have a price list assignment directly.

If you deal with price list then It always comes with SO and PO in generalize manner. Invoice contains payment terms related issue.

You can post your opinion on feedback.openerp.com.

Thanks.

[Salvi Angjeli (salvi-angjeli)]

Hello Vinay,

I am sorry maybe i wasn't very clear before, when i said 'the system doesn't take in consideration the pricelist', but i wanted to say this: " the method product_id_change' in the 'account.invoice.line' object doesn't take in consideration the pricelist assigned to a customer when calculating the unit price ".

In an invoice object is true that we can't choose a pricelist, but indirectly we can take it from the customer/supplier
choice

Thanks,

[Vinay Rana (OpenERP) (vra-openerp)]

I am consider this issue as wishlist.

Thanks.

[Steffi Frank (Bremskerl, DE) (steffi-frank)]

We've got a similar issue:

one of our companies works with subcontracting in China. Therefor the raw material planning and purchasing is done by this company. To control the stock level in China we defined the subcontractors location NOT as a suppliers but internal location.

Through internal moves the raw material (purchased in Europe) gets shipped to China.
This raw material gets sold to the subcontractor for internal reason (supplier is defined as 'customer' as well, all prices are set up in a sales pricelist).

But even if the company won't sell the raw material to the subcontractor: for clearing the goods for exportation they need a proforma invoice. So we create internal moves with 'invoice control = to be invoiced'. 'Create Invoice' from picking list works - nice! But without any price related to the customers pricelist.... And we can't set the sale price in product.form: the company sells to different subcontractors with different sale prices, therefor we set up different priclists!

[Alan Lord (theopensourcerer)]

This affects me too. We have a customer that does not need to create quotes/sales orders, they just generate Invoices. But we do need the Price List functionality.

I have just realised that I can't pick a pricelist when creating an Invoice and am very disappointed. I can think of several other scenarios and customers where they only create Invoices directly and do not require the Sales order functionality.

This strikes me as lack of consistency across the product and a big bug/problem to my mind.

[Fabrizio M (mr-file)]

This bug affects me too. We have customers who generates customer invoices only not using the sale order functionality.
I've checked that in customer invoices i can't pick the pricelist as already said, neither the system will pick the price variant margin set on the product form.
Do you think to fix this bug or someone has a workaround?
Regards Fabrizio

[Fabrizio M (mr-file)]

Workaround found. Sorry, i didn't see the patch attached at the top :-)

[Stefan Rijnhart (Opener) (stefan-opener)]

For future reference, here is a port to Odoo/7.0 on Github: https://github.com/StefanRijnhart/odoo/tree/7.0-lp754339

[Stefan Rijnhart (Opener) (stefan-opener)]

sht747, you have set this to fixed released just now. Any pointers to where this has happened?