我在使用用友T1进销存软件的T1业务单据模块中碰到了一个奇怪的问题:
抄帐不了,提示以下提示,已经打了最新补丁
具体的情况如下:
抄帐不了,提示以下提示,已经打了最新补丁
您在执行下以下脚本update SystemInfo set s_JCQH=0 where s_FullID='00000'ALTER TABLE product DISABLE TRIGGER all delete product where s_syb=-1ALTER TABLE product enable TRIGGER all ALTER TABLE units DISABLE TRIGGER all delete units where s_syb=-1ALTER TABLE units enable TRIGGER all ALTER TABLE Area DISABLE TRIGGER all delete Area where s_syb=-1ALTER TABLE Area enable TRIGGER all ALTER TABLE StorHouse DISABLE TRIGGER all delete StorHouse where s_syb=-1ALTER TABLE StorHouse enable TRIGGER all
DISAB附近语法有错误
备份好账套数据之后,退出全部再登录操作客户端软件,执行以下脚本之后再操作update SystemInfo set s_JCQH=0 where s_FullID='00000'ALTER TABLE product DISABLE TRIGGER all delete product where s_syb=-1ALTER TABLE product enable TRIGGER all ALTER TABLE units DISABLE TRIGGER all delete units where s_syb=-1ALTER TABLE units enable TRIGGER all ALTER TABLE Area DISABLE TRIGGER all delete Area where s_syb=-1ALTER TABLE Area enable TRIGGER all ALTER TABLE StorHouse DISAB
dbcc checkdb 没有错误
所有的盘点抄帐单都已经过账了
业务单据,盘点业务,盘点管理中心,开始和结束日期分别输入 1999-01-01 和 9999-01-01,将状态是可用的抄库单删除之后再操作