details: https://code.openbravo.com/erp/devel/pi/rev/d66d496bf117 changeset: 32588:d66d496bf117 user: Mark <markmm82 <at> gmail.com> date: Thu Aug 24 13:14:38 2017 -0400 summary: Fixes issue 36681: Insufficient stock in Create Standards Process of Work Effort
The problem was that in M_GET_STOCK_PARAM function v_Quantity variable does not accept decimals and when quantity is decreased on iterations decimals are ignored and the next records from M_STOCK_PROPOSED table are deleted. To fix that, the v_Quantity variable has been declared as NUMBER to accept decimals. diffstat: src-db/database/model/functions/M_GET_STOCK_PARAM.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diffs (12 lines): diff -r 73827432edb3 -r d66d496bf117 src-db/database/model/functions/M_GET_STOCK_PARAM.xml --- a/src-db/database/model/functions/M_GET_STOCK_PARAM.xml Fri Aug 25 10:06:32 2017 +0200 +++ b/src-db/database/model/functions/M_GET_STOCK_PARAM.xml Thu Aug 24 13:14:38 2017 -0400 @@ -104,7 +104,7 @@ cur_allocated RECORD; -- Parameter Variables - v_Quantity NUMBER(10); + v_Quantity NUMBER; v_ProductID VARCHAR2(32); v_LocatorID VARCHAR2(32); v_WarehouseID VARCHAR2(32) ; ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
