SF.net SVN: ledger-smb:[5734] trunk

[..hidden..]

Revision: 5734
          http://sourceforge.net/p/ledger-smb/code/5734
Author:   einhverfr
Date:     2013-05-02 10:12:09 +0000 (Thu, 02 May 2013)
Log Message:
-----------
Merging Nick Prater's fix for issue 812, duplication of accounts in reconciliation

Modified Paths:
--------------
    trunk/Changelog
    trunk/sql/modules/Reconciliation.sql

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2013-05-02 09:03:42 UTC (rev 5733)
+++ trunk/Changelog	2013-05-02 10:12:09 UTC (rev 5734)
@@ -85,7 +85,10 @@
 Changelog for 1.3.32
 * Fixed em-dash handling for pdfs (Chris T)
 * Fixed multiple blank line handling for pdfs (Chris T)
+* Fixed multiple repeat entries in chart of accounts drop down (Nick P, 812)
 
+Nick P is Nick Prater
+
 Changelog for 1.3.31
 * Removed spurious commit saving orders (Chris T)
 * Removed check for reversing too many sales, since this poses problems 

Modified: trunk/sql/modules/Reconciliation.sql
===================================================================
--- trunk/sql/modules/Reconciliation.sql	2013-05-02 09:03:42 UTC (rev 5733)
+++ trunk/sql/modules/Reconciliation.sql	2013-05-02 10:12:09 UTC (rev 5734)
@@ -549,7 +549,7 @@
 );
 
 create or replace function reconciliation__account_list () returns setof recon_accounts as $$
-    SELECT
+    SELECT DISTINCT
         coa.accno || ' ' || coa.description as name,
         coa.accno, coa.id as id
     FROM account coa

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