Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021195Openbravo ERP03. Procurement managementpublic2012-07-24 17:032012-08-09 13:06
emartinez 
mirurita 
normalminoralways
closedfixed 
5
 
3.0MP14 
Core
No
0021195: "create invoice from receipt" in goods receipt window when prices include taxes
When creating an invoice from a goods receipt that comes from a purchase order with prices including taxes, the invoice generated has gross field to zero.
1) Go to purchase order and generate a register with 1 line whose pricelist include taxes
2) Generate the goods receipt copying lines from the purchase order
3) Then click on the button "generate invoice" from receipt header
4) Go to the generated invoice and see gross amount in header is not zero, and gross fields in the lines are also zero
No tags attached.
related to defect 0035428 closed aferraz Do not calculate Net Price and Net Amount outside triggers when creating new Order/Invoice with Price Including Taxes 
Issue History
2012-07-24 17:03emartinezNew Issue
2012-07-24 17:03emartinezAssigned To => mirurita
2012-07-24 17:03emartinezModules => Core
2012-07-26 13:38miruritaNote Added: 0050903
2012-07-26 14:03hgbotCheckin
2012-07-26 14:03hgbotNote Added: 0050904
2012-07-26 14:03hgbotStatusnew => resolved
2012-07-26 14:03hgbotResolutionopen => fixed
2012-07-26 14:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/650209920d11e55c7e44991818d0bd6a878ea9c3 [^]
2012-07-27 02:18hudsonbotCheckin
2012-07-27 02:18hudsonbotNote Added: 0050920
2012-07-30 13:53hgbotCheckin
2012-07-30 13:53hgbotNote Added: 0050987
2012-07-30 13:56gorkaionNote Added: 0050988
2012-07-30 13:56gorkaionStatusresolved => closed
2012-07-30 13:56gorkaionFixed in Version => 3.0MP14
2012-08-09 13:06hudsonbotCheckin
2012-08-09 13:06hudsonbotNote Added: 0051196
2017-03-06 18:51aferrazRelationship addedrelated to 0035428

Notes
(0050903)
mirurita   
2012-07-26 13:38   
Testing Plan I (using PIT)
1) Set "Tarifa Bebidas Alegres" as price includes taxes
2) Add "Zumo de Piña 0,5L" to "Tarifa Bebidas Alegres"
   + Unit Price: 100
   + List Price 101
3) Add "Zumo de Piña 0,5L" to "Tarifa Refrescos Naturales"
   + Unit Price: 100
   + List Price 101
4) Create a purchase order for "Bebidas Alegres, S.L."
   + Price List: Tarifa Bebidas Alegres
   + Line: "Zumo de Piña 0,5L", quantity = 2
5) Generate the goods receipt copying lines from the purchase order
6) Click on "Generate Invoice from Receipt" from receipt header
7) Go to the generated invoice and check the amounts are inherited from the purchase order.
   + Total Gross Amount: 200
   + Total Net Amount: 169.5
   + Net Unit Price: 84.75
   + Gross Unit Price: 100
   + Line Net Amount: 169.50
   + Line Gross Amount: 200

Testing Plan II (not using PIT)
1) Create a purchase order for "Bebidas Alegres, S.L."
   + Price List: Tarifa Refrescos Naturales
   + Line: "Zumo de Piña 0,5L", quantity = 5
5) Generate the goods receipt copying lines from the purchase order
6) Click on "Generate Invoice from Receipt" from receipt header
7) Go to the generated invoice and check the amounts are inherited from the purchase order.
   + Total Gross Amount: 590
   + Total Net Amount: 500
   + Net Unit Price: 100
   + Gross Unit Price: 0 (not visible)
   + Line Net Amount: 500
   + Line Gross Amount: 0 (not visible)

Testing Plan III
1) Create a Goods Receipt for "Bebidas Alegres, S.L."
   + Line: Zumo de Piña 0,5L - quantity: 3
2) Click on "Generate Invoice from Receipt" from receipt header
3) Select "Tarifa Bebidas Alegres" Price List Version
4) Go to the generated invoice and check the amounts are inherited from the purchase order.
   + Total Gross Amount: 300
   + Total Net Amount: 254.25
   + Quantity: 3
   + Net Unit Price: 84.75
   + Gross Unit Price: 100
   + Line Net Amount: 254.25
   + Line Gross Amount: 300

Testing Plan IV
1) Create a Goods Receipt for "Bebidas Alegres, S.L."
   + Line: Zumo de Piña 0,5L - quantity: 3
2) Click on "Generate Invoice from Receipt" from receipt header
3) Select "Tarifa Refrescos Naturales" Price List Version
4) Go to the generated invoice and check the amounts are inherited from the purchase order.
   + Total Gross Amount: 354
   + Total Net Amount: 300
   + Quantity: 3
   + Net Unit Price: 100
   + Gross Unit Price: 0 (not visible)
   + Line Net Amount: 300
   + Line Gross Amount: 0 (not visible)
(0050904)
hgbot   
2012-07-26 14:03   
Repository: erp/devel/pi
Changeset: 650209920d11e55c7e44991818d0bd6a878ea9c3
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Jul 26 14:01:54 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/650209920d11e55c7e44991818d0bd6a878ea9c3 [^]

Fixes issue 21195: create invoice from receipt in goods receipt window when PIT

---
M src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
---
(0050920)
hudsonbot   
2012-07-27 02:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4cfe6f4cd84a [^]

Maturity status: Test
(0050987)
hgbot   
2012-07-30 13:53   
Repository: erp/devel/pi
Changeset: 96b2297ea85ba57f86b1389de447e89cf2b2e10f
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Mon Jul 30 13:51:36 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/96b2297ea85ba57f86b1389de447e89cf2b2e10f [^]

Related to issue 21195.Use std precision for amounts.

---
M src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
---
(0050988)
gorkaion   
2012-07-30 13:56   
code reviewed and tested fine
(0051196)
hudsonbot   
2012-08-09 13:06   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ef9a070edd19 [^]

Maturity status: Test