Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018464Openbravo ERP03. Procurement managementpublic2011-09-08 08:462011-11-02 12:40
Reporteregoitz 
Assigned Tojecharri 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP2 
Target Version3.0MP5Fixed in Version3.0MP5 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018464: Not possible to create a goods receipt for a product that is not stocked
DescriptionNot possible to create a goods receipt for a product that is not stocked.
On the product selector only products that are on the warehouse with the attribue are shonw, so you can not enter a new product if it has alreday an instance on the warehoulse.
Steps To Reproduce-Go to good receipt window and create a header
-go to the lines
-Ttry to select beer product.
*See that only is available to select the ale beer with atribute, but if you want a new entry of the product you can not select the product without attribute.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-08 08:46egoitzNew Issue
2011-09-08 08:46egoitzAssigned To => jonalegriaesarte
2011-09-08 08:46egoitzModules => Core
2011-09-15 11:49jonalegriaesarteSeveritymajor => minor
2011-09-15 11:49jonalegriaesarteTarget Version3.0MP3 => 3.0MP4
2011-09-27 09:11rafademiguelIssue Monitored: rafademiguel
2011-09-27 18:42psanjuanNote Added: 0041330
2011-09-28 12:51jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2011-09-30 10:30jonalegriaesarteTarget Version3.0MP4 => 3.0MP5
2011-10-04 11:42jecharriResolution time => 1318888800
2011-10-18 17:32hgbotCheckin
2011-10-18 17:32hgbotNote Added: 0041909
2011-10-18 17:32hgbotStatusnew => resolved
2011-10-18 17:32hgbotResolutionopen => fixed
2011-10-18 17:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2133a701c723bb6fe8fb4545b9e3288b34f4867 [^]
2011-10-19 11:06hgbotCheckin
2011-10-19 11:06hgbotNote Added: 0041924
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042014
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042020
2011-11-02 12:40egoitzNote Added: 0042443
2011-11-02 12:40egoitzStatusresolved => closed
2011-11-02 12:40egoitzFixed in Version => 3.0MP5

Notes
(0041330)
psanjuan   
2011-09-27 18:42   
I would suggest not to use the field/literal "Stocked" as this is the product field "Stocked"; but another one named "With Stock" (as in 2.50)

By default the system should show whatever kind of item with its stock information, which means, "With Stock" = YES
but the end-user should be able to change that to "With Stock" = NO. In that case the system will show all the items without stock information.

"With Stock" here does not mean if an item has stock available or not but the stock information is shown or not.
(0041909)
hgbot   
2011-10-18 17:32   
Repository: erp/devel/pi
Changeset: c2133a701c723bb6fe8fb4545b9e3288b34f4867
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Oct 18 17:31:40 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c2133a701c723bb6fe8fb4545b9e3288b34f4867 [^]

Fixes issue 18464: Not possible to create a goods receipt for a product that is not stocked.
The problem was that the previos query was working correctly but it has a performance problem because the UNION sql statement spent much time sorting and trying to
find some duplicate rows. So I change UNION to UNION ALL is becasue both queries return different rows every time.
The column stocked is going to be different.

---
M src-db/database/model/views/M_PRODUCT_STOCK_V.xml
---
(0041924)
hgbot   
2011-10-19 11:06   
Repository: erp/devel/pi
Changeset: 51d554721fb7fd3025751ed5698784536a0c7f90
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Oct 19 11:03:59 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/51d554721fb7fd3025751ed5698784536a0c7f90 [^]

issue 18464: Not possible to create a goods receipt for a product that is not stocked.
Properly exported now

---
M src-db/database/model/views/M_PRODUCT_STOCK_V.xml
---
(0042014)
hudsonbot   
2011-10-23 13:42   
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/35bf0a7aa166 [^]

Maturity status: Test
(0042020)
hudsonbot   
2011-10-23 13:42   
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/35bf0a7aa166 [^]

Maturity status: Test
(0042443)
egoitz   
2011-11-02 12:40   
verified