SF.net SVN: ledger-smb:[2998] trunk/sql/modules/1099_reports.sql

[..hidden..]

Revision: 2998
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2998&view=rev
Author:   einhverfr
Date:     2010-04-30 23:10:13 +0000 (Fri, 30 Apr 2010)

Log Message:
-----------
fixing missing column in details report

Modified Paths:
--------------
    trunk/sql/modules/1099_reports.sql

Modified: trunk/sql/modules/1099_reports.sql
===================================================================
--- trunk/sql/modules/1099_reports.sql	2010-04-30 23:04:58 UTC (rev 2997)
+++ trunk/sql/modules/1099_reports.sql	2010-04-30 23:10:13 UTC (rev 2998)
@@ -66,10 +66,10 @@
                               ELSE 0 END), 
                      sum(ac.amount),
                      gl.invnumber, gl.duedate::text
-                FROM (select id, entity_credit_account, invnumber, duedate 
+                FROM (select id, entity_credit_account, invnumber, duedate, transdate
                         FROM ar 
                        UNION 
-                      select id, entity_credit_account, invnumber, duedate 
+                      select id, entity_credit_account, invnumber, duedate, transdate
                         FROM ap
                      ) gl 
                 JOIN (select trans_id, 'acc_trans' as relation, amount as amount, 


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