发布时间:2025-4-28
特价活动:>>>> 畅云管家新购、续费7折优惠,畅捷通T+cloud、好会计、易代账、好业财、好生意云产品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)
客服电话:400-665-0028
关键字:用友财务软件,畅捷通软件,财务软件,进销存软件,U9官网,用友U8,用友T1,用友T+,用友T3,用友T6,畅捷通好会计,好生意,智+好业财,用友培训服务售后公司,畅捷通运营培训服务公司
版权所有:用友畅捷通软件 Copyright © 2025 All rights reserved.