diff options
| author | mark <mark> | 2010-05-20 01:33:08 +0000 |
|---|---|---|
| committer | mark <mark> | 2010-05-20 01:33:08 +0000 |
| commit | 08b36523ebbf6e2995878f26bfac988f32f7a218 (patch) | |
| tree | a9352c8bed56d918a89ebff37a33fb0a6acb8431 /httemplate/search/report_receivables.cgi | |
| parent | 07c8992ccbb2d179939af013e9c90774a093f820 (diff) | |
RT#7266: aging report "as of" date now limits applied payments
Diffstat (limited to 'httemplate/search/report_receivables.cgi')
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index 73ebee49d..3696ed40d 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -16,7 +16,7 @@ die "access denied" #Example: # # my $balance = balance( -# $start, $end, +# $start, $end, $offset, # 'no_as' => 1, #set to true when using in a WHERE clause (supress AS clause) # #or 0 / omit when using in a SELECT clause as a column # # ("AS balance_$start_$end") @@ -44,7 +44,8 @@ sub balance { #$opt{'unapplied_date'} = 1; - FS::cust_main->balance_date_sql( $start, $end, 'unapplied_date'=>1,); + FS::cust_main->balance_date_sql( $start, $end, 'unapplied_date'=>1, + 'cutoff' => "( $str2time now() $closing - ".$offset * 86400 . ')' ); } |