问题描述:采购入库单保存提示:调用的单据已被中止,禁止调用
处理方法:
当单据调用的订单太多,无法查询是哪张订单被中止了,可以执行以下语句查询:
select ob.Billcode,p.UserCode,p.FullName from BuyBill b
inner join BillIndex a on b.BillNumberId=a.BillNumberId
inner join OrderBill o on b.orderid=b.orderid
inner join OrderIndex ob on ob.billNumberId=o.billNumberID
inner join ptype p on o.ptypeid=p.typeId
where a.BillCode='采购入库单单号' and o.BillOver=1
