用友u8軟件購銷存和核算不是同時啟用造成收發(fā)存匯總表不一致
2018-06-27 10:17 來源:用友
購銷存和核算不是同時啟用造成收發(fā)存匯總表不一致原因分析:非同時啟用購銷存和核算模塊。問題解答:1.執(zhí)行如下腳本(改寫系統(tǒng)的啟用日期到'2008-01-01):在賬套庫:update accinformation set cvalue='2008-01-01' where cvalue='2008-03-01' and ccaption like '%日期'在系統(tǒng)庫:update ua_account_sub set dsubsysused='2008-01-01' where dsubsysused='2008-03-01' and cacc_id='574' and iyear=99992.把采購、銷售、庫存、核算都取消月結到1月(刪除已經生成的憑證和取消月末處理,取消記賬)3.在賬套中執(zhí)行如下語句: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為準,把數(shù)據(jù)寫到存貨總賬里)對一下收發(fā)存匯總表,整理現(xiàn)存量后,然后再重新記賬和生成憑證