首页 > 代码库 > 会计期间勿关闭后台打开
会计期间勿关闭后台打开
会计期间误关闭后需要从新打开需要做一下几个步骤
SELECT acct_period_id period, open_flag, period_name name, period_start_date, schedule_close_date, period_close_date FROM org_acct_periods WHERE organization_id = &org_id order by 1,2; UPDATE org_acct_periods SET open_flag = 'Y', period_close_date = NULL, summarized_flag = 'N' WHERE organization_id = &&org_id AND acct_period_id >= &&acct_period_id; DELETE mtl_period_summary WHERE organization_id = &org_id AND acct_period_id >= &acct_period_id; DELETE mtl_period_cg_summary WHERE organization_id = &org_id AND acct_period_id >= &acct_period_id; DELETE mtl_per_close_dtls WHERE organization_id = &org_id AND acct_period_id >= &acct_period_id; DELETE cst_period_close_summary WHERE organization_id = &org_id AND acct_period_id >= &acct_period_id;
会计期间勿关闭后台打开
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。