Miscellaneous Receipts

Question

Hi, 
 I am trying to run a query to pull fields from the screen Miscellaneous Receipts. The three things I need to pull are Quantity/Product/Receipt Date/Supplier Lot Number. I looked at the screen level and did not find a table from which I can pull this from. 
 Version: 7 
 Thanks,

Delamater · Answer

You can try this: 
 
 SELECT smh.VCRNUM_0, smh.STOFCY_0, smh.IPTDAT_0, smd.QTYPCU_0, smd.ITMREF_0, stj.BPSLOT_0 FROM SEED.SMVTH smh INNER JOIN SEED.SMVTD smd ON smh.VCRTYP_0 = smd.VCRTYP_0 AND smh.VCRNUM_0 = smd.VCRNUM_0 INNER JOIN SEED.STOJOU stj ON stj.VCRNUM_0 = smh.VCRNUM_0 AND stj.STOFCY_0 = smh.STOFCY_0 AND stj.VCRTYP_0 = smd.VCRTYP_0 AND stj.VCRLIN_0 = smd.VCRLIN_0 AND stj.ITMREF_0 = smd.ITMREF_0 AND stj.REGFLG_0 <> 2 WHERE smh.VCRNUM_0 = 'MRCGB0230006'

Sage X3

Miscellaneous Receipts

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING