要求:
按進貨單別單號查詢進貨單,打印進貨單中包含的所有物料的條碼;
條碼規則:
品號+批號+單別單號;
條碼版面:
包含:條碼,品號,品名,規格;
帶入單身設置:
默認帶入實際采購數量,增加列【條碼打印數量】,由用戶輸入;
select * from DSCSYS.dbo.ADMMD where MD001='PURTH'
select * from PURTH where TH001='3404' and TH002 like '16%'
select TG001,TG002,TG042 from PURTG where TG001='3404' and TG002 like '16%'
select * from INVTF where TF002>='1512001'