From dbd6664705d48597e435d18b08638a74cd507cd2 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 1 Apr 2016 14:31:44 -0400 Subject: [PATCH] we need to also remove fund debits --- acq/reset_po.pl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/acq/reset_po.pl b/acq/reset_po.pl index 3f86eaf..9304681 100755 --- a/acq/reset_po.pl +++ b/acq/reset_po.pl @@ -27,6 +27,8 @@ #[^^ recorded IDs] #delete from acq.edi_message where purchase_order in (270, 271, 274, 275); #update acq.purchase_order set state = 'pending', order_date = null where id in (270, 271, 274, 275); +#delete from acq.fund_debit where id in (select fund_debit from acq.lineitem_detail where lineitem in (select id from acq.lineitem where purchase_order in (....))); +#update acq.lineitem_detail set fund_debit = null where lineitem in (select id from acq.lineitem where purchase_order in (....)); #commit; -- 2.11.0