Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032323Openbravo ERP04. Warehouse managementpublic2016-02-23 18:582016-04-08 11:00
malsasua 
AtulOpenbravo 
immediatemajoralways
closedfixed 
20Community Appliance
 
 
vmromanos
Core
Production - QA Approved
2015-08-19
3.0PR15Q4
https://code.openbravo.com/erp/devel/pi/rev/d451a9fb55e553d4c6df0b6c3c57d02c90f52567 [^]
No
0032323: "generate invoice from receipt" button is not working
in goods receipt window, if you try to execute the "generate invoice from receipt" process, error is returned:
null value in column "grosspricestd" violates not-null constraint
. create a new good receipt
. add new line
. process
. click in "generate invoice from receipt"
error is returned:
null value in column "grosspricestd" violates not-null constraint
No tags attached.
depends on backport 00323273.0PR16Q1 closed AtulOpenbravo "generate invoice from receipt" button is not working 
depends on backport 00323283.0PR15Q4.4 closed AtulOpenbravo "generate invoice from receipt" button is not working 
caused by defect 00305043.0PR15Q4 closed AtulOpenbravo "Gross List Price" information is not copied to invoice when using Generate Invoice from Receipt process 
png Issue_32323.png (95,138) 2016-02-24 10:27
https://issues.openbravo.com/file_download.php?file_id=9097&type=bug
png
Issue History
2016-02-23 18:58malsasuaNew Issue
2016-02-23 18:58malsasuaAssigned To => Triage Finance
2016-02-23 18:58malsasuaModules => Core
2016-02-23 18:58malsasuaResolution time => 1456527600
2016-02-23 18:58malsasuaTriggers an Emergency Pack => No
2016-02-23 19:01malsasuaRelationship addedrelated to 0030504
2016-02-23 21:08malsasuaRegression level => Production - Confirmed Stable
2016-02-23 21:08malsasuaRegression introduced in release => 3.0PR15Q4
2016-02-24 10:02AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2016-02-24 10:26psanjuanNote Added: 0084455
2016-02-24 10:27psanjuanFile Added: Issue_32323.png
2016-02-24 13:54AtulOpenbravoNote Added: 0084460
2016-02-24 14:10AtulOpenbravoNote Added: 0084461
2016-02-24 14:12AtulOpenbravoRegression date => 2015-08-19
2016-02-24 14:12AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/d451a9fb55e553d4c6df0b6c3c57d02c90f52567 [^]
2016-02-24 14:23AtulOpenbravoStatusnew => scheduled
2016-02-24 14:35AtulOpenbravoRelationship replacedcaused by 0030504
2016-02-24 15:03psanjuanNote Edited: 0084460bug_revision_view_page.php?bugnote_id=0084460#r11216
2016-02-24 15:07psanjuanNote Edited: 0084460bug_revision_view_page.php?bugnote_id=0084460#r11217
2016-02-25 08:59psanjuanNote Edited: 0084460bug_revision_view_page.php?bugnote_id=0084460#r11223
2016-02-25 09:09psanjuanNote Edited: 0084460bug_revision_view_page.php?bugnote_id=0084460#r11224
2016-02-25 09:15psanjuanNote Edited: 0084460bug_revision_view_page.php?bugnote_id=0084460#r11225
2016-02-25 09:20psanjuanNote Edited: 0084461bug_revision_view_page.php?bugnote_id=0084461#r11227
2016-02-25 09:20psanjuanNote Added: 0084483
2016-02-25 09:22psanjuanRelationship addedrelated to 0032336
2016-02-25 09:22psanjuanNote Edited: 0084483bug_revision_view_page.php?bugnote_id=0084483#r11229
2016-02-25 09:31psanjuanNote Edited: 0084483bug_revision_view_page.php?bugnote_id=0084483#r11230
2016-02-25 09:31psanjuanRelationship deletedrelated to 0032336
2016-02-25 11:26vmromanosRegression levelProduction - Confirmed Stable => Production - QA Approved
2016-02-25 14:02hgbotCheckin
2016-02-25 14:02hgbotNote Added: 0084506
2016-02-25 14:02hgbotStatusscheduled => resolved
2016-02-25 14:02hgbotResolutionopen => fixed
2016-02-25 14:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/85f5f008873a92e5740a131777103d332bb56a27 [^]
2016-02-25 14:03vmromanosReview Assigned To => vmromanos
2016-02-25 14:03vmromanosNote Added: 0084509
2016-02-25 14:03vmromanosStatusresolved => closed
2016-03-02 18:20aferrazNote Added: 0084668
2016-03-17 10:56hudsonbotCheckin
2016-03-17 10:56hudsonbotNote Added: 0085169
2016-04-08 11:00hgbotCheckin
2016-04-08 11:00hgbotNote Added: 0085526

