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

[..hidden..]

Revision: 5782
          http://sourceforge.net/p/ledger-smb/code/5782
Author:   einhverfr
Date:     2013-05-14 04:15:26 +0000 (Tue, 14 May 2013)
Log Message:
-----------
Fixing reconciliation load error

Modified Paths:
--------------
    trunk/Changelog
    trunk/sql/modules/Reconciliation.sql
    trunk/templates/demo/invoice.tex

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2013-05-13 09:39:03 UTC (rev 5781)
+++ trunk/Changelog	2013-05-14 04:15:26 UTC (rev 5782)
@@ -97,6 +97,7 @@
 * Added fx boxes for GL transactions (Chris T, required to fix 802)
 * Fixed odd UI issues with voiding GL transactions (Chris T, 803)
 * Fixed department dropdown not showing values (Chris T, 805)
+* Fixed error causing Reconciliation.sql not to be loaded/reloaded (Chris T)
 
 
 Nick P is Nick Prater

Modified: trunk/sql/modules/Reconciliation.sql
===================================================================
--- trunk/sql/modules/Reconciliation.sql	2013-05-13 09:39:03 UTC (rev 5781)
+++ trunk/sql/modules/Reconciliation.sql	2013-05-14 04:15:26 UTC (rev 5782)
@@ -337,7 +337,7 @@
                                 AND our_balance = t_amount
                         	AND their_balance = 0
                                 AND post_date = in_date
-				in_scn NOT LIKE t_prefix || '%';
+				AND in_scn NOT LIKE t_prefix || '%';
 		ELSE -- more than one match
 			SELECT min(id) INTO lid FROM cr_report_line
 			WHERE report_id = in_report_id AND our_balance = t_amount

Modified: trunk/templates/demo/invoice.tex
===================================================================
--- trunk/templates/demo/invoice.tex	2013-05-13 09:39:03 UTC (rev 5781)
+++ trunk/templates/demo/invoice.tex	2013-05-14 04:15:26 UTC (rev 5782)
@@ -138,7 +138,8 @@
   & \textbf{<?lsmb text('Unit') ?>} 
   & \textbf{<?lsmb text('Price') ?>} 
   &  \textbf{<?lsmb text('Disc %') ?>} 
-  & \textbf{<?lsmb text('Amount') ?>} 
+  & \textbf{<?lsmb text('Amount') ?>} \\
+\hline
 \endhead
 <?lsmb FOREACH number ?>
 <?lsmb lc = loop.count - 1 ?>

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