用友T6软件查询批次台账与批次结存表不一样
技术咨询，有偿服务！
复制微信号
查询批次台账与批次结存表不一样
原因分析：执行下面脚本，然后执行批次整理。造成此问题原因做过相关修改，打上最新补丁。update rdrecords set cvouchcode=(select min(autoid) from rdrecords c where c.cinvcode=rdrecords.cinvcode and c.cbatch=rdrecords.cbatch and isnull(cvouchcode,0)=0)where autoid in(select b.autoid from rdrecords a,rdrecords b where a.autoid=b.cvouchcode and isnull(b.cvouchcode,0)0and a.cinvcodeb.cinvcode)update salebillvouchs set ibatch=(select cvouchcode from rdrecords where rdrecords.isbsid=salebillvouchs.autoid)where autoid in(select b.autoid from rdrecords a,salebillvouchs b where a.autoid=b.ibatch and isnull(b.ibatch,0)0and a.cinvcodeb.cinvcode)您好：请执行脚本执行下面脚本，然后执行批次整理。造成此问题原因做过相关修改，打上最新补丁。update rdrecords set cvouchcode=(select min(autoid) from rdrecords c where c.cinvcode=rdrecords.cinvcode and c.cbatch=rdrecords.cbatch and isnull(cvouchcode,0)=0)where autoid in(select b.autoid from rdrecords a,rdrecords b where a.autoid=b.cvouchc
问题解答：执行下面脚本，然后执行批次整理。造成此问题原因做过相关修改，打上最新补丁。update rdrecords set cvouchcode=(select min(autoid) from rdrecords c where c.cinvcode=rdrecords.cinvcode and c.cbatch=rdrecords.cbatch and isnull(cvouchcode,0)=0)where autoid in(select b.autoid from rdrecords a,rdrecords b where a.autoid=b.cvouchcode and isnull(b.cvouchcode,0)0and a.cinvcodeb.cinvcode)update salebillvouchs set ibatch=(select cvouchcode from rdrecords where rdrecords.isbsid=salebillvouchs.autoid)where autoid in(select b.autoid from rdrecords a,salebillvouchs b where a.autoid=b.ibatch and isnull(b.ibatch,0)0and a.cinvcodeb.cinvcode)您好：请执行脚本执行下面脚本，然后执行批次整理。造成此问题原因做过相关修改，打上最新补丁。update rdrecords set cvouchcode=(select min(autoid) from rdrecords c where c.cinvcode=rdrecords.cinvcode and c.cbatch=rdrecords.cbatch and isnull(cvouchcode,0)=0)where autoid in(select b.autoid from rdrecords a,rdrecords b where a.autoid=b.cvouchcode and isnull(b.cvouchcode,0)0and a.cinvcodeb.cinvcode)update salebillvouchs set ibatch=(select cvouchcode from rdrecords where rdrecords.isbsid=salebillvouchs.autoid)where autoid in(select b.autoid from rdrecords a,salebillvouchs b where a.autoid=b.ibatch and isnull(b.ibatch,0)0and a.cinvcodeb.cinvcode)
如果您的问题还没有解决，或者在百度上找不到答案可以到右上角搜索中进行搜索。