From 35883e9db36b24b8d5494b9dbf7b452486d1cdb7 Mon Sep 17 00:00:00 2001 From: garyhgohoos Date: Tue, 10 Jun 2014 10:50:49 -0400 Subject: [PATCH] Issue #23573:check for unposted receipts --- .../public/functions/unreleasepurchaseorder.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/foundation-database/public/functions/unreleasepurchaseorder.sql b/foundation-database/public/functions/unreleasepurchaseorder.sql index f5a585d7a..47a8db456 100644 --- a/foundation-database/public/functions/unreleasepurchaseorder.sql +++ b/foundation-database/public/functions/unreleasepurchaseorder.sql @@ -4,12 +4,14 @@ CREATE OR REPLACE FUNCTION unreleasePurchaseOrder(pPoheadid INTEGER) RETURNS INT BEGIN IF ( ( SELECT (COUNT(*) > 0) - FROM poitem + FROM poitem LEFT OUTER JOIN recv ON (recv_order_type='PO' AND + recv_orderitem_id=poitem_id) WHERE ( (poitem_pohead_id=pPoheadid) AND ( (poitem_status='C') OR (poitem_qty_received > 0.0) OR (poitem_qty_returned > 0.0) OR - (poitem_qty_vouchered > 0.0) ) ) ) ) THEN + (poitem_qty_vouchered > 0.0) OR + (recv_id IS NOT NULL) ) ) ) ) THEN RETURN -1; END IF; -- 2.39.2