0018922: Error in organization parameter used in function ma_workeffort_validate

Description

Error 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 Reproduce

0. 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 Solution

Change 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) ;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0018921

3.0MP6

closed

jecharri

Error in organization parameter used in function ma_workeffort_validate

Notes
(0042717) maite (viewer) 2011-11-10 10:01	verified

Issue History
Date Modified	Username	Field	Change
2011-10-28 12:59	maite	Type	defect => backport
2011-10-28 12:59	maite	fix_in_branch	=> 2.50
2011-10-28 12:59	maite	Issue Monitored: networkb
2011-11-03 15:31	jecharri	Assigned To	jonalegriaesarte => jecharri
2011-11-08 18:10	jecharri	Status	scheduled => resolved
2011-11-08 18:10	jecharri	Fixed in Version	=> 2.50MP36
2011-11-08 18:10	jecharri	Fixed in SCM revision	=> https://code.openbravo.com/erp/stable/2.50/rev/83ac2b6b7d2ea8291d40e2b721f20312369cbd83 [^]
2011-11-08 18:10	jecharri	Resolution	open => fixed
2011-11-10 10:01	maite	Note Added: 0042717
2011-11-10 10:01	maite	Status	resolved => closed