SF.net SVN: ledger-smb:[6115] trunk/sql/modules/PNL.sql

[..hidden..]

Revision: 6115
          http://sourceforge.net/p/ledger-smb/code/6115
Author:   einhverfr
Date:     2013-10-08 07:05:13 +0000 (Tue, 08 Oct 2013)
Log Message:
-----------
Correcting PNL load issues

Modified Paths:
--------------
    trunk/sql/modules/PNL.sql

Modified: trunk/sql/modules/PNL.sql
===================================================================
--- trunk/sql/modules/PNL.sql	2013-10-08 05:28:59 UTC (rev 6114)
+++ trunk/sql/modules/PNL.sql	2013-10-08 07:05:13 UTC (rev 6115)
@@ -188,7 +188,7 @@
   JOIN account_heading_tree at ON a.heading = at.id
  WHERE ac.approved is true and ac.trans_id = $1
  GROUP BY a.id, a.accno, a.description, a.category, 
-          ah.id, ah.accno, ah.description
+          ah.id, ah.accno, ah.description, at.path
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE sql;
 

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


------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits