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

Bug #754339 reported by Salvi Angjeli
82
This bug affects 15 people
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Confirmed
Wishlist
OpenERP R&D Addons Team 3
OpenERP Community Backports (Addons)
Status tracked in 7.0
6.1
Fix Released
Undecided
Unassigned
7.0
Fix Committed
High
Holger Brunn (Therp)
Therp Backports (Deprecated)
Fix Released
High
Ronald Portier (Therp)

Bug Description

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

Related branches

Revision history for this message
Salvi Angjeli (salvi-angjeli) wrote :
Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

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.

Revision history for this message
Salvi Angjeli (salvi-angjeli) wrote :

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

Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

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.

Changed in openobject-addons:
status: New → Invalid
Revision history for this message
Salvi Angjeli (salvi-angjeli) wrote :

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

Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

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.

Revision history for this message
Salvi Angjeli (salvi-angjeli) wrote :

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,

Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

I am consider this issue as wishlist.

Thanks.

description: updated
Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
importance: Undecided → Wishlist
status: Invalid → Confirmed
summary: - Problems with the creation of a customer/supplier invoice.
+ Partner assigned Price List is not applied with the creation of a
+ customer/supplier invoice.
Revision history for this message
Steffi Frank (Bremskerl, DE) (steffi-frank) wrote :

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!

Revision history for this message
Alan Lord (theopensourcerer) wrote :

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.

Revision history for this message
Fabrizio M (mr-file) wrote :

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

Revision history for this message
Fabrizio M (mr-file) wrote :

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

Changed in therp-backports:
milestone: none → 6.1-maintenance
importance: Undecided → High
assignee: nobody → Ronald Portier (Therp) (rportier1962)
Changed in therp-backports:
status: New → Fix Released
Lara (Therp) (lfreeke)
Changed in therp-backports:
status: Fix Released → Fix Committed
Lara (Therp) (lfreeke)
Changed in therp-backports:
milestone: 6.1-maintenance → 7.0-maintenance
Changed in therp-backports:
status: Fix Committed → Fix Released
Revision history for this message
Stefan Rijnhart (Opener) (stefan-opener) wrote :

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

Revision history for this message
Stefan Rijnhart (Opener) (stefan-opener) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.