問題現(xiàn)象：結(jié)算成本處理過濾不出對應(yīng)業(yè)務(wù)記錄：采購入庫單和采購發(fā)票結(jié)算后，后期來了運費發(fā)票通過費用折扣結(jié)算，應(yīng)該在存貨核算系統(tǒng)進(jìn)行結(jié)算成本處理，生成入庫調(diào)整單進(jìn)材料成本，但是客戶在本月做過處理后，恢復(fù)記帳后就沒有再做結(jié)算成本處理，客戶想在第二個月再做結(jié)算成本處理，因為產(chǎn)成品成本全部已經(jīng)歸及了。此方式按理說是可以的。但客戶帳套，第二個月此部分再做“結(jié)算成本處理”界面就看不到了，不能調(diào)整入庫成本，造成帳面不平，請問此問題應(yīng)該怎么處理。
解決方案：進(jìn)行結(jié)算成本處理時可借助SQL事件探察器進(jìn)行跟蹤，系統(tǒng)會執(zhí)行如下過濾腳本: SELECT IA_EstiSettle.PSVID, IA_EstiSettle.ID, IA_EstiSettle.iRdID,IA_EstiSettle.iRdsid, ' ' AS 表達(dá)式1,IA_EstiSettle.cSVCode, IA_EstiSettle.cWhCode, IA_EstiSettle.cWhName,IA_EstiSettle.cPIVCode, IA_EstiSettle.DDATE, IA_EstiSettle.cInvCode,IA_EstiSettle.cInvName, IA_EstiSettle.cInvM_Unit, LTRIM(STR(IA_EstiSettle.iSVQuantity,20,2)),LTRIM(STR((Case When IsNull(IA_EstiSettle.iRdsid,0)<>0 then(case when isnull(ia_subsidiary.iainquantity,0)=0 then 0 else (isnull(ia_subsidiary.iainprice,0)+isnull(ia_subsidiary.idebitdifcost,0)-isnull(ia_subsidiary.iCreditDifCost,0))/ia_subsidiary.iainquantity end)else ia_estisettle.isvacost end),20,2)), LTRIM(STR((Case When Isnull(IA_EstiSettle.iRdsid,0)<>0 then IsNull(IA_EstiSettle.iSVQuantity,0)*(case when isnull(ia_subsidiary.iainquantity,0)=0 then 0 else (isnull(ia_subsidiary.iainprice,0)+isnull(ia_subsidiary.idebitdifcost,0)-isnull(ia_subsidiary.iCreditDifCost,0))/ia_subsidiary.iainquantity end) Else ISNULL(IA_EstiSettle.iSVAPrice,0) End),20,2)), LTRIM(STR((case when isnull(IA_EstiSettle.iSVCost,0)=0 then 0 else (isnull(IA_EstiSettle.iSVQuantity,0)) end),20,2)),LTRIM(STR((case when isnull(IA_EstiSettle.iSVQuantity,0)=0 then 0 else (isnull(IA_EstiSettle.iSVPrice,0)/isnull(IA_EstiSettle.iSVQuantity,0)) end),20,2)),LTRIM(STR(IA_EstiSettle.iSVPrice,20,2)),IA_EstiSettle.ibsid,IA_EstiSettle.cRdCode, IA_EstiSettle.cRdName,IA_EstiSettle.cFree1,IA_EstiSettle.cFree2,IA_EstiSettle.cFree3, IA_EstiSettle.cFree4,IA_EstiSettle.cFree5, IA_EstiSettle.cFree6,IA_EstiSettle.cFree7, IA_EstiSettle.cFree8,IA_EstiSettle.cFree9, IA_EstiSettle.cFree10 FROM (((((IA_EstiSettle INNER JOIN Inventory ON IA_EstiSettle.cInvCode = Inventory.cInvCode) left Join PurBillVouchs On IA_EstiSettle.iBSid=PurBillVouchs.Id) Left JOIN RdRecords ON IA_EstiSettle.iRdsID = RdRecords.AutoID) left join ia_subsidiary on rdrecords.autoid=ia_subsidiary.id) left join rdrecord on rdrecords.id=rdrecord.id) WHERE (((Purbillvouchs.bExBill=1 and isnull(IA_EstiSettle.iRdsid,0)=0) or (Purbillvouchs.bExBill=1 and isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype='01' or ia_subsidiary.cvoutype='33'))) or (isnull(IA_EstiSettle.iRdsid,0)<>0 and (ia_subsidiary.cvoutype='01' or ia_subsidiary.cvoutype='33'))) and IA_EstiSettle.dSVDate<='2006-02-28' AND (IA_EstiSettle.bAccount=0) and (isnull(IA_EstiSettle.iSVQuantity,0)<>0 or isnull(IA_EstiSettle.iSVPrice,0)<>0) AND ((Purbillvouchs.bExBill=1) or (rdrecord.cbustype='受托代銷' or (rdrecord.cbustype<>'受托代銷' and rdrecords.dsdate<='2006-02-28'))) AND ((RIGHT(IA_EstiSettle.cMonth,2)<'02') OR (IA_EstiSettle.cMonth is null)) AND IA_EstiSettle.cWhCode IN ('DD') order by IA_EstiSettle.PSVID,IA_EstiSettle.ID,ia_subsidiary.bflag desc,IA_EstiSettle.cWhCode,IA_EstiSettle.cCode 可通過如下腳本分析看where條件中如IA_EstiSettle.bAccount=0等標(biāo)志、條件是否有問題，以進(jìn)一步分析處理。 如果涉及數(shù)據(jù)庫的修改，修改前請務(wù)必做好數(shù)據(jù)備份！