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

[..hidden..]

Revision: 6751
          http://sourceforge.net/p/ledger-smb/code/6751
Author:   einhverfr
Date:     2014-02-05 09:35:40 +0000 (Wed, 05 Feb 2014)
Log Message:
-----------
Correcting display of negative overpayments

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

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2014-02-05 09:26:47 UTC (rev 6750)
+++ trunk/Changelog	2014-02-05 09:35:40 UTC (rev 6751)
@@ -115,6 +115,7 @@
 * Fixed language change on order to invoice conversion (Chris T, 896)
 * Fixed ar/ap tax check inconsistency (Chris T, 919)
 * Fixed inputs ignored for email addresses sending statements (Chris T, 920)
+* Fixed negative overpayments showing as positive (Chris T, 926)
 
 Changelog for 1.3.37
 * 1.3-1.2 downgrade now drops extensions (Chris T, 943)

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2014-02-05 09:26:47 UTC (rev 6750)
+++ trunk/sql/modules/Payment.sql	2014-02-05 09:35:40 UTC (rev 6751)
@@ -1481,12 +1481,11 @@
 DECLARE out_overpayment payment_overpayments_available_amount;
 BEGIN
       FOR out_overpayment IN
-              SELECT chart_id, accno,   chart_description, abs(sum(available))
+              SELECT chart_id, accno,   chart_description, available
               FROM overpayments
               WHERE payment_class  = in_account_class 
               AND entity_credit_id = in_entity_credit_id 
               AND available <> 0
-              GROUP BY chart_id, accno, chart_description
       LOOP
            RETURN NEXT out_overpayment;
       END LOOP;

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits