SF.net SVN: ledger-smb:[6622] branches/1.3/LedgerSMB/AA.pm

[..hidden..]

Revision: 6622
          http://sourceforge.net/p/ledger-smb/code/6622
Author:   einhverfr
Date:     2014-01-24 15:33:15 +0000 (Fri, 24 Jan 2014)
Log Message:
-----------
Removing crdate from ar/ap transaction report and group by since we have some reports of problems.  Will add to changelog

Modified Paths:
--------------
    branches/1.3/LedgerSMB/AA.pm

Modified: branches/1.3/LedgerSMB/AA.pm
===================================================================
--- branches/1.3/LedgerSMB/AA.pm	2014-01-24 11:16:57 UTC (rev 6621)
+++ branches/1.3/LedgerSMB/AA.pm	2014-01-24 15:33:15 UTC (rev 6622)
@@ -909,7 +909,7 @@
         # detail report query can be inlined in the summary report query. -CT
         my $p = $LedgerSMB::Sysconfig::decimal_places;
 
-        my $cols = qq|a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,
+        my $cols = qq|a.id, a.invnumber, a.ordnumber, a.transdate, 
 		          a.duedate, a.netamount, a.amount::numeric(20,$p), 
 		          a.amount::numeric(20,$p) - (sum(acs.amount::numeric(20,$p)) * CASE WHEN '$table' = 'ar' THEN -1 ELSE 1 END) AS paid,
 		          a.invoice, a.datepaid, a.terms, a.notes,
@@ -975,7 +975,7 @@
        } 
     } else {
         $query = qq|
-		   SELECT a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,
+		   SELECT a.id, a.invnumber, a.ordnumber, a.transdate, 
 		          a.duedate, a.netamount, a.amount, 
                           (a.amount - pd.due) AS paid,
 		          a.invoice, a.datepaid, a.terms, a.notes,

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits