diff options
| -rw-r--r-- | sql/fixes/amount_blank_ap_transactions.sql | 3 |
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; |