会计期间勿关闭后台打开

会计期间重新开启步骤

最新推荐文章于 2024-12-08 11:39:32 发布

原创最新推荐文章于 2024-12-08 11:39:32 发布 · 2.5k 阅读

1 ·

CC 4.0 BY-SA版权

EBS 专栏收录该内容

108 篇文章

订阅专栏

会计期间误关闭后需要从新打开需要做一下几个步骤

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;