0012758: Exception executing 'MA_PRODUCTIONRUN_STANDARD" when working with negative stocks

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0012758

Openbravo ERP

05. Production management

public

2010-03-22 12:43

2010-05-20 00:00

Reporter

adrianromero

Assigned To

harikrishnan

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

2.50MP17

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0012758: Exception executing 'MA_PRODUCTIONRUN_STANDARD" when working with negative stocks

Description

Working allowing negative stocks can raise an issue in the PL function "ma_productionrun_standard". In this function a "notenoughstocked" error is raised in line 340:

            IF (v_QtyAcumulated < v_DoneQuantity*Cur_WRPUsed.MovementQty) THEN
              v_Message := '@NotEnoughStocked@: ' || Cur_WRPUsed.pname;
            RAISE_APPLICATION_ERROR(-20000, v_Message);
            END IF;

In this block, instead or raising one exception it has to be checked if it is allowed in the client negative stock and if it is allowed then execute an extra insertion taking product stock from no matter what warehouse and no matter what attributes etc. When inserting this product stock info it also has to be checked the var "v_GlobalUse" to know if whether has to be inserted into the table "ma_global_use or in the "m_production line". And if it is not allowed negative stock then raise the exception.

Something similar to the previous logic is done in the function "m_inout_create" you can use as an example in the lines 466- .

Steps To Reproduce

* Testing of the issue:

To test the issue, follow the steps in the issue 12619 bugnotes.Test it two scenario one with set in the client Allow Negative=true and other one with false.

* Explanation of the changeset that fixes the issue:
The changeset that fix the issue consist of the insert statement in globaluse table and production line table if the client has set the allow negative stock =true.

* Other areas affected by the changeset:
No other areas are affected because apart from create standards button no other places this procedure is called.

Proposed Solution

Additional Information