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

[..hidden..]

Revision: 6938
          http://sourceforge.net/p/ledger-smb/code/6938
Author:   einhverfr
Date:     2014-03-17 09:20:24 +0000 (Mon, 17 Mar 2014)
Log Message:
-----------
Fixing payment reversal not passing currency and exchangerate in, and fixing handling of empty sources.  now null and an empty string are considered equivalent for reversal purposes.

Modified Paths:
--------------
    trunk/LedgerSMB/Scripts/payment.pm
    trunk/sql/modules/Payment.sql

Modified: trunk/LedgerSMB/Scripts/payment.pm
===================================================================
--- trunk/LedgerSMB/Scripts/payment.pm	2014-03-17 06:31:28 UTC (rev 6937)
+++ trunk/LedgerSMB/Scripts/payment.pm	2014-03-17 09:20:24 UTC (rev 6938)
@@ -274,6 +274,8 @@
     $request->{hiddens} = { 
         batch_id => $request->{batch_id},
       cash_accno => $request->{cash_accno},
+        currency => $request->{currency},
+    exchangerate => $request->{exchangerate}
     };
     $report->render($request);
 }

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2014-03-17 06:31:28 UTC (rev 6937)
+++ trunk/sql/modules/Payment.sql	2014-03-17 09:20:24 UTC (rev 6938)
@@ -1189,7 +1189,7 @@
 		JOIN entity_credit_account c 
 			ON (arap.entity_credit_account = c.id)
 		JOIN account ch ON (a.chart_id = ch.id)
-		WHERE a.source IS NOT DISTINCT FROM in_source
+		WHERE coalesce(a.source, '') = coalesce(in_source, '')
 			AND a.transdate = in_date_paid
 			AND in_credit_id = arap.entity_credit_account
 			AND in_cash_accno = ch.accno

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


------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits