From d960513a88b99e97ee36af9f0e631126fa5fbf7b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Mon, 12 May 2008 19:16:16 +0000 Subject: Adding datepaid fixes to ar/ap transactions fix. will rename next commit. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2138 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/fixes/amount_blank_ap_transactions.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/sql/fixes/amount_blank_ap_transactions.sql b/sql/fixes/amount_blank_ap_transactions.sql index fa7ec4f2..f4a86bee 100644 --- a/sql/fixes/amount_blank_ap_transactions.sql +++ b/sql/fixes/amount_blank_ap_transactions.sql @@ -13,6 +13,8 @@ SET netamount = ) 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 @@ SET netamount = -1 * ) WHERE netamount IS NULL; +update ar set datepaid = NULL where paid = 0; commit; -- cgit v1.2.3