From 31e0e9e435b298263e55b2747b27684e1050fd1d Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 17 Jun 2009 14:08:54 +0000 Subject: [PATCH] Allowed reuse of supplier references from voided documents. --- purchasing/supplier_invoice.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/purchasing/supplier_invoice.php b/purchasing/supplier_invoice.php index b2ea26a..fa379e9 100644 --- a/purchasing/supplier_invoice.php +++ b/purchasing/supplier_invoice.php @@ -189,7 +189,11 @@ function check_data() return false; } - $sql = "SELECT Count(*) FROM ".TB_PREF."supp_trans WHERE supplier_id='" . $_SESSION['supp_trans']->supplier_id . "' AND supp_reference='" . $_POST['supp_reference'] . "'"; + $sql = "SELECT Count(*) FROM ".TB_PREF."supp_trans WHERE supplier_id='" + . $_SESSION['supp_trans']->supplier_id . "' AND supp_reference='" + . $_POST['supp_reference'] + . "' AND ov_amount!=0"; // ignore voided invoice references + $result=db_query($sql,"The sql to check for the previous entry of the same invoice failed"); $myrow = db_fetch_row($result); -- 2.30.2