x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 137 subscribers
  • Views 2144 views
  • Users 0 members are here
Browse Forums
Announcements
235
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
411
replies
Sage Intelligence Reporting
121
topics
322
replies
Ancient Nutrition

Miscellaneous Receipts

SUGGESTED
Posted By

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,

  • 0
    SUGGESTED

    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'

*Community Hub is the new name for Sage City