如图所示,会计核算体系新增组织,然后选取 了香港会计政策,未删除系统标准的会计政策。保存后无法修改。这时想要把系统预设的政策修改掉,把香港的会计政策改成默认的。怎么如何后台操作。不多说 上图看场景
对应SQL:
--bak
select * into T_ORG_ACCTSYSENTRY_sqlbak_20230515 from T_ORG_ACCTSYSENTRY
select * into T_ORG_MULTIAPPACCTPOLICY_sqlbak_20230515 from T_ORG_MULTIAPPACCTPOLICY
select * into T_FA_ACCTPOLICYORG_sqlbak_20230515 from T_FA_ACCTPOLICYORG
------------------------------
---查询对应组织的组织内码 以名称为海蓝的组织为例 根据名称查询 forgid
select forgid,* from t_org_organizations_l where fname = '海蓝'-- FORGID = 10897518
--查询对应会计核算体系内码,以编码为 KJHSTX01_SYS 为例 facctsystemid = 1
select facctsystemid,* from t_org_accountsystem where fnumber ='KJHSTX01_SYS' -- facctsystemid = 1
--根据组织内码,会计核算体系内码,找到对应组织在会计核算体系单据体的内码 fentryid =100025
select fentryid ,* from T_ORG_ACCTSYSENTRY where facctsystemid = 1 and fmainorgid = 10897518 --100025
--根据会计核算体系内码与单据体内码,找到会计政策的存储字段,然后更新为自己想要的 FDEFACCTPOLICY ,facctpolicylst
update T_ORG_ACCTSYSENTRY set FDEFACCTPOLICY = 3758247,facctpolicylst=3758247 where facctsystemid = 1 and fentryid = 100025
--对应组织在会计核算体系中存在的下级组织(一般就一个)
select * from T_ORG_ACCTSYSDETAIL where fentryid = 100025
--对应组织的适用会计政策,如果只保留一个,就把其他的删除,只保留自己想要的。这里删除了系统预设的会计政策(系统预设会计政策内码为1)
select * from T_ORG_MULTIAPPACCTPOLICY where fentryid = 100025
delete T_ORG_MULTIAPPACCTPOLICY where fentryid = 100025 and fmulbase =1
--查询对应组织存在的会计政策,根据组织内码,会计核算体系内码查询(这里是改会计政策的适用核算组织了,要改默认,不改的话创建账簿 还是历史默认会计的主币别)
select * from T_FA_ACCTPOLICYORG where facctorgid=10897518 and facctsystemid = 1
--删除系统预设会计政策。
delete T_FA_ACCTPOLICYORG where facctorgid=10897518 and facctsystemid = 1 and FACCTPOLICYID = 1
--将香港会计政策改为默认。
update T_FA_ACCTPOLICYORG set FISDEFAULT=1 where facctorgid=10897518 and facctsystemid = 1 and FACCTPOLICYID = 3758247
推荐阅读