存货对帐不平
发布于:2018-02-13 14:12:38
问题现象:7月份,在存货核算中与总帐对帐时不平(金额检查)包装物和产成品不平.
解决方案:您好: 对帐不平的原因是由于存货明细帐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 --使用前先备份