用友畅捷通T+固定资产处置,选择不到资产卡片
8月份T6数据升级到T+,做资产处置时,筛选不到固定资产,只显示100条,实际有一千多条卡片,但是在卡片管理中是正常的,可以在卡片管理中做处置.
解决办法
备份下数据,执行脚本,重启T+服务.
DECLARE @auditedID INT; SET @auditedID = (SELECT ID FROM eap_EnumItem WHERE idEnum =(SELECT id FROM eap_Enum WHERE Name = 'VoucherState') AND Code='01') UPDATE AM_Asset SET auditor = maker,auditorId = makerid,auditedDate = voucherdate,voucherstate = @auditedID UPDATE AM_HandleVoucher SET auditor = maker,auditorId = makerid,auditedDate = voucherdate,voucherstate = @auditedID UPDATE AM_SplitVoucher SET auditor = maker,auditorId = makerid,auditedDate = voucherdate,voucherstate = @auditedID

浙公网安备 33010602011771号