diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2022-03-03 18:42:03 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2022-03-03 18:42:03 -0800 |
| commit | 10dbf48db68e0ca9264865cb98c24cb05c104824 (patch) | |
| tree | fbb55bb8cb5e51b504522302f8a538e5ce1794f9 /FS | |
| parent | 1d63c6b68d172caa53bacc2cc811cdb34a2c80ae (diff) | |
477 reporting
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Report/FCC_477.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index 760f6f22d..0f5d4cedc 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -398,7 +398,7 @@ sub fbs_sql { my $agentnum = $opt{agentnum}; my $q = $opt{ignore_quantity} ? '1' : 'COALESCE(cust_pkg.quantity, 1)'; - my $censustract = "replace(cust_location.censustract, '.', '')"; + my $censustract = "substr( replace(cust_location.censustract, '.', ''), 1, 11)"; my @select = ( "$censustract AS censustract", @@ -473,7 +473,7 @@ sub fvs_sql { my $date = $opt{date} || time; my $agentnum = $opt{agentnum}; my $q = $opt{ignore_quantity} ? '1' : 'COALESCE(cust_pkg.quantity, 1)'; - my $censustract = "replace(cust_location.censustract, '.', '')"; + my $censustract = "substr( replace(cust_location.censustract, '.', ''), 1, 11)"; my @select = ( "$censustract AS censustract", |