Views Reply Votes
Raghu Rao
Raghu
 0
How to link GLTR_HIST with idh_hist
59
3
0 (0 Votes)
Posted: Apr 16, 2019   
Votes
Phill Norrey
Phill
 1124
Replied 

Not sure what version you are running but if I remember correctly, (I will check later) it is tr_xgl_ref

 

0 (0 Votes)
Replied: Apr 16, 2019
Votes
Raghu Rao
Raghu
 0
Replied 

Thank Phil for replying so quickly. We are on EB2 SP4 version of qad and I checked the tr_xgl_ref and it is a field not used by QAD and has blank data.

Our issue is trying to get to the part number from GL as we do a lot of JL ,RV type of transactions for adjustments. In order we not miss these transactions

am starting from GLTR_HIST instead of idh_hist but having great difficulty to get the item number data. JL and RV type do not have part numbes but the other

transactions that start with "SO" , "IC"  in GLTR_HIST need part numbers for that.

Please let me know if you have any other ideas.

0 (0 Votes)
Replied: Apr 16, 2019
Votes
Phill Norrey
Phill
 1124
Replied 
Ok an old version but the logic should be the same  from the gltr_hist to trgl_det where gltr_ref = trgl_gl_ref.  then from the trgl_det to the tr_hist where trgl_trnbr = tr_trnbr
0 (0 Votes)
Replied: Apr 16, 2019
Forums
All
Forum Help
Help Using Forums