SF.net SVN: ledger-smb: [2138] branches/1.2/sql/fixes/ amount_blank_ap_transactions.sql

[..hidden..]

Revision: 2138
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2138&view=rev
Author:   einhverfr
Date:     2008-05-12 12:16:16 -0700 (Mon, 12 May 2008)

Log Message:
-----------
Adding datepaid fixes to ar/ap transactions fix.  will rename next commit.

Modified Paths:
--------------
    branches/1.2/sql/fixes/amount_blank_ap_transactions.sql

Modified: branches/1.2/sql/fixes/amount_blank_ap_transactions.sql
===================================================================
--- branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-12 19:13:22 UTC (rev 2137)
+++ branches/1.2/sql/fixes/amount_blank_ap_transactions.sql	2008-05-12 19:16:16 UTC (rev 2138)
@@ -13,6 +13,8 @@
 	)
 WHERE netamount IS NULL;
 
+update ap set datepaid = NULL where paid = 0;
+
 UPDATE ar
 SET netamount = -1 *
 	(select sum(amount) from acc_trans 
@@ -26,4 +28,5 @@
 	)
 WHERE netamount IS NULL;
 
+update ar set datepaid = NULL where paid = 0;
 commit;


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