| 解决方案： |
您好： 对帐不平的原因是由于存货明细帐IA_SUBSIDIARY表中CINVHEAD字段没有存货科目。存货和总帐对帐时，存货取IA_SUBSIDIARY的cinvhead字段不为空的记录，总帐取gl_ACCVOUCH的存货科目的md或mc记录。具体记录如下：凭证5字1404＃，1403＃。对应的外部凭证号为2005ia0000000003200和2005ia0000000003063。 凭证的coutno—id对应存货明细帐表表中cpzid字段。对应存货明细帐记录的cinvhead字段为空。 解决方法：根据仓库更新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 --使用前先备份 |