X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Frep202.php;h=c3b1e87a41ec7c9f0323cb30ea437b845238fe94;hb=61fb69cf679671e44d7aaa10fab553c059e6f62e;hp=4b788eb62fe46f4e0ad6521c6e00afaafb067957;hpb=107a22ab168c1102f3f534a22cd5b8290331f17d;p=fa-stable.git

diff --git a/reporting/rep202.php b/reporting/rep202.php
index 4b788eb6..c3b1e87a 100644
--- a/reporting/rep202.php
+++ b/reporting/rep202.php
@@ -32,9 +32,8 @@ print_aged_supplier_analysis();
 function get_invoices($supplier_id, $to, $all=true)
 {
 	$todate = date2sql($to);
-	$current = 1;
-	$PastDueDays1 = get_company_pref('past_due_days') + $current;
-	$PastDueDays2 = 2 * $PastDueDays1 + $current;
+	$PastDueDays1 = get_company_pref('past_due_days');
+	$PastDueDays2 = 2 * $PastDueDays1;
 
 	// Revomed allocated from sql
 	if ($all)
@@ -48,9 +47,9 @@ function get_invoices($supplier_id, $to, $all=true)
 		".TB_PREF."supp_trans.reference,
 		".TB_PREF."supp_trans.tran_date,
 		$value as Balance,
-		IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $current,$value,0) AS Due,
-		IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $PastDueDays1,$value,0) AS Overdue1,
-		IF ((TO_DAYS('$todate') - TO_DAYS($due)) >= $PastDueDays2,$value,0) AS Overdue2
+		IF ((TO_DAYS('$todate') - TO_DAYS($due)) > 0,$value,0) AS Due,
+		IF ((TO_DAYS('$todate') - TO_DAYS($due)) > $PastDueDays1,$value,0) AS Overdue1,
+		IF ((TO_DAYS('$todate') - TO_DAYS($due)) > $PastDueDays2,$value,0) AS Overdue2
 
 		FROM ".TB_PREF."suppliers,
 			".TB_PREF."payment_terms,