SF.net SVN: ledger-smb:[4838] trunk/LedgerSMB/AA.pm

[..hidden..]

Revision: 4838
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4838&view=rev
Author:   einhverfr
Date:     2012-06-05 03:57:46 +0000 (Tue, 05 Jun 2012)
Log Message:
-----------
AR/AP outstanding reports mostly working, in advance of port to new reporting framework

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2012-06-05 03:54:35 UTC (rev 4837)
+++ trunk/LedgerSMB/AA.pm	2012-06-05 03:57:46 UTC (rev 4838)
@@ -928,7 +928,7 @@
                                 * CASE WHEN '$table' = 'ar' THEN -1 ELSE 1 END)
                           AS paid,
 		          vce.name, vc.meta_number,
-		          a.entity_credit_account, 
+		          a.entity_credit_account
 		     FROM $table a
 		     JOIN entity_credit_account vc ON (a.entity_credit_account = vc.id)
 		     JOIN acc_trans acs ON (acs.trans_id = a.id)
@@ -944,9 +944,7 @@
 			AND a.approved IS TRUE AND acs.approved IS TRUE
 			AND a.force_closed IS NOT TRUE
 		 GROUP BY 
-		          vc.meta_number, a.entity_credit_account, vce.name, 
-                          d.description --,
-		          --a.ponumber, a.invoice 
+		          vc.meta_number, a.entity_credit_account, vce.name 
 		   HAVING abs(sum(acs.amount::numeric(20,2))) > 0.000 |;
         } else {
             #HV typo error a.ponumber $acc_trans_fields -> a.ponumber $acc_trans_flds
@@ -979,7 +977,7 @@
 			AND a.force_closed IS NOT TRUE
 		 GROUP BY a.id, a.invnumber, a.ordnumber, a.transdate, a.duedate, a.netamount,
 		          a.amount, a.terms, a.notes, a.shipvia, a.shippingpoint, vce.name,
-		          vc.meta_number, a.entity_credit_account, a.till, ex.$buysell, d.description, vce.name,
+		          vc.meta_number, a.entity_credit_account, a.till, ex.$buysell, vce.name,
 		          a.ponumber, a.invoice, a.datepaid $acc_trans_flds
 		   HAVING abs(sum(acs.amount::numeric(20,$p))) > 0 |;
        } 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.