问题现象: | 客户2011年底使用的T6升级到U810.1升级后新年度里固定资产模块所有原值为零 但在卡片管理里却有原始卡片 但原始卡片有原值 无计提的折旧额和以计提的月数 对账时总账数据和固定资产不平 固定资产原值和累计折旧全部为零 在固定资产帐表里查询固定资产原值也为零。无法计提折旧。 |
问题原因: | |
解决方案: | 您好: 丢数据了。 请使用以下脚本在处理最新年度的数据,执行完脚本后重新月结即可解决。有问题的话给我电话。 update AccInformation set cValue =12 where cName ='iLastPeriod' and cSysID ='fa' insert into AccInformation (cSysID,cID,cName,cCaption,cType,cValue,cDefault,bVisible,bEnable) select cSysID,cID,cName,cCaption,cType,cValue,cDefault,bVisible,bEnable from UFFA_BAK_AccInformation_11 where cSysID = 'FA' and cname not in (select cName from AccInformation where cSysID = 'FA') insert into 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, sLockedBy from UFFA_BAK_fa_Items_11 where sName not in (select sName from fa_Items) delete from fa_models insert into UFDATA_xxx_2011..fa_models select * from UFDATA_xxx_2010..fa_models where sName not in (select sName from UFDATA_xxx_2011..fa_models) 如有问题,请及时邮件反馈。 |
相关补丁: | |
版本: | U8 V10.1 |
模块: | 固定资产 |
产品: | 财务会计 |
问题名称: | 计提折旧 |
最后更新: | 2012-02-21 23:25:12 |