金沙集团官网

购销存和核算不是同时启用造成收发存汇总表不一致原因分析：非同时启用购销存和核算模块。问题解答：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为准，把数据写到存货总账里）对一下收发存汇总表，整理现存量后，然后再重新记账和生成凭证