details: https://code.openbravo.com/erp/devel/pi/rev/510cb7a074ae
changeset: 19787:510cb7a074ae
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Fri Feb 22 14:31:17 2013 +0100
summary: Fixes issue 23147: Function m_inout_create is not taking into
account the storage bin priority
diffstat:
src-db/database/model/functions/M_INOUT_CREATE.xml | 12 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
diffs (24 lines):
diff -r 60f6ae5c306d -r 510cb7a074ae
src-db/database/model/functions/M_INOUT_CREATE.xml
--- a/src-db/database/model/functions/M_INOUT_CREATE.xml Fri Feb 22
14:04:03 2013 +0100
+++ b/src-db/database/model/functions/M_INOUT_CREATE.xml Fri Feb 22
14:31:17 2013 +0100
@@ -581,11 +581,17 @@
ELSE
v_ActualQty:=NULL;
END IF;
- SELECT MIN(M_LOCATOR_ID) INTO v_Locator_ID
+
+ SELECT MIN(M_LOCATOR_ID)
+ INTO v_Locator_ID
FROM M_LOCATOR
WHERE M_WAREHOUSE_ID=ol.M_Warehouse_ID
- AND M_LOCATOR.ISACTIVE = 'Y';
- --
+ AND M_LOCATOR.ISACTIVE = 'Y'
+ AND priorityno = (SELECT min(priorityno)
+ FROM M_LOCATOR
+ WHERE M_WAREHOUSE_ID=ol.M_Warehouse_ID
+ AND M_LOCATOR.ISACTIVE = 'Y');
+
DBMS_OUTPUT.PUT_LINE(' Line ' || ol.Line || ' Qty=' ||
v_LocatorQty) ;
v_ResultStr:='CreateInOutLine';
INSERT INTO M_INOUTLINE
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
