From d035d202c955d8c31b364dbb64e00dda4cab68d0 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 15 Mar 2019 09:56:18 -0400 Subject: [PATCH] Update over due for Accounts by Age Should be based on due date. --- models/admin/billing/reports.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/admin/billing/reports.php b/models/admin/billing/reports.php index 2a7d255..9c9a622 100644 --- a/models/admin/billing/reports.php +++ b/models/admin/billing/reports.php @@ -179,7 +179,7 @@ class GlmMembersAdmin_billing_reports extends GlmDataTransactions SELECT account FROM " . GLM_MEMBERS_BILLING_PLUGIN_DB_PREFIX . "invoices WHERE balance > 0.00 - AND transaction_time + INTERVAL 60 DAY <= CURDATE() + AND due_date + INTERVAL 60 DAY <= CURDATE() )"; $view = 'reports'; break; -- 2.17.1