Notes
(0084455)
psanjuan   
2016-02-24 10:26   
Issue verified. See image attached.
(0084460)
AtulOpenbravo   
2016-02-24 13:54   
(edited on: 2016-02-25 09:15)
Test Plan
- Create a new good receipt.
- Add new line, i.e. Product = Cerveza Ale 0.5L, Qty =1
- Complete the receipt.
- Click in "Generate Invoice From Receipt", choose "Tarifa Bebidas Alegres" price list version.
- Check that green message is shown saying that the purchase invoice has been created successfully. Take note of the Document Nº i.e. 100000870
- Go to Purchase Invoice window and check that the purchase invoice created is correct,that is:
Product = Cerveza Ale 0.5L
Qty = 1
Net Unit Price = 1.36
Total Net Amount = 1.36
Tax = Adquisiciones IVA 21%
Total Gross Amount = 1.65

(0084461)
AtulOpenbravo   
2016-02-24 14:10   
(edited on: 2016-02-25 09:20)
Test Plan
- Set "Price Includes Tax" = Yes for price list "Tarifa Bebidas Alegres".
- Create a new good receipt for Business Partner "Bebidas Alegres".
- Add new line, for Product = Cerveza Ale 0.5L, Qty = 1.
- Complete the receipt.
- Click in "Generate Invoice From Receipt".
- Check that a green successful message is shown. Take note of the Document Nº ie. 100000871.
- Go to Purchase Invoice window and check that the invoice is correct, as:
Product = Cerveza Ale 0.5L
Qty = 1
Net Unit price = 1.12 (1.36/1.21)
Tax rate (21%)
Total Net Amount = 1.12
Total Gross Amount = 1.36

(0084483)
psanjuan   
2016-02-25 09:20   
(edited on: 2016-02-25 09:31)
Test Plan above verified.

Issue can be reviewed and closed.

(0084506)
hgbot   
2016-02-25 14:02   
Repository: erp/devel/pi
Changeset: 85f5f008873a92e5740a131777103d332bb56a27
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Feb 24 18:05:08 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/85f5f008873a92e5740a131777103d332bb56a27 [^]

Fixes Issue 32323:"Generate invoice from receipt" button is not working

In case tax not included in price list, gross std price and list price
was set will null value which is not allowed by db table. now they are
initiated to value zero first.

---
M src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
---
(0084509)
vmromanos   
2016-02-25 14:03   
Code review + testing OK
(0084668)
aferraz   
2016-03-02 18:20   
Test case in TestLink: https://testlink.openbravo.com/testlink/linkto.php?tprojectPrefix=Communit&item=testcase&id=Communit-10002 [^]
(0085169)
hudsonbot   
2016-03-17 10:56   
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/b22fb0500156 [^]
Maturity status: Test
(0085526)
hgbot   
2016-04-08 11:00   
Repository: tools/automation/int
Changeset: 1949469fab525e4859bbc15a9d8fb8cd39c9155e
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Mar 03 13:40:40 2016 +0100
URL: http://code.openbravo.com/tools/automation/int/rev/1949469fab525e4859bbc15a9d8fb8cd39c9155e [^]

Related to issue 32323: Added an automated test

---
M src-test/com/openbravo/test/integration/erp/data/procurement/transactions/goodsreceipt/GoodsReceiptLinesData.java
M src-test/com/openbravo/test/integration/erp/data/procurement/transactions/purchaseinvoice/PurchaseInvoiceLinesData.java
M src-test/com/openbravo/test/integration/erp/gui/popups/RequestProcessPopUp.java
M src-test/com/openbravo/test/integration/erp/gui/procurement/transactions/goodsreceipt/GoodsReceiptHeaderTab.java
M src-test/com/openbravo/test/integration/erp/modules/functionalteam/procurement/testsuites/PRO_Regressions/PRO_RegressionSuite.java
M src-test/com/openbravo/test/integration/erp/modules/functionalteam/procurement/testsuites/PRO_Regressions/build.xml
M src-test/com/openbravo/test/integration/erp/testscripts/procurement/transactions/GoodsReceipt.java
A src-test/com/openbravo/test/integration/erp/modules/functionalteam/procurement/testsuites/PRO_Regressions/PRORegression32323.java
---