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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018921
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2011-10-28 12:582011-11-23 13:52
ReportermaiteView Statuspublic 
Assigned Tojecharri 
PriorityurgentResolutionfixedFixed in Version3.0MP6
StatusclosedFix in branchFixed in SCM revisiona86c37b5f7b0
ProjectionnoneETAnoneTarget Version3.0MP6
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018921: Error in organization parameter used in function ma_workeffort_validate

DescriptionError in organization parameter used in function ma_workeffort_validate.
This function is using variable "v_Org_ID" when calling to MA_GLOBALUSE_DISTRIBUTE and M_Check_Stock procedures, and it should be using variable "v_AD_Org_ID" (which is document's organization)
Steps To Reproduce0. Loggued with Openbravo and * as default organization
0. Define Activity in Production Management || Setup || Activity || Activity
1. In Client | Information window, define your client to "NOT allow negative stock"
2. Create physical inventory for "Paint - Verde" and storage bin "ML1" and set quantity=0. Process.
2. Create Goods movement and move Paint Rosa, from ML1 to ML4
3. Create ProcessPlan for Main organization. Add Version for Main org and starting date= 28-10-2011 and ending date=30-10-2011. Add Operation for Main org. Add Product "Stone Slab" as P+ and quantity=6
4. Create Work Requirement for Main organization and process plan created. Quantity=0 and dates=28-10-2011. Add Operation for Main org and Quantity=1 and GlobalUser=checked. Add Product "Stone Slab" as P+ and movement quantity=6; Add other Product "Paint" as P- and movement quantity=6
5. Create Work Effort for 28-10-2011 and time=00.00.00 and Main org; Add Production Run for Main or and Completed Quantity =1. Run "Create Standards".
6. Go to "Global Use" tab, line for Paint P- has been added. Set Storage bin=ML1 and quantity=6
7. Got to Work Effort tab and run "Validate Work effort"
Process finish successfully although you don't have stock for Paint in ML1. Probem is that ma_workeffort_validate is using v_Org_ID= * organization to verify stock instead of v_AD_Org_ID=Main organization
Proposed SolutionChange ma_workeffort_validate funtion:
PERFORM MA_GLOBALUSE_DISTRIBUTE(v_Client_ID, v_Org_ID, v_User_ID, v_Record_ID) ;
should be
PERFORM MA_GLOBALUSE_DISTRIBUTE(v_Client_ID, v_ad_Org_ID, v_User_ID, v_Record_ID);
and
SELECT * INTO v_Result, v_Message FROM M_Check_Stock(CUR_PL_Post.M_Product_ID, v_Client_ID, v_Org_ID) ;
should be
SELECT * INTO v_Result, v_Message FROM M_Check_Stock(CUR_PL_Post.M_Product_ID, v_Client_ID, v_ad_Org_ID) ;
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00189222.50MP36 closedjecharri Error in organization parameter used in function ma_workeffort_validate 

-  Notes
(0042678)
hgbot (developer)
2011-11-08 17:53

 Repository: erp/stable/2.50
Changeset: 83ac2b6b7d2ea8291d40e2b721f20312369cbd83
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Nov 08 10:15:53 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/83ac2b6b7d2ea8291d40e2b721f20312369cbd83 [^]

Fixes issue 18921: Error in organization parameter used in function ma_workeffort_validate

---
M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
---
(0042944)
hgbot (developer)
2011-11-17 16:34

 Repository: erp/devel/pi
Changeset: a86c37b5f7b04ca31b080ba07c2cef0acb64f09a
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Nov 17 16:33:26 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a86c37b5f7b04ca31b080ba07c2cef0acb64f09a [^]

Fixes issue 18921: Error in organization parameter used in function ma_workeffort_validate

---
M src-db/database/model/functions/MA_WORKEFFORT_VALIDATE.xml
---
(0042946)
jecharri (developer)
2011-11-17 16:45

 Test cases:
with steps to reproduce I think that is enought
(0043047)
hudsonbot (developer)
2011-11-22 03:50

 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/ebd713dfe507 [^]

Maturity status: Test
(0043106)
maite (developer)
2011-11-23 13:52

 verified

- Issue History
Date Modified Username Field Change
2011-10-28 12:58 maite New Issue
2011-10-28 12:58 maite Assigned To => jonalegriaesarte
2011-10-28 12:58 maite Modules => Core
2011-10-28 12:59 maite Status new => scheduled
2011-10-28 12:59 maite fix_in_branch => pi
2011-10-28 12:59 maite Target Version 2.50MP36 => 3.0MP6
2011-10-28 12:59 maite fix_in_branch pi =>
2011-11-08 17:53 hgbot Checkin
2011-11-08 17:53 hgbot Note Added: 0042678
2011-11-08 17:53 hgbot Status scheduled => resolved
2011-11-08 17:53 hgbot Resolution open => fixed
2011-11-08 17:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/83ac2b6b7d2ea8291d40e2b721f20312369cbd83 [^]
2011-11-08 18:07 jecharri Status resolved => new
2011-11-08 18:07 jecharri Resolution fixed => open
2011-11-08 18:09 jecharri Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/83ac2b6b7d2ea8291d40e2b721f20312369cbd83 [^] =>
2011-11-17 16:15 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2011-11-17 16:34 hgbot Checkin
2011-11-17 16:34 hgbot Note Added: 0042944
2011-11-17 16:34 hgbot Status new => resolved
2011-11-17 16:34 hgbot Resolution open => fixed
2011-11-17 16:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a86c37b5f7b04ca31b080ba07c2cef0acb64f09a [^]
2011-11-17 16:45 jecharri Note Added: 0042946
2011-11-22 03:50 hudsonbot Checkin
2011-11-22 03:50 hudsonbot Note Added: 0043047
2011-11-23 13:52 maite Note Added: 0043106
2011-11-23 13:52 maite Status resolved => closed
2011-11-23 13:52 maite Fixed in Version => 3.0MP6

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker