用友U8 客户的数据是从U821升级的，去年用821结转正常，今年用U852结转库存期初没有问题，存货核算的期初去年有发生入库的才结转期初，没有入库单的没有期初(U852结转补丁已打过)，存货核算里面的期初不正常用友U8 客户的数据是从U821升级的，去年用821结转正常，今年用U852结转库存期初没有问题，存货核算的期初去年有发生入库的才结转期初，没有入库单的没有期初(U852结转补丁已打过)，存货核算里面的期初不正常
问题原因:上年数据问题 解决方法:请在2004年度执行以下脚本，更正关联关系。清空2005年数据后再执行年结。 update ia_valuationass set dikeepdate=dkeepdate,inid=ia_subsidiary.id from ia_valuationass left join ia_subsidiary on ia_valuationass.cwhcode=ia_subsidiary.cwhcode and ia_valuationass.cinvcode=ia_subsidiary.cinvcode left join warehouse on ia_subsidiary.cwhcode=warehouse.cwhcode where ia_subisiary.cvoutype='34' and ia_valuationass.dkeepdate0 and b.cwhvaluestyle in ('先进先出法','后进先出法') update ia_valuationass set dokeepdate=dkeepdate,outid=ia_subsidiary.id from ia_valuationass left join ia_subsidiary on ia_valuationass.cwhcode=ia_subsidiary.cwhcode and ia_valuationass.cinvcode=ia_subsidiary.cinvcode left join warehouse on ia_subsidiary.cwhcode=warehouse.cwhcode where ia_subisiary.cvoutype='34' and ia_valuationass.dkeepdate
本文链接：https://my.lmcjl.com/post/19139.html
4 评论