remove references to itemsite_nnqoh

diff --git a/enyo-client/database/source/xt/views/itemsiteinfo.sql b/enyo-client/database/source/xt/views/itemsiteinfo.sql
index c972418..d438be2 100644 (file)
--- a/enyo-client/database/source/xt/views/itemsiteinfo.sql
+++ b/enyo-client/database/source/xt/views/itemsiteinfo.sql
@@ -48,7 +48,6 @@ insert into itemsite (
   itemsite_location_comments,
   itemsite_notes,
   itemsite_perishable,
-  itemsite_nnqoh,
   itemsite_autoabcclass,
   itemsite_ordergroup,
   itemsite_disallowblankwip,
@@ -109,7 +108,6 @@ insert into itemsite (
   new.itemsite_location_comments,
   new.itemsite_notes,
   coalesce(new.itemsite_perishable, false),
-  0,
   coalesce(new.itemsite_autoabcclass, false),
   coalesce(new.itemsite_ordergroup, 1),
   coalesce(new.itemsite_disallowblankwip, false),

diff --git a/foundation-database/public/functions/postinvtrans.sql b/foundation-database/public/functions/postinvtrans.sql
index 9afe786..46f272f 100644 (file)
--- a/foundation-database/public/functions/postinvtrans.sql
+++ b/foundation-database/public/functions/postinvtrans.sql
@@ -127,7 +127,7 @@ BEGIN
     (itemsite_qtyonhand + (_sense * pQty)),
     itemsite_costmethod, itemsite_value,
     -- sanity check to ensure that value = 0 when qtyonhand = 0
-    CASE WHEN ((itemsite_qtyonhand + (_sense * pQty)) + itemsite_nnqoh) = 0.0 THEN 0.0
+    CASE WHEN ((itemsite_qtyonhand + (_sense * pQty))) = 0.0 THEN 0.0
          ELSE itemsite_value + (_r.cost * _sense * pQty)
     END,
     pOrderType, pOrderNumber, pDocNumber, pComments,