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

[..hidden..]

Revision: 5668
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5668&view=rev
Author:   einhverfr
Date:     2013-03-05 10:17:49 +0000 (Tue, 05 Mar 2013)
Log Message:
-----------
Fixed db api for repoening books

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

Added Paths:
-----------
    trunk/t/data/sample_po.edi
    trunk/t/data/sample_po1.edi

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2013-02-21 09:35:30 UTC (rev 5667)
+++ trunk/Changelog	2013-03-05 10:17:49 UTC (rev 5668)
@@ -91,6 +91,7 @@
 * Fixed print and save buttons on orders (Chris T, 3602071)
 * Fixing history report blank when no fx (Chris T, 3602084)
 * More CSS hooks (Chris T)
+* Fixed DB API for reopening books (Chris T)
 
 Changelog for 1.3.29
 * Added db routines for role backup and restore for shared hosting

Modified: trunk/sql/modules/EndOfYear.sql
===================================================================
--- trunk/sql/modules/EndOfYear.sql	2013-02-21 09:35:30 UTC (rev 5667)
+++ trunk/sql/modules/EndOfYear.sql	2013-03-05 10:17:49 UTC (rev 5668)
@@ -154,7 +154,7 @@
 
 		INSERT INTO acc_trans (chart_id, amount, transdate, trans_id,
 			approved)
-		SELECT chart_id, amount * -1, currval('id'), true
+		SELECT chart_id, amount * -1, in_end_date, currval('id'), true
 		FROM acc_trans where trans_id = (select trans_id from yearend
 			where transdate = in_end_date and reversed is not true);
 

Added: trunk/t/data/sample_po.edi
===================================================================
--- trunk/t/data/sample_po.edi	                        (rev 0)
+++ trunk/t/data/sample_po.edi	2013-03-05 10:17:49 UTC (rev 5668)
@@ -0,0 +1 @@
+ISA*00*          *00*          *01*9012345720000  *01*9088877320000  *090508*1459*U*00200*000000001*0*T*:~GS*PO*901234572000*908887732000*090508*1459*1*T*004010~ST*850*0001~BEG*01*BK*99AKDF9DAL393*39483920193843*20090508*AN* 3920943*AC*IBM*02*AE*02*BA~DTM*002*20090508*1615*CT*CM*DATE TIME PERIOD~N1*AC*ARTHUR JONES*1*9012345918341*11*SE~N2*MAGGIE MCGILLICUTTY*BEVERLY SIMPSON~N3*PO BOX 123*157 WEST 57TH STREET~N4*CINCINNATI*OH*43017*US*IP*02535~PER*AC*ARTHUR JONES*TE*(614)555-1212*TE*(614)555-1212*TE*(614)555-1212*ADDL CONTACT DESC~PO1*AAA849*100*DP*100.00*PD*AB*ASSEMBLY*BL*BRAND OR LABEL*ON*CUST12345*AB*ASSEMBLY*BL*BRAND OR LABEL*ON*CUST12345*AB*ASSEMBLY*BL*BRAND OR LABEL*ON*CUST12345*AB*ASSEMBLY~PID*F*BC*AX*UNSCENTED*GENERAL PURPOSE*BS*SUBQUALIFIER*N*ENG~CTT*10*855*12345678*HB*40*QD*GENERAL PURPOSE~SE*12*0001~GE*1*1~IEA*1*000000001~

Added: trunk/t/data/sample_po1.edi
===================================================================
--- trunk/t/data/sample_po1.edi	                        (rev 0)
+++ trunk/t/data/sample_po1.edi	2013-03-05 10:17:49 UTC (rev 5668)
@@ -0,0 +1,14 @@
+ISA*00*          *00*          *01*ABCDEFGH       *ZZ*12345678*090223*1027*U*00501*000000001*0*P*> 
+GS*PO*HGFEDCBA*87654321*20090223*1027*000000011*X*005010 
+ST*850*0001 
+BEG*00*KN*25105**20090317 
+PER*CN*VITAMIN COTTAGE*TE*303-986-5700 
+DTM*002*20090318 
+N9*ZA*12341 
+N1*ST**92*U102 
+PO1**10*EA*14.95**UC*357955504320*PI*138244*VN*123456 
+PID*F****Description Here 
+CTT*1*10 
+SE*10*0001 
+GE*1*000000011 
+IEA*1*000000001i

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