SF.net SVN: ledger-smb:[4227] branches/1.3/sql/modules/Payment.sql

[..hidden..]

Revision: 4227
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4227&view=rev
Author:   ehuelsmann
Date:     2011-12-17 18:29:54 +0000 (Sat, 17 Dec 2011)
Log Message:
-----------
Follow-up to r4222: belatedly switching the AR and AP tables.

Revision Links:
--------------
    http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4222&view=rev

Modified Paths:
--------------
    branches/1.3/sql/modules/Payment.sql

Modified: branches/1.3/sql/modules/Payment.sql
===================================================================
--- branches/1.3/sql/modules/Payment.sql	2011-12-17 16:47:41 UTC (rev 4226)
+++ branches/1.3/sql/modules/Payment.sql	2011-12-17 18:29:54 UTC (rev 4227)
@@ -669,13 +669,13 @@
         ELSIF (in_account_class = 2) THEN
            SELECT buy INTO old_exchangerate 
            FROM exchangerate e
-           JOIN ap a ON (a.transdate = e.transdate)
+           JOIN ar a ON (a.transdate = e.transdate)
                         AND (a.curr = e.curr)
            WHERE a.id = in_transaction_id[out_count];
         ELSE 
            SELECT sell INTO old_exchangerate 
            FROM exchangerate e
-           JOIN ar a ON (a.transdate = e.transdate)
+           JOIN ap a ON (a.transdate = e.transdate)
                         AND (a.curr = e.curr)
            WHERE a.id = in_transaction_id[out_count];
         END IF;

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