From 62df06cdb59c5052f86407fc7c8e7408d7203f30 Mon Sep 17 00:00:00 2001 From: malfredo32 Date: Thu, 4 Sep 2014 22:29:12 -0500 Subject: [PATCH] Change BillingSelections metasql to include only uninvoiced approved selections --- .../public/tables/metasql/billingSelections-detail.mql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/foundation-database/public/tables/metasql/billingSelections-detail.mql b/foundation-database/public/tables/metasql/billingSelections-detail.mql index 864b03bc2..66bfe7e5c 100644 --- a/foundation-database/public/tables/metasql/billingSelections-detail.mql +++ b/foundation-database/public/tables/metasql/billingSelections-detail.mql @@ -1,8 +1,8 @@ -- Group: billingSelections -- Name: detail -- Notes: used by dspBillingSelections --- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. --- See www.xtuple.com/CPAL for the full text of the software license. +-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. +-- See www.xtuple.com/CPAL for the full text of the software license. SELECT cobmisc_id, cohead_id, cohead_number, cust_number, cust_name, @@ -21,7 +21,7 @@ FROM cobmisc, cohead, custinfo, coitem, cobill WHERE ((cobmisc_cohead_id=cohead_id) AND (cohead_cust_id=cust_id) AND (coitem_cohead_id=cohead_id) - AND (cobill_coitem_id=coitem_id) + AND (cobill_coitem_id=coitem_id) AND (COALESCE(cobill_invcnum,0) = 0) AND (NOT cobmisc_posted)) GROUP BY cobmisc_id, cohead_id, cohead_number, cust_number, cust_name, cobmisc_misc, cobmisc_freight, cobmisc_tax, cobmisc_payment -- 2.39.2