问题描述:
5000G3.74第一次业务结账时,选择自动检查库存成本发生异常的货品并勾选所有选项,结转完成后期初库存金额为零的货品数量全部被清零。
解决方法:
广西速达软件建议您:只能从后台修复数据:fkq速达财务官网
--修复期初库存fkq速达财务官网
insert into aa_storebalance fkq速达财务官网
select 2010 posyear,10 posmonth,storeid,goodsid,quantity bqty,fkq速达财务官网
price bprice,amount bamount,0.0 inqty,0.0 inamount,0.0 outqty,fkq速达财务官网
0.0 outamtqty,quantity eqty,price eprice ,amount eamount,quantity brqty,fkq速达财务官网
0.0 inrqty,0.0 outrqty,0.0 erqty,0.0 bextqty,0.0 inextqty,fkq速达财务官网
0.0 outextqty,0.0 eextqty,0.0 brextqty,0.0 inrextqty,0.0 outrextqty,fkq速达财务官网
0.0 erextqty fkq速达财务官网
from aa_billflow fkq速达财务官网
where billtype < 0 and quantity <> 0 and fkq速达财务官网
cast(storeid as varchar(2))+cast(goodsid as varchar(20)) not in fkq速达财务官网
(select cast(storeid as varchar(2))+ cast(goodsid as varchar(20)) fkq速达财务官网
from aa_storebalance fkq速达财务官网
where posyear = 2010 and posmonth =10 fkq速达财务官网
)fkq速达财务官网
gofkq速达财务官网
update aa_storebalance set bqty = bb.bqty fkq速达财务官网
from aa_storebalance aa, fkq速达财务官网
(select a.quantity bqty,a.goodsid,a.storeid fkq速达财务官网
from aa_storebalance b,aa_billflow a fkq速达财务官网
where a.goodsid=b.goodsid and a.storeid =b.storeid and b.posyear=2010 and b.posmonth=10 fkq速达财务官网
and b.bqty<>a.quantity and a.billtype < 0 and a.quantity <> 0fkq速达财务官网
) as bb fkq速达财务官网
where aa.storeid=bb.storeid and aa.goodsid=bb.goodsid and aa.posyear=2010 and aa.posmonth =10 fkq速达财务官网
and aa.bqty <> bb.bqtyfkq速达财务官网
gofkq速达财务官网
--这两个数应一致fkq速达财务官网
select * from fkq速达财务官网
(select sum(quantity) bqty from aa_billflow where billtype < 0 fkq速达财务官网
union allfkq速达财务官网
select sum(bqty) bqty from aa_storebalance where posmonth =10 and posyear =2010fkq速达财务官网
) as mmfkq速达财务官网 ...
转载请注明文章来自广西速达软件,本文地址:/questions/5000/2011-10-10/4270.html
版本分类:速达5000系列
模块分类:/系统维护/账务系统
附 件:
以上方法还不能解决您的问题?点击联系技术员>>
|