summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-12 19:16:16 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-12 19:16:16 +0000
commitd960513a88b99e97ee36af9f0e631126fa5fbf7b (patch)
treefaf3d4158441c13785418ced8fd416cf37fb447a /sql
parent7ebf2880074ab9a5ef5f8f54116695b77746631c (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/fixes/amount_blank_ap_transactions.sql3
1 files changed, 3 insertions, 0 deletions
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;