Link Goods in Receiver to Transaction Number in TR_Hist

[stewartsetter]

Hi All,

I'm trying to link the Goods in Receiver to the transaction number from the transaction history table, is there a table that has this data or any thoughts on how to link them.

Also, using an 1990's version of MFG so all extraction is done by CyberScience extration tool.


Thanks,
Stewart

 

[mosfin]

purchase receivers are stored in table: prh_hist
the link to tr_hist AFAIK is like this:

for each prh_hist no-lock
      where prh_rcp_date >= date1  and prh_rcp_date <= date2
    ,each tr_hist no-lock
      where tr_type="RCT-PO" 
      and tr_nbr=prh_nbr
      and tr_effdate=prh_rcp_date
      and tr_line=prh_line
      and tr_lot=prh_receiver
      and tr_part=prh_part 
      use-index tr_nbr_eff :
   display tr_trnbr.
end.