Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010338Openbravo ERP03. Procurement managementpublic2009-08-19 14:322009-10-06 11:14
networkb 
dalsasua 
urgentminoralways
closedfixed 
5
2.50MP3 
2.50MP7pi 
Core
No
0010338: Goods Receipt whose lines have a product with cost zero are not posted
If you have a Purchase Order with a line whose product has cost zero and you create a Goods Receipt for it and post it, it will not be posted.
1. Go to Procurement Management || Transactions || Purchase Order
2. Go to Procurement Management || Transactions || Purchase Order || Lines and for , at least, one of its lines choose a product whose cost is zero
3. Go to Procurement Management || Transactions || Goods Receipt and "create lines from" previous order.
4. Complete and Post the Goods Receipt (maybe you need to add m_inout table to accounting)
5. Realize that goods receipt has not been posted
No tags attached.
depends on backport 00104782.50MP7 closed dalsasua Goods Receipt whose lines have a product with cost zero are not posted 
depends on backport 00104792.50MP7 closed dalsasua Goods Receipt whose lines have a product with cost zero are not posted 
related to feature request 0010372 new rmorley Not Posted Transaction Report shows entries with zero quantities that never will be posted 
Issue History
2009-08-19 14:32networkbNew Issue
2009-08-19 14:32networkbAssigned To => rafaroda
2009-08-19 14:34networkbProposed Solution updated
2009-08-19 14:34rafarodaNote Added: 0019056
2009-08-19 14:34rafarodaAssigned Torafaroda => dalsasua
2009-08-19 14:34rafarodaPriorityimmediate => high
2009-08-19 14:34rafarodaStatusnew => acknowledged
2009-08-19 14:34rafarodaProposed Solution updated
2009-08-19 14:35networkbAssigned Todalsasua => rafaroda
2009-08-19 14:35networkbPriorityhigh => immediate
2009-08-19 14:35networkbStatusacknowledged => new
2009-08-19 14:35networkbSummaryGoods Receipt lines whose product has cost zero are not posted => Goods Receipt whose lines have a product with cost zero are not posted
2009-08-19 14:35networkbDescription Updated
2009-08-19 14:35networkbProposed Solution updated
2009-08-19 14:40rafarodaAssigned Torafaroda => dalsasua
2009-08-19 14:40rafarodaPriorityimmediate => high
2009-08-19 14:40rafarodaStatusnew => acknowledged
2009-08-20 09:20networkbTarget Version => 2.50MP6
2009-08-21 10:09rafarodaRelationship addedrelated to 0010372
2009-08-26 11:09pnudingNote Added: 0019228
2009-08-26 11:09pnudingPriorityhigh => urgent
2009-09-03 16:54networkbTarget Version2.50MP6 => 2.50MP7
2009-09-03 17:01dalsasuaStatusacknowledged => scheduled
2009-09-03 17:01dalsasuaNote Added: 0019456
2009-09-03 17:01dalsasuafix_in_branch => pi
2009-09-09 20:03dalsasuaNote Edited: 0019456
2009-09-09 20:07hgbotCheckin
2009-09-09 20:07hgbotNote Added: 0019622
2009-09-09 20:07hgbotStatusscheduled => resolved
2009-09-09 20:07hgbotResolutionopen => fixed
2009-09-09 20:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef30f347b1dc3716c22c76b88454220ba6d6fa9d [^]
2009-09-09 20:30hudsonbotCheckin
2009-09-09 20:30hudsonbotNote Added: 0019623
2009-09-09 20:30hudsonbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/ef30f347b1dc3716c22c76b88454220ba6d6fa9d [^] =>
2009-09-09 20:38hudsonbotCheckin
2009-09-09 20:38hudsonbotNote Added: 0019624
2009-09-09 20:45hudsonbotCheckin
2009-09-09 20:45hudsonbotNote Added: 0019625
2009-09-09 20:55hudsonbotCheckin
2009-09-09 20:55hudsonbotNote Added: 0019626
2009-09-09 21:16hudsonbotCheckin
2009-09-09 21:16hudsonbotNote Added: 0019627
2009-09-09 21:44hudsonbotCheckin
2009-09-09 21:44hudsonbotNote Added: 0019635
2009-09-09 23:14hudsonbotCheckin
2009-09-09 23:14hudsonbotNote Added: 0019640
2009-09-10 00:56hudsonbotCheckin
2009-09-10 00:56hudsonbotNote Added: 0019658
2009-09-10 07:54hudsonbotCheckin
2009-09-10 07:54hudsonbotNote Added: 0019663
2009-09-10 09:04hudsonbotCheckin
2009-09-10 09:04hudsonbotNote Added: 0019684
2009-09-10 10:42hudsonbotCheckin
2009-09-10 10:42hudsonbotNote Added: 0019701
2009-09-10 14:38hudsonbotCheckin
2009-09-10 14:38hudsonbotNote Added: 0019734
2009-09-10 16:04hudsonbotCheckin
2009-09-10 16:04hudsonbotNote Added: 0019739
2009-09-10 17:33hudsonbotCheckin
2009-09-10 17:33hudsonbotNote Added: 0019755
2009-09-10 21:17hudsonbotCheckin
2009-09-10 21:17hudsonbotNote Added: 0019762
2009-09-10 23:15hudsonbotCheckin
2009-09-10 23:15hudsonbotNote Added: 0019777
2009-09-11 07:08hudsonbotCheckin
2009-09-11 07:08hudsonbotNote Added: 0019784
2009-09-11 21:17hudsonbotCheckin
2009-09-11 21:17hudsonbotNote Added: 0019824
2009-09-11 23:14hudsonbotCheckin
2009-09-11 23:14hudsonbotNote Added: 0019839
2009-09-12 21:17hudsonbotCheckin
2009-09-12 21:17hudsonbotNote Added: 0019853
2009-09-13 21:17hudsonbotCheckin
2009-09-13 21:17hudsonbotNote Added: 0019866
2009-09-14 11:51hudsonbotCheckin
2009-09-14 11:51hudsonbotNote Added: 0019887
2009-09-14 12:24sureshbabuStatusresolved => closed
2009-09-14 12:24sureshbabuNote Added: 0019899
2009-09-14 12:24sureshbabuFixed in Version => pi
2009-09-14 18:36hudsonbotCheckin
2009-09-14 18:36hudsonbotNote Added: 0019919
2009-09-14 19:57hudsonbotCheckin
2009-09-14 19:57hudsonbotNote Added: 0019940
2009-09-14 21:17hudsonbotCheckin
2009-09-14 21:17hudsonbotNote Added: 0019976
2009-09-14 23:14hudsonbotCheckin
2009-09-14 23:14hudsonbotNote Added: 0019992
2009-09-15 00:00anonymoussf_bug_id0 => 2858895
2009-09-15 12:35hudsonbotCheckin
2009-09-15 12:35hudsonbotNote Added: 0020056
2009-09-29 14:10hgbotCheckin
2009-09-29 14:10hgbotNote Added: 0020455
2009-09-29 14:10hgbotStatusclosed => resolved
2009-09-29 14:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/ef30f347b1dc3716c22c76b88454220ba6d6fa9d [^]
2009-10-06 11:14psarobeStatusresolved => closed
2009-10-06 11:14psarobeNote Added: 0020744

Notes
(0019056)
rafaroda   
2009-08-19 14:34   
David,

Can you please comment on this issue?

Thanks.
(0019228)
pnuding   
2009-08-26 11:09   
Raised to urgent again as discussed for scheduling in next Loc ES sprint
(0019456)
dalsasua   
2009-09-03 17:01   
(edited on: 2009-09-09 20:03)
Hi all,

Cost of products must be different to zero, in normal situations. Application was behaving like this, for the user to notice that amounts to build this entry are taken from the cost of the product. This will be changed, and if the product has a cost set to zero, will proceed with the posting. If no cost is set, the same error will be shown.

Please take into account that it is not possible to post a document with lines with amount zero in debit and credit columns. Because of this, if a good receipt document has got several lines, and at least one of them belongs to a product with cost different to zero, document will be posted. On the other hand, if all the products have got a cost of zero, document will not be posted, as the resultant entry will be just lines with zeros.

Regards.

David Alsasua

(0019622)
hgbot   
2009-09-09 20:07   
Repository: erp/devel/pi
Changeset: ef30f347b1dc3716c22c76b88454220ba6d6fa9d
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Sep 09 20:06:43 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ef30f347b1dc3716c22c76b88454220ba6d6fa9d [^]

Fixes issue 10338: Goods Receipt whose lines
have a product with cost zero are not posted

---
M src/org/openbravo/erpCommon/ad_forms/DocInOut.java
M src/org/openbravo/erpCommon/ad_forms/DocInOut_data.xsql
---
(0019623)
hudsonbot   
2009-09-09 20:30   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/848/ [^]
------
(0019624)
hudsonbot   
2009-09-09 20:38   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-inc-oracle/741/ [^]
------
(0019625)
hudsonbot   
2009-09-09 20:45   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-oracle/337/ [^]
------
(0019626)
hudsonbot   
2009-09-09 20:55   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-full-pgsql/343/ [^]
------
(0019627)
hudsonbot   
2009-09-09 21:16   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/168/ [^]
------
(0019635)
hudsonbot   
2009-09-09 21:44   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/85/ [^]
------
(0019640)
hudsonbot   
2009-09-09 23:14   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/135/ [^]
------
(0019658)
hudsonbot   
2009-09-10 00:56   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/86/ [^]
------
(0019663)
hudsonbot   
2009-09-10 07:54   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/169/ [^]
------
(0019684)
hudsonbot   
2009-09-10 09:04   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/87/ [^]
------
(0019701)
hudsonbot   
2009-09-10 10:42   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-smoke-test/59/ [^]
------
(0019734)
hudsonbot   
2009-09-10 14:38   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/88/ [^]
------
(0019739)
hudsonbot   
2009-09-10 16:04   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/170/ [^]
------
(0019755)
hudsonbot   
2009-09-10 17:33   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-installation-test/89/ [^]
------
(0019762)
hudsonbot   
2009-09-10 21:17   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/171/ [^]
------
(0019777)
hudsonbot   
2009-09-10 23:15   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/136/ [^]
------
(0019784)
hudsonbot   
2009-09-11 07:08   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/172/ [^]
------
(0019824)
hudsonbot   
2009-09-11 21:17   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/173/ [^]
------
(0019839)
hudsonbot   
2009-09-11 23:14   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/137/ [^]
------
(0019853)
hudsonbot   
2009-09-12 21:17   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/174/ [^]
------
(0019866)
hudsonbot   
2009-09-13 21:17   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/175/ [^]
------
(0019887)
hudsonbot   
2009-09-14 11:51   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/138/ [^]
------
(0019899)
sureshbabu   
2009-09-14 12:24   
Tested both the scenarios, after changing the cost =0 in purchasing tab

1) have one line item with cost =0 , system throws error

2) Goods receipt having more than one line item with one line item with cost amount =0, system able to post the entries.
(0019919)
hudsonbot   
2009-09-14 18:36   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/176/ [^]
------
(0019940)
hudsonbot   
2009-09-14 19:57   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/177/ [^]
------
(0019976)
hudsonbot   
2009-09-14 21:17   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/178/ [^]
------
(0019992)
hudsonbot   
2009-09-14 23:14   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/139/ [^]
------
(0020056)
hudsonbot   
2009-09-15 12:35   
Fixed Issue 10338

------
Integrated in http://builds.openbravo.com/job/erp_devel_pi-pgsql-db-full-consistency-test/179/ [^]
------
(0020455)
hgbot   
2009-09-29 14:10   
Repository: erp/devel/pi-pageddatagrid
Changeset: ef30f347b1dc3716c22c76b88454220ba6d6fa9d
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Sep 09 20:06:43 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/ef30f347b1dc3716c22c76b88454220ba6d6fa9d [^]

Fixes issue 10338: Goods Receipt whose lines
have a product with cost zero are not posted

---
M src/org/openbravo/erpCommon/ad_forms/DocInOut.java
M src/org/openbravo/erpCommon/ad_forms/DocInOut_data.xsql
---
(0020744)
psarobe   
2009-10-06 11:14   
Closed again because hudson has reopened without no reason