单品转柜错误(购销处理)
begin tran
--删除转柜记帐单
delete unaccsheet0 where sheettype in (2371,2372) and venderid=3210 and shopid='A002'
--更新商品柜组属性
update countergoods set counterid=2501,countgroupid=2501 where goodsid=86075 and shopid='A002'
--更新销售柜组
update salegoods201201 set countgroupid=2501 where goodsid=86075 and shopid='A002' and sdate>='20120110'
--更新成本柜组
update salecost201201 set countgroupid=2501 where goodsid=86075 and shopid='A002' and sdate>='20120110'
update rpt_d_shopsstock set countgroupid=2501 where goodsid=86075 and shopid='A002' and sdate>='20120110'
commit
1/1, 0«‹1›»