Page tree
Skip to end of metadata
Go to start of metadata

问题描述:开账提示“账务期初数据异常”或“财务数据异常”等类似的报错。

问题原因:账务期初里面,辅助核算科目下还有辅助核算明细数据,但是没有科目余额。

处理方法:

情况一:如果是总账版本,备份账套数据,执行下面语句后,会将没有科目余额的辅助核算明细都删除。
DELETE a FROM Ac_IniAccount_Assist_CheckItems_Detail a
WHERE NOT EXISTS ( SELECT * FROM Ac_IniAccount_Assist_CheckItems b
WHERE a.STypeId = b.STypeId AND a.ATypeId = b.ATypeId
AND a.Cid = b.Cid )

情况二:如果是非总账版本,备份账套数据,执行下面语句后,会将账务期初里面所有的数据清除。
DELETE FROM Ac_IniAccount
DELETE FROM Ac_IniAccount_Assist_CheckItems
DELETE FROM Ac_IniAccount_Assist_CheckItems_Detail

  • No labels