用友U852 从后台数据库反启用资金管理
无法直接用账套主管反启用了,可以考虑从后台数据库反启用,修改两个表:
账套库中的Accinformation、系统库的UA_accountsub
select * from accinformation where csysid='FD' and ctype='ddate'
select * from gl_mend where bflag_Fd=0
select * from ua_account_sub where (cacc_id='999') and (cSub_Id = 'FD')
以上查询出是否正确的表记录:
以下进行反启用:
update accinformation set cvalue='' where csysid='FD' and ctype='ddate'
update gl_mend set bflag_Fd=0
delete ua_account_sub where (cacc_id='999') and (cSub_Id = 'FD') 999是账套号
修改后重启系统,若系统变回演示/教学版,需要重新注册成正版。
tlsopen@20150331
无法直接用账套主管反启用了,可以考虑从后台数据库反启用,修改两个表:
账套库中的Accinformation、系统库的UA_accountsub
select * from accinformation where csysid='FD' and ctype='ddate'
select * from gl_mend where bflag_Fd=0
select * from ua_account_sub where (cacc_id='999') and (cSub_Id = 'FD')
以上查询出是否正确的表记录:
以下进行反启用:
update accinformation set cvalue='' where csysid='FD' and ctype='ddate'
update gl_mend set bflag_Fd=0
delete ua_account_sub where (cacc_id='999') and (cSub_Id = 'FD') 999是账套号
修改后重启系统,若系统变回演示/教学版,需要重新注册成正版。
tlsopen@20150331