问题现象: | 年度结转报错,存在已记帐但是没有暂估成本的单据, |
问题原因: | |
解决方案: | 您好: 可以在查询分析器中执行下面语句,找出采购入库单没有暂估单价和暂估金额的记录,然后根据其记账单价将暂估单价facost和暂估金额iaprice加上,如记账单价、记账金额为空,则填为0: select iaprice as 暂估金额,facost as 暂估单价,iainprice as 记账金额,iincost as 记账单价,* from rdrecord inner join rdrecords on rdrecord.id=rdrecords.id inner join ia_subsidiary ON IA_Subsidiary.ID = RdRecords.AutoID WHERE ((IA_Subsidiary.cVouType='33' And IA_Subsidiary.cSrcVouType='01') Or IA_Subsidiary.cVouType='01') and rdrecord.cvouchtype='01' and isnull(rdrecords.cbaccounter,'')<>'' and (rdrecords.facost is null or rdrecords.iaprice is null) 如有问题,请及时反馈! |
相关补丁: | |
版本: | 8.71 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 存货年度结转报错 |
最后更新: | 2012-02-10 23:17:24 |