diff options
| author | ivan <ivan> | 2011-03-30 19:43:46 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-30 19:43:46 +0000 |
| commit | 628df952c0980f9ee4d42c7c8724563567e92d92 (patch) | |
| tree | 58e92bdca6abfe63ca2d85f0b08bf3ef3534048f /FS | |
| parent | 14c2640fc9b64b582a1ec96cbb31eab014af5df5 (diff) | |
fix package balance conditions, RT#11834
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/cust_bill.pm | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm index e289191fc..0ed79e44b 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -652,8 +652,8 @@ sub cust_bill_pay_pkg { qsearch({ 'select' => 'cust_bill_pay_pkg.*', 'table' => 'cust_bill_pay_pkg', - 'addl_from' => ' LEFT JOIN cust_bill_pay USING billpaynum '. - ' LEFT JOIN cust_bill_pkg USING billpkgnum ', + 'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '. + ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', 'hashref' => { 'invnum' => $self->invnum, 'pkgnum' => $pkgnum, }, @@ -697,8 +697,8 @@ sub cust_credit_bill_pkg { qsearch({ 'select' => 'cust_credit_bill_pkg.*', 'table' => 'cust_credit_bill_pkg', - 'addl_from' => ' LEFT JOIN cust_credit_bill USING creditbillnum '. - ' LEFT JOIN cust_bill_pkg USING billpkgnum ', + 'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '. + ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', 'hashref' => { 'invnum' => $self->invnum, 'pkgnum' => $pkgnum, }, |