--入库审核时,写入K3时报错
--第一种情况:入库数量超过了订单数。SQL检查如下:
select a.fincommitqty 订单已入库数 ,a.fqty as 订货数 ,b.FQty 本次入库数,b.FItemIDNumber ,b.FItemIDName,b.OrderCode ,b.OrderSubID ,b.CustOrderCode, *
from dm..SEOrderEntry
a right join KF_In2_Sub b on a.FInterID =b.OrderMainID and a.FEntryID =b.OrderSubID
where b.in2MainID=504
and a.FInCommitQty +b.FQty >a.FQty
--第一种情况:入库数量超过了订单数。SQL检查如下:
select a.fincommitqty 订单已入库数 ,a.fqty as 订货数 ,b.FQty 本次入库数,b.FItemIDNumber ,b.FItemIDName,b.OrderCode ,b.OrderSubID ,b.CustOrderCode, *
from dm..SEOrderEntry
a right join KF_In2_Sub b on a.FInterID =b.OrderMainID and a.FEntryID =b.OrderSubID
where b.in2MainID=504
and a.FInCommitQty +b.FQty >a.FQty