From 9371180a7f4ff887eb3b78076745c200b212ad0a Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 22 Jul 2020 10:20:59 -0400 Subject: [PATCH] remove account adjustment entries --- remove_ou_data/15_remove_ou_extras.sql | 7 +++++++ 1 files changed, 7 insertions(+), 0 deletions(-) diff --git a/remove_ou_data/15_remove_ou_extras.sql b/remove_ou_data/15_remove_ou_extras.sql index 08bab80..2cd9e29 100644 --- a/remove_ou_data/15_remove_ou_extras.sql +++ b/remove_ou_data/15_remove_ou_extras.sql @@ -38,6 +38,13 @@ WHERE copy_location IN (SELECT id FROM asset.copy_location WHERE owning_lib IN DELETE FROM asset.copy_location WHERE owning_lib IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); +DELETE FROM money.account_adjustment WHERE billing IN + (SELECT id FROM money.billing WHERE btype IN ( + SELECT id FROM config.billing_type + WHERE owner IN + (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del) +)); + DELETE FROM money.billing WHERE btype IN ( SELECT id FROM config.billing_type -- 1.7.2.5