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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

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

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

处理方法:

情况一:如果是总账版本,备份账套数据,执行下面语句后,会将没有科目余额的辅助核算明细都删除。
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