projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Supplier Inquiry link in Supplier form.
[fa-stable.git]
/
reporting
/
rep102.php
diff --git
a/reporting/rep102.php
b/reporting/rep102.php
index 2d00c063f1573e637498bb2e094892f1aa6ed8ac..18fab24d052952aa6649e80e8064fde507fec187 100644
(file)
--- a/
reporting/rep102.php
+++ b/
reporting/rep102.php
@@
-51,11
+51,9
@@
function get_invoices($customer_id, $to, $all=true)
IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $PastDueDays2,$value,0) AS Overdue2
FROM ".TB_PREF."debtors_master,
IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $PastDueDays2,$value,0) AS Overdue2
FROM ".TB_PREF."debtors_master,
- ".TB_PREF."payment_terms,
".TB_PREF."debtor_trans
WHERE ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY."
".TB_PREF."debtor_trans
WHERE ".TB_PREF."debtor_trans.type <> ".ST_CUSTDELIVERY."
- AND ".TB_PREF."debtor_trans.payment_terms = ".TB_PREF."payment_terms.terms_indicator
AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no
AND ".TB_PREF."debtor_trans.debtor_no = $customer_id
AND ".TB_PREF."debtor_trans.tran_date <= '$todate'
AND ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no
AND ".TB_PREF."debtor_trans.debtor_no = $customer_id
AND ".TB_PREF."debtor_trans.tran_date <= '$todate'