問題現(xiàn)象：7月份，在存貨核算中與總帳對(duì)帳時(shí)不平（金額檢查）包裝物和產(chǎn)成品不平. 解決方案：您好： 對(duì)帳不平的原因是由于存貨明細(xì)帳IA_SUBSIDIARY表中CINVHEAD字段沒有存貨科目。存貨和總帳對(duì)帳時(shí)，存貨取IA_SUBSIDIARY的cinvhead字段不為空的記錄，總帳取gl_ACCVOUCH的存貨科目的md或mc記錄。具體記錄如下：憑證5字1404＃，1403＃。對(duì)應(yīng)的外部憑證號(hào)為2005ia0000000003200和2005ia0000000003063。 憑證的coutno—id對(duì)應(yīng)存貨明細(xì)帳表表中cpzid字段。對(duì)應(yīng)存貨明細(xì)帳記錄的cinvhead字段為空。 解決方法：根據(jù)倉(cāng)庫(kù)更新cinvhead字段 use ufdata_800_2005 go select * from ia_subsidiary where imonth=7 and cpzid='2005ia0000000003200' go select * from ia_subsidiary where imonth=7 and cpzid='2005ia0000000003063' go update ia_subsidiary set cinvhead='128' where imonth=7 and cpzid='2005ia0000000003063' and cwhcode='03' go update ia_subsidiary set cinvhead='13701' where imonth=7 and cpzid='2005ia0000000003063' and cwhcode='01' go update ia_subsidiary set cinvhead='13701' where imonth=7 and cpzid='2005ia0000000003200' and cwhcode='01' go --使用前先備份