问题现象:在年度结转之后,记入期初。6.年后发现存货期初数据查询中只记录了金额、数量、单价,导致年末金额与年初金额不一致.【此现象只存在于存货管理,存货管理一切正常】 今年1月系统已关闭 【存货管理】本年年初金额与上年末金额不一致。解决方案:请将年份恢复到核算前的状态,那就用下面的脚本来调整和重新预订吧!从 ia_subsidiary 删除,其中 cvoutype='34' 插入到 ia_subsidiary (bRdFlag, dvoudate, dKeepDate, iMoth, cIvHead, cvoutype, cWhCode, cIvCode, IAIQUOTE, iAIPrice, CACDATE, cMaker, cPzID,2,free cPzID,2,free1 , cfree6, cfree7, cfree8, cfree9, CFRE10) select 1,'-12-31','-1-1-1', 0, cIvHead, '34', CWODE, cIvCode, cIvCode, Sumufdata_XXX (IAIQuatity, 0) -Isull (IaOutQuatity, 0)), ull, Sum (Isull (iAIPrice, 0)-Isull (iAIPrice, 0)),'demo','demo', cPzID, cfree1, cfree2, cfree3, Cfree4, cfree5, cfree6, cfree7、cfree8、cfree9、cfree10IAW的子公司,其中CVR通过了cIvHead、cWhCode、cIvCode、cPzID、cfree1、cfree2、cfree3、cfree4、cfree5、cfree6、cfree7、cfree8、cfree9, cfree10 有舍入 (sum (Isull (iAIQuatity, 0)-Isull (IaOutQuatity, 0)), 6) 0 or roudig (ad (Isull (iAIPrice, 0)-Isull (IaOutPrice, 0))2) 0 去更新 IA_uuu 辅助集 IIicost=IaIPrice/iaIquatity,其中 iaIquatity 0