問(wèn)題現(xiàn)象：成本管理模塊中，材料及外購(gòu)半成品耗用表取數(shù)的金額經(jīng)常與材料出庫(kù)單的金額不對(duì)，數(shù)量對(duì)。 解決方案：將有問(wèn)題的存貨重新期末處理，通過(guò)如下腳本可檢查哪些存貨、材料出庫(kù)單與存貨總帳上的差異率不一致： 注意具體用該腳本檢查時(shí)，根據(jù)實(shí)際情況修改其中的a.imonth=9、b.cmonth=200509參數(shù)！ --檢查當(dāng)月存貨總帳差異率與材料出庫(kù)單實(shí)際差異率是否一致： select c.iprice/c.iPPrice AS 單據(jù)上差異率,d.idifrate AS 存貨總帳差異率,c.cinvcode as 存貨編碼,e.ccode as 材料出庫(kù)單號(hào),E.* from ia_subsidiary a inner join Inventory b on a.cinvcode=b.cinvcode inner join rdrecords c on a.id=c.autoid and a.cinvcode=c.cinvcode inner join rdrecord e on c.id=e.id inner join ia_summary d on a.imonth=d.imonth and a.cinvcode=d.cinvcode and ROUND(c.iprice/c.iPPrice,6)<>ROUND(1+d.idifrate,6) where a.imonth=9 and a.cvoutype='11' and a.bmoneyflag=0 and b.cmonth=200509