用友u8软件购销存和核算不是同时启用造成收发存汇总表不一致
2018-06-27 10:17 来源:用友
购销存和核算不是同时启用造成收发存汇总表不一致原因分析:非同时启用购销存和核算模块。问题解答:1.执行如下脚本(改写系统的启用日期到'2008-01-01):在账套库:update accinformation set cvalue='2008-01-01' where cvalue='2008-03-01' and ccaption like '%日期'在系统库:update ua_account_sub set dsubsysused='2008-01-01' where dsubsysused='2008-03-01' and cacc_id='574' and iyear=99992.把采购、销售、库存、核算都取消月结到1月(删除已经生成的凭证和取消月末处理,取消记账)3.在账套中执行如下语句:INSERT INTO [ST_TotalAccount]([cWhCode], [cInvCode], [cBatch], [iMonth], [iBeginQuantity], [iBeginNum], [iIncomeQuantity], [iIncomeNum], [iSentOutQuantity], [iSentOutNum], [cFree1], [cFree2])select cwhcode, i.cinvcode, NULL, 1, sum(IsNull(iAInQuantity,0)) as iBegQuantity , sum(iAInQuantity/IsNull(Inventory.iInvExchRate, 1) ) as iBegNum, 0, 0, 0, 0, cfree1,cfree2from ia_subsidiary i join inventory on (i.cInvCode = inventory.cinvCode ) where imonth = 0 Group by cwhcode, i.cinvcode, cfree1,cfree2(以存货明细账ia_subsidiary为准,把数据写到存货总账里)对一下收发存汇总表,整理现存量后,然后再重新记账和生成凭证