问题描述:红冲销售出库单提示被拣货单引用,销售出库单点击单据联查没有拣货单。
解决办法:在引号内输入销售出库单的单据编号进行查询
SELECT b.Billcode FROM dbo.pickbill a
INNER JOIN dbo.onShelvespickIndex b ON a.billNumberID=b.billNumberId
INNER JOIN dbo.BillIndex c ON a.GoodsBillNumberID=c.BillNumberId
WHERE c.Billcode='XK-MRFZJG-T-2024-07-24-0001'