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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012758
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajorhave not tried2010-03-22 12:432010-05-20 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toharikrishnan 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncb7049cc0543
ProjectionnoneETAnoneTarget Version2.50MP17
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

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

DescriptionWorking 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00126192.50MP14 closedadrianromero Error when use 'Validate Work Effort' 

-  Notes
(0026831)
hgbot (developer)
2010-05-01 08:46

 Repository: erp/devel/pi
Changeset: cb7049cc054328459aec708756fe826841187353
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Sat May 01 12:15:26 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/cb7049cc054328459aec708756fe826841187353 [^]

Fixes Issue 12758: Exception executing 'MA_PRODUCTIONRUN_STANDARD\" when working with negative stocks.

---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
(0026832)
harikrishnan (reporter)
2010-05-01 08:51

 * 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.
(0027469)
hudsonbot (developer)
2010-05-18 21:43

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/cb7049cc0543 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]
(0027538)
arunkumar (reporter)
2010-05-19 07:43

 Tested working fine

- Issue History
Date Modified Username Field Change
2010-03-22 12:43 adrianromero New Issue
2010-03-22 12:43 adrianromero Assigned To => adrianromero
2010-03-22 12:44 adrianromero Relationship added related to 0012619
2010-03-23 10:59 adrianromero Status new => scheduled
2010-03-23 10:59 adrianromero fix_in_branch => pi
2010-03-23 11:00 adrianromero Target Version => 2.50MP15
2010-03-23 11:00 adrianromero fix_in_branch pi =>
2010-05-01 08:43 harikrishnan Assigned To adrianromero => harikrishnan
2010-05-01 08:46 hgbot Checkin
2010-05-01 08:46 hgbot Note Added: 0026831
2010-05-01 08:46 hgbot Status scheduled => resolved
2010-05-01 08:46 hgbot Resolution open => fixed
2010-05-01 08:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cb7049cc054328459aec708756fe826841187353 [^]
2010-05-01 08:51 harikrishnan Note Added: 0026832
2010-05-17 09:47 psarobe Steps to Reproduce Updated View Revisions
2010-05-18 12:12 gorka_gil Target Version 2.50MP15 => 2.50MP17
2010-05-18 21:43 hudsonbot Checkin
2010-05-18 21:43 hudsonbot Note Added: 0027469
2010-05-19 07:43 arunkumar Note Added: 0027538
2010-05-19 07:43 arunkumar Status resolved => closed
2010-05-20 00:00 anonymous sf_bug_id 0 => 3004337

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker