X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=purchasing%2Fincludes%2Fdb%2Finvoice_db.inc;h=7128a7bc7900a0e8bb5ffdec2e9414ace81f3756;hb=076aabe0c83753d9384e53d071b34ee51b8c43b8;hp=06d27cde04265d5093cd79c1647c729b1a85678e;hpb=ce52da010251810cd6500d9fbf0ff89da88e07b5;p=fa-stable.git

diff --git a/purchasing/includes/db/invoice_db.inc b/purchasing/includes/db/invoice_db.inc
index 06d27cde..7128a7bc 100644
--- a/purchasing/includes/db/invoice_db.inc
+++ b/purchasing/includes/db/invoice_db.inc
@@ -381,6 +381,7 @@ function get_po_invoices_credits($po_number)
 		WHERE ".TB_PREF."supp_invoice_items.supp_trans_no = ".TB_PREF."supp_trans.trans_no
 		AND ".TB_PREF."supp_invoice_items.po_detail_item_id = ".TB_PREF."purch_order_details.po_detail_item
 		AND ".TB_PREF."purch_orders.supplier_id = ".TB_PREF."supp_trans.supplier_id
+		AND ".TB_PREF."purch_order_details.order_no = ".db_escape($po_number)."
 		AND ".TB_PREF."purch_order_details.order_no = ".db_escape($po_number);
 
 	return db_query($sql, "The invoices/credits for the po $po_number could not be retreived");