用友软件固定资产卡片管理报错:“未设置对象变量或with block 变量”

技术咨询,有偿服务!
复制微信号
原因分析:问题原因:1. fa_items表中缺少可抵扣税行 2. fa_cards表中dbloffsettax 列为null
问题解答:解决方法:注,ufdata_003_2011指有问题账套,ufdata_003_2009指的是正常账套。1. insert into ufdata_003_2011..fa_items(sID, sName, sCaption, sEngCaption, sSysCaption, sEngSysCaption, bVisible, bDel, bMove, bIsValue, bAutoPop, bQuery, lQueryOrder, sType, bDepr, bEvn, sSourceTable, bEdit, bAllowNull, iIntLength, iPointLength, memFormula, memUsedItems, memItemsUseMe, iDictType, iDefineType, lByUsed, sHelpID, sRemark, sLockedBy)select sID, sName, sCaption, sEngCaption, sSysCaption, sEngSysCaption, bVisible, bDel, bMove, bIsValue, bAutoPop, bQuery, lQueryOrder, sType, bDepr, bEvn, sSourceTable, bEdit, bAllowNull, iIntLength, iPointLength, memFormula, memUsedItems, memItemsUseMe, iDictType, iDefineType, lByUsed, sHelpID, sRemark, sLockedByfrom ufdata_003_2009..fa_items where sid='1500'2. update ufdata_003_2011..fa_cards set dbloffsettax=0 where dbloffsettax is null