diff options
| author | ivan <ivan> | 2011-03-30 19:43:41 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-30 19:43:41 +0000 |
| commit | d173c0ab4d47eea5fc0d76b9f8d94b7dc6a44cfb (patch) | |
| tree | 178c7bc9f395de71f4a2a27147de8693fc8e0d86 | |
| parent | 45976742f83a9809c66ef02cd3d266963c0537f2 (diff) | |
fix package balance conditions, RT#11834
| -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 f673b76a3..9f27a74ba 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -681,8 +681,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, }, @@ -726,8 +726,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, }, |