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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021585
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementcriticalalways2012-09-10 10:582012-09-26 17:31
ReporteregoitzView Statuspublic 
Assigned ToioritzCia 
PriorityimmediateResolutionfixedFixed in Version3.0MP15
StatusclosedFix in branchpiFixed in SCM revision1b6fa27a5aa4
ProjectionnoneETAnoneTarget Version3.0MP15
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP12SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression levelProduction - QA Approved
Regression date2012-05-09
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/8b2d0f4ae3fe [^]
Triggers an Emergency Packyes
Summary

0021585: Not possible to complete some good shipment susing a product whose name is longer than 40 characters

DescriptionNot possible to complete somegood shipments using a product whose name is longer than 40 characters
Steps To Reproduce-Define a product with a name with more than 40 characters and under some concrete conditions it can not be completed.

SEe that line on the m_inout_post
 SELECT name INTO v_ProductName FROM M_Product WHERE M_Product_id = Cur_InOutLine.M_Product_ID;

v_ProductName is defined with length 40 and m_product.name column has lenght 60.
Proposed SolutionModify the variable v_ProductName to at leaset 60 characters.

For the cases where the client has increase the lenght to a higher value that solution won't work so a trunc could be usefull.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00202803.0MP12 closedioritzCia Insufficient stock message needs to be improved 

-  Notes
(0051955)
hgbot (developer)
2012-09-10 12:53

Repository: erp/devel/pi
Changeset: f81066133c89f108434089a156458cb12f8984b7
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Sep 10 12:49:12 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^]

Fixes issue 21585: Not possible to complete some good shipment
using a product whose name is longer than 40 characters.

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0051956)
ioritzCia (developer)
2012-09-10 12:54

Testing plan:

- Go to physical inventory and create one.
- In the lines set the product quentity below the one you are going to request. Take care of the warehouse and the bin, they must be the same to be used later.
- Process it.
- Go to product and change the name to be longer than 40 characters.
- Go to Goods Shipment and create one for the product, warehouse and bin previously told.
- Complete it. The message appears.
(0051957)
ioritzCia (developer)
2012-09-10 13:16

The regression affects from 3.0MP12 to 3.0MP15
(0051976)
egoitz (developer)
2012-09-10 18:21

verified with the testing plan
(0052658)
hgbot (developer)
2012-09-26 17:15

Repository: erp/devel/pi
Changeset: 1b6fa27a5aa452adbe3448e2748fbafcb01d5291
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Sep 10 12:49:12 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1b6fa27a5aa452adbe3448e2748fbafcb01d5291 [^]

Fixes issue 21585: Not possible to complete some good shipment
using a product whose name is longer than 40 characters.

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0052721)
hudsonbot (developer)
2012-09-26 17: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/b780e90c6452 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-09-10 10:58 egoitz New Issue
2012-09-10 10:58 egoitz Assigned To => dmiguelez
2012-09-10 10:58 egoitz Modules => Core
2012-09-10 11:00 egoitz Priority urgent => immediate
2012-09-10 11:29 egoitz Assigned To dmiguelez => ioritzCia
2012-09-10 11:32 shuehner Issue Monitored: shuehner
2012-09-10 12:13 egoitz Regression level => Production - Confirmed Stable
2012-09-10 12:13 egoitz Regression date => 2012-05-09
2012-09-10 12:13 egoitz Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/8b2d0f4ae3fe [^]
2012-09-10 12:17 egoitz Regression level Production - Confirmed Stable => Production - QA Approved
2012-09-10 12:49 ioritzCia Relationship added related to 0020280
2012-09-10 12:53 hgbot Checkin
2012-09-10 12:53 hgbot Note Added: 0051955
2012-09-10 12:53 hgbot Status new => resolved
2012-09-10 12:53 hgbot Resolution open => fixed
2012-09-10 12:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^]
2012-09-10 12:54 ioritzCia Note Added: 0051956
2012-09-10 12:54 ioritzCia Status resolved => new
2012-09-10 12:54 ioritzCia Resolution fixed => open
2012-09-10 12:54 ioritzCia Status new => scheduled
2012-09-10 12:54 ioritzCia fix_in_branch => pi
2012-09-10 12:55 ioritzCia Status scheduled => resolved
2012-09-10 12:55 ioritzCia Resolution open => fixed
2012-09-10 13:15 ioritzCia Status resolved => new
2012-09-10 13:15 ioritzCia Resolution fixed => open
2012-09-10 13:16 ioritzCia Note Added: 0051957
2012-09-10 13:16 ioritzCia version 3.0MP14 => 3.0MP12
2012-09-10 13:16 ioritzCia fix_in_branch pi =>
2012-09-10 13:16 ioritzCia Status new => scheduled
2012-09-10 13:16 ioritzCia fix_in_branch => pi
2012-09-10 13:17 ioritzCia Status scheduled => resolved
2012-09-10 13:17 ioritzCia Resolution open => fixed
2012-09-10 18:21 egoitz Closed by => egoitz
2012-09-10 18:21 egoitz Note Added: 0051976
2012-09-10 18:21 egoitz Status resolved => closed
2012-09-10 18:21 egoitz Fixed in Version => 3.0MP15
2012-09-26 17:15 hgbot Checkin
2012-09-26 17:15 hgbot Note Added: 0052658
2012-09-26 17:15 hgbot Status closed => resolved
2012-09-26 17:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f81066133c89f108434089a156458cb12f8984b7 [^] => http://code.openbravo.com/erp/devel/pi/rev/1b6fa27a5aa452adbe3448e2748fbafcb01d5291 [^]
2012-09-26 17:18 hudsonbot Checkin
2012-09-26 17:18 hudsonbot Note Added: 0052721
2012-09-26 17:31 gorka_gil Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker