0018921: Error in organization parameter used in function ma_workeffort_validate

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0018921

Openbravo ERP

05. Production management

public

2011-10-28 12:58

2011-11-23 13:52

Reporter

maite

Assigned To

jecharri

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP6

Fixed in Version

3.0MP6

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

13067

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0018921: 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) ;

Additional Information