发布时间:2025-5-3
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠,另有话费赠送。
问题描述:
用友T3整理现存量失效,无法正确整理现存量
解决方法:备份账套,执行下列语句。
Delete From CurrentStock
Insert INTO
CurrentStock(cWhCode,cInvCode,cFree1,cFree2,iQuantity,iNum,fOutQuantity,fOutNum,fInQuantity,fInNum)
Select cWhCode, cInvCode,'null' as cFree1,'null' as cFree2 , inum AS iQuantity, 0 AS iNum,
0 as fOutQuantity, 0 as fOutNum ,0 AS fInQuantity,
0 AS fInNum FROM ia_summary where imonth =(select max(imonth) from ia_summary)
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)