计算机打印1,无法打印凭证。显示“您的计算机没有可用的打印机-1”

用友U8 固定资产10月份不能计提折旧，折旧中断用友U8 固定资产10月份不能计提折旧，折旧中断

问题原因:fa_cards和fa_DeprTransactions数据紊乱 解决方法:数据库中有数据丢失，由于按单部门折旧，可做如下修改：一、增加fa_cards_detail表中的数据(由fa_cards表获得)：1.将fa_cards中的数据插入临时表,以便生成自增字段:select identity(int, 1,1) as sid,scardid,scardnum,sdeptnum,loptid,ddisposedate,iDisposePeriod,dblvalue,dbldecdeprt,dblbv,dblcanwork,dbltransindeprtcard,dbltransoutdeprtcard,dbldecprevaluet,dblretdecprevaluet,dblBuildArea,lBuildNum,lMachinNum,dblMachinW into temptablefrom fa_cards2.由临时表插入fa_cards_detail: set identity_insert fa_cards_detail oninsert into fa_cards_detail (sid,scardid,scardnum,sdeptnum,loptid,ddisposedate,iDisposePeriod,dblvalue,dbldecdeprt,dblbv,dblcanwork,dbltransindeprtcard,dbltransoutdeprtcard,dbldecprevaluet,dblretdecprevaluet,dblBuildArea,lBuildNum,lMachinNum,dblMachinW) select sid,scardid,scardnum,sdeptnum,loptid,ddisposedate,iDisposePeriod,dblvalue,dbldecdeprt,dblbv,dblcanwork,dbltransindeprtcard,dbltransoutdeprtcard,dbldecprevaluet,dblretdecprevaluet,dblBuildArea,lBuildNum,lMachinNum,dblMachinW from temptableset identity_insert fa_cards_detail off3.删除临时表drop table temptable二、补全fa_DeprTransactions_Detail表中的数据：1.将fa_DeprTransactions中的数据插入临时表,以便生成自增字段:select IDENTITY(int, 1, 1) AS sid , fa_DeprTransactions.[sCardNum], [sDeptNum], [dblDepr1], [dblDeprT1], [dblDepr2], [dblDeprT2], [dblDepr3], [dblDeprT3], [dblDepr4], [dblDeprT4], [dblDepr5], [dblDeprT5], [dblDepr6], [dblDeprT6], [dblDepr7], [dblDeprT7], [dblDepr8], [dblDeprT8], [dblDepr9], [dblDeprT9], [dblDepr10], [dblDeprT10], [dblDepr11], [dblDeprT11], [dblDepr12], [dblDeprT12], [dblMonthValue1], [dblMonthValue2], [dblMonthValue3], [dblMonthValue4], [dblMonthValue5], [dblMonthValue6],[dblMonthValue7], [dblMonthValue8], [dblMonthValue9], [dblMonthValue10], [dblMonthValue11], [dblMonthValue12], [dblDeprThisYear] into temptablefrom fa_DeprTransactions left outer join (select distinct scardNum,sdeptnum from fa_cards) a on fa_DeprTransactions.scardnum = a.scardnum2.由临时表插入fa_DeprTransactions_Detail :set identity_insert fa_DeprTransactions_Detail oninsert into fa_DeprTransactions_Detail (sid , [sCardNum], [sDeptNum], [dblDepr1], [dblDeprT1], [dblDepr2], [dblDeprT2], [dblDepr3], [dblDeprT3], [dblDepr4], [dblDeprT4], [dblDepr5], [dblDeprT5], [dblDepr6], [dblDeprT6], [dblDepr7], [dblDeprT7], [dblDepr8], [dblDeprT8], [dblDepr9], [dblDeprT9], [dblDepr10], [dblDeprT10], [dblDepr11], [dblDeprT11], [dblDepr12], [dblDeprT12], [dblMonthValue1], [dblMonthValue2], [dblMonthValue3], [dblMonthValue4], [dblMonthValue5], [dblMonthValue6],[dblMonthValue7], [dblMonthValue8], [dblMonthValue9], [dblMonthValue10], [dblMonthValue11], [dblMonthValue12],[dblMonthValue13], [dblDeprThisYear] ) select sid , [sCardNum], [sDeptNum], [dblDepr1], [dblDeprT1], [dblDepr2], [dblDeprT2], [dblDepr3], [dblDeprT3], [dblDepr4], [dblDeprT4], [dblDepr5], [dblDeprT5], [dblDepr6], [dblDeprT6], [dblDepr7], [dblDeprT7], [dblDepr8], [dblDeprT8], [dblDepr9], [dblDeprT9], [dblDepr10], [dblDeprT10], [dblDepr11], [dblDeprT11], [dblDepr12], [dblDeprT12], [dblMonthValue1], [dblMonthValue2], [dblMonthValue3], [dblMonthValue4], [dblMonthValue5], [dblMonthValue6],[dblMonthValue7], [dblMonthValue8], [dblMonthValue9], [dblMonthValue10], [dblMonthValue11], [dblMonthValue12],[dblMonthValue12], [dblDeprThisYear] from temptableset identity_insert fa_DeprTransactions_Detail off3.删除临时表drop table temptable