Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018464
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2011-09-08 08:462011-11-02 12:40
ReporteregoitzView Statuspublic 
Assigned Tojecharri 
PriorityurgentResolutionfixedFixed in Version3.0MP5
StatusclosedFix in branchFixed in SCM revisionc2133a701c72
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018464: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0041330)
psanjuan (manager)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2011-11-02 12:40

verified

- Issue History
Date Modified Username Field Change
2011-09-08 08:46 egoitz New Issue
2011-09-08 08:46 egoitz Assigned To => jonalegriaesarte
2011-09-08 08:46 egoitz Modules => Core
2011-09-15 11:49 jonalegriaesarte Severity major => minor
2011-09-15 11:49 jonalegriaesarte Target Version 3.0MP3 => 3.0MP4
2011-09-27 09:11 rafademiguel Issue Monitored: rafademiguel
2011-09-27 18:42 psanjuan Note Added: 0041330
2011-09-28 12:51 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2011-09-30 10:30 jonalegriaesarte Target Version 3.0MP4 => 3.0MP5
2011-10-04 11:42 jecharri Resolution time => 1318888800
2011-10-18 17:32 hgbot Checkin
2011-10-18 17:32 hgbot Note Added: 0041909
2011-10-18 17:32 hgbot Status new => resolved
2011-10-18 17:32 hgbot Resolution open => fixed
2011-10-18 17:32 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2133a701c723bb6fe8fb4545b9e3288b34f4867 [^]
2011-10-19 11:06 hgbot Checkin
2011-10-19 11:06 hgbot Note Added: 0041924
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042014
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042020
2011-11-02 12:40 egoitz Note Added: 0042443
2011-11-02 12:40 egoitz Status resolved => closed
2011-11-02 12:40 egoitz Fixed in Version => 3.0MP5


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker