details: https://code.openbravo.com/erp/devel/pi/rev/704736d841a9
changeset: 32622:704736d841a9
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Tue Sep 05 18:46:27 2017 +0200
summary: Fixes Issue 36796. Check that the Inventory Status of the Bin has the
Available flag checked for Goods Shipments and Return To Vendor Shipments
(outgoing warehouse transactions in the M_INOUT_POST)
diffstat:
src-db/database/model/functions/M_INOUT_POST.xml | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diffs (15 lines):
diff -r 269bf16d019e -r 704736d841a9
src-db/database/model/functions/M_INOUT_POST.xml
--- a/src-db/database/model/functions/M_INOUT_POST.xml Tue Sep 05 18:37:33
2017 +0200
+++ b/src-db/database/model/functions/M_INOUT_POST.xml Tue Sep 05 18:46:27
2017 +0200
@@ -239,7 +239,10 @@
JOIN M_InventoryStatus INVS ON
(INVS.M_InventoryStatus_ID = L.M_InventoryStatus_ID)
WHERE I.M_INOUT_ID=v_Record_ID
AND INVS.Available = 'N'
- AND I.issotrx = 'Y'
+ -- Check only Outgoing documents (Goods Shipment
and Return to Vendor Shipment)
+ AND ((I.issotrx = 'Y' AND v_isreturndoctype = 'N')
+ OR
+ (I.issotrx = 'N' AND v_isreturndoctype =
'Y'))
ORDER BY M.line
) LOOP
v_Message_NotAvail:=v_Message_NotAvail||Cur_Lines.line||', ';
------------------------------------------------------------------------------
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
