openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #25673
[Bug 1229232] Re: multi currency + pricelist + discount => completely wrong sale orders and invoices
** Description changed:
Using different currencies with pricelist with the discount on sale
order lines or invoice lines enabled gives completely wrong results.
Instance setup:
* Enable multiple pricelists
* Enable multiple currencies management in the instance
* Enable discount on sale order lines
* Enable purchase pricelists
* Create a new public pricelist in USD, based on the default pricelist with the formula: BasePrice * (1+0.00) + 10
* Create a new purchase price list in USD, based on the standard purchase pricelist with the formula BasePrice * (1+0.00) + 7
* Edit the partner Delta PC: set him as customer, and give him the new Public Pricelist USD as sales pricelist and the new Purchase price list USD as purchase price list
* Edit the Belle-Vue Kriek product, set the cost price to 0.25
Steps to reproduce issue with sale orders
===================================
* Create a new Sale order for Delta PC, add a sale order line, choose
"Belle-Vue Kriek" as the product, save the draft sale order.
Expected:
A sale order with a total amount of USD 0.83*1.5289+10 = 11.27, with 1
line with a unit price of 11.27, a discount of 0% and an amount of
11.27
Actual:
A sale order with a total amount of USD 11.27, with 1 line with a unit
price of 0.83, a discount of -1257.71% and an amount of 11.27
-
Steps to reproduce issue with customer invoice
==============================================
* Create a new customer invoice for Delta PC, add an invoice line,
choose "Belle-Vue Kriek" as the product, save the draft invoice.
Expected:
A sale order with a total amount of USD 0.83*1.5289+10 = 11.27, with 1
line with a unit price of 11.27, a discount of 0% and an amount of
11.27
Actual:
A sale order with a total amount of EUR 11.27, with 1 line with a unit
price of 0.83, a discount of -1257.71% and an amount of 11.27
(note that in addition to the sale order, the currency is incorrect,
although the amount is correct)
-
- Steps to reproduce issue with customer invoice
+ Steps to reproduce issue with supplier invoice
==============================================
* Create a new Supplier invoice for Delta PC, add an invoice line,
choose "Belle-Vue Kriek" as the product, save the draft invoice.
Expected:
A sale order with a total amount of USD 0.25*1.5289+7 = 7.38, with 1
line with a unit price of 7.38, a discount of 0% and an amount of 7.38
Actual:
A sale order with a total amount of EUR 7.38, with 1 line with a unit
price of 0.83, a discount of -789.42% and an amount of 7.38
-
- Steps to reproduce with purchase order
+ Steps to reproduce with purchase order
======================================
There seem to be *no bug* on purchase order:
* create a new purchase order from Delta PC, add a PO line, choose
"Belle-Vue Kriek" as the product, save the draft PO
Expected:
A PO with a total amount of USD 0.25*1.5289+7 = 7.38, with 1 line with
a unit price of 7.38 and an amount of 7.38
Actual: the same.
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1229232
Title:
multi currency + pricelist + discount => completely wrong sale orders
and invoices
Status in OpenERP Addons (modules):
New
Bug description:
Using different currencies with pricelist with the discount on sale
order lines or invoice lines enabled gives completely wrong results.
Instance setup:
* Enable multiple pricelists
* Enable multiple currencies management in the instance
* Enable discount on sale order lines
* Enable purchase pricelists
* Create a new public pricelist in USD, based on the default pricelist with the formula: BasePrice * (1+0.00) + 10
* Create a new purchase price list in USD, based on the standard purchase pricelist with the formula BasePrice * (1+0.00) + 7
* Edit the partner Delta PC: set him as customer, and give him the new Public Pricelist USD as sales pricelist and the new Purchase price list USD as purchase price list
* Edit the Belle-Vue Kriek product, set the cost price to 0.25
Steps to reproduce issue with sale orders
===================================
* Create a new Sale order for Delta PC, add a sale order line, choose
"Belle-Vue Kriek" as the product, save the draft sale order.
Expected:
A sale order with a total amount of USD 0.83*1.5289+10 = 11.27, with 1
line with a unit price of 11.27, a discount of 0% and an amount of
11.27
Actual:
A sale order with a total amount of USD 11.27, with 1 line with a unit
price of 0.83, a discount of -1257.71% and an amount of 11.27
Steps to reproduce issue with customer invoice
==============================================
* Create a new customer invoice for Delta PC, add an invoice line,
choose "Belle-Vue Kriek" as the product, save the draft invoice.
Expected:
A sale order with a total amount of USD 0.83*1.5289+10 = 11.27, with 1
line with a unit price of 11.27, a discount of 0% and an amount of
11.27
Actual:
A sale order with a total amount of EUR 11.27, with 1 line with a unit
price of 0.83, a discount of -1257.71% and an amount of 11.27
(note that in addition to the sale order, the currency is incorrect,
although the amount is correct)
Steps to reproduce issue with supplier invoice
==============================================
* Create a new Supplier invoice for Delta PC, add an invoice line,
choose "Belle-Vue Kriek" as the product, save the draft invoice.
Expected:
A sale order with a total amount of USD 0.25*1.5289+7 = 7.38, with 1
line with a unit price of 7.38, a discount of 0% and an amount of
7.38
Actual:
A sale order with a total amount of EUR 7.38, with 1 line with a unit
price of 0.83, a discount of -789.42% and an amount of 7.38
Steps to reproduce with purchase order
======================================
There seem to be *no bug* on purchase order:
* create a new purchase order from Delta PC, add a PO line, choose
"Belle-Vue Kriek" as the product, save the draft PO
Expected:
A PO with a total amount of USD 0.25*1.5289+7 = 7.38, with 1 line with
a unit price of 7.38 and an amount of 7.38
Actual: the same.
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1229232/+subscriptions
References
