【U8】固定资产卡片项目保存无效
【U8】固定资产卡片项目保存无效
【问题原因】fa_checkdata、fa_checkdatacache、fa_checkconfig表中多了man1063s、man1064s、man1065s字段;
【解决方案】先将客户账套做好输出备份,再将上述三张表做好备份,最后执行语句:
alter table fa_checkdata drop column man1063s
alter table fa_checkdatacache drop column man1063s
alter table fa_checkdatacache drop column man1064s
alter table fa_checkdatacache drop column man1065s
delete from fa_checkconfig where sitemname = ‘man1063s’
delete from fa_checkconfig where sitemname = ‘man1064s’
delete from fa_checkconfig where sitemname = ‘man1065s’
执行完语句后再到卡片项目中操作即可