Payment_terms table normalization.

[fa-stable.git] / reporting / rep203.php

diff --git a/reporting/rep203.php b/reporting/rep203.php
index 2a5c7bb089094d963f76abbe7e16accbe79c4fe6..112b3447e7bda08ba7df8c075903bc2eba9740f6 100644 (file)
--- a/reporting/rep203.php
+++ b/reporting/rep203.php
@@ -111,7 +111,7 @@ function print_payment_report()
                WHERE ";
        if ($fromsupp != ALL_TEXT)
                $sql .= "supplier_id=".db_escape($fromsupp)." AND ";
-       $sql .= "".TB_PREF."suppliers.payment_terms = ".TB_PREF."payment_terms.terms_indicator
+       $sql .= "".TB_PREF."suppliers.payment_terms = ".TB_PREF."payment_terms.id
                ORDER BY supp_name";
        $result = db_query($sql, "The customers could not be retrieved");