diff options
| author | Mitch Jackson <mitch@freeside.biz> | 2018-09-19 02:31:52 -0400 |
|---|---|---|
| committer | Mitch Jackson <mitch@freeside.biz> | 2018-09-20 13:07:37 -0400 |
| commit | dcf1ad84924e58127a42e0c905e940eb4e076ac7 (patch) | |
| tree | f2c91dc7637a8aa8bd68c8389e649980c93d2ff9 /httemplate/search/future_autobill.html | |
| parent | 9ea31f98372bc897fd0b4d7e63284eecabf27aa2 (diff) | |
RT# 78547 Future autobill report - sql bugfix
Diffstat (limited to 'httemplate/search/future_autobill.html')
| -rw-r--r-- | httemplate/search/future_autobill.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/search/future_autobill.html b/httemplate/search/future_autobill.html index 1f3862fbc..3385dd880 100644 --- a/httemplate/search/future_autobill.html +++ b/httemplate/search/future_autobill.html @@ -121,8 +121,8 @@ there will be 1,400 billing and payment cycles simulated order_by => " ORDER BY weight DESC ", extra_sql => "AND ( - payby IN ('CHEK','DCHK','DCHEK') - OR ( paydate > '".$target_dt->ymd."') + cust_payby.payby IN ('CHEK','DCHK','DCHEK') + OR ( cust_payby.paydate > '".$target_dt->ymd."') ) AND " . $FS::CurrentUser::CurrentUser->agentnums_sql . ($agentnum ? "AND cust_main.agentnum = $agentnum" : ''), |