有客户曾经出现了这样一个问题:打开固定资产模块,固定资产清单、报表、明细账中固定资产信息显示错列,这个问题比较少见
问题原因:主要是因为数卡片信息中包括的回车符、换行符、table符等等,导致南通金蝶KIS专业版在读取的时候出现了错误,须由金蝶公司专业技术人员来解决。
解决方法:需要在数据库里更正卡片代码
update t_facard set fassetnumber=replace(fassetnumber,char(10)+char(13),'') where charindex(char(10)+char(13),fassetnumber)>0
update t_fabalcard set fassetnumber=replace(fassetnumber,char(10)+char(13),'') where charindex(char(10)+char(13),fassetnumber)>0
更正卡片名称
update t_facard set fassetname=replace(fassetname,char(10)+char(13),'') where charindex(char(10)+char(13),fassetname)>0
update t_fabalcard set fassetname=replace(fassetname,char(10)+char(13),'') where charindex(char(10)+char(13),fassetname)>0
更正卡片计量单位
update t_facard set Funit=replace(Funit,char(10)+char(13),'') where charindex(char(10)+char(13),Funit)>0
update t_fabalcard set Funit=replace(Funit,char(10)+char(13),'') where charindex(char(10)+char(13),Funit)>0
更正卡片型号
update t_facard set Fmodel=replace(Fmodel,char(10)+char(13),'') where charindex(char(10)+char(13),Fmodel)>0
update t_fabalcard set Fmodel=replace(Fmodel,char(10)+char(13),'') where charindex(char(10)+char(13),Fmodel)>0
更正卡片供应商
update t_facard set Fvender=replace(Fvender,char(10)+char(13),'') where charindex(char(10)+char(13),Fvender)>0
update t_fabalcard set Fvender=replace(Fvender,char(10)+char(13),'') where charindex(char(10)+char(13),Fvender)>0
更正卡片制造商
update t_facard set Fmanufacturer=replace(Fmanufacturer,char(10)+char(13),'') where charindex(char(10)+char(13),Fmanufacturer)>0
update t_fabalcard set Fmanufacturer=replace(Fmanufacturer,char(10)+char(13),'') where charindex(char(10)+char(13),Fmanufacturer)>0
更正卡片产地
Fproductingarea=replace(Fproductingarea,char(10)+char(13),'') where charindex(char(10)+char(13),Fproductingarea)>0
update t_fabalcard set Fproductingarea=replace(Fproductingarea,char(10)+char(13),'') where charindex(char(10)+char(13),Fproductingarea)>0
更正卡片备注
update t_faalterset Fexplanation=replace(Fexplanation,char(10)+char(13),'') where charindex(char(10)+char(13),Fexplanation)>0
更正卡片类别
update t_fagroup set fnumber=replace(fnumber,char(10)+char(13),''),fshortnumber=replace(fshortnumber,char(10)+char(13),''),fname replace( fname,char(10)+char(13),''),fdefaultunit=replace(fdefaultunit,char(10)+ char(13),''),fnumberrule=replace(fnumberrule,char(10)+char(13),'')
更正卡片存放地点
update t_falocation set fnumber=replace(fnumber,char(10)+char(13),'') ,fshortnumber=replace(fshortnumber,char(10)+char(13),''),fname=replace (fname,char(10)+char(13),'')
转载于:https://blog.51cto.com/stkingdee/1259715