Message Boards

How to link GLTR_HIST with idh_hist

Raghu Rao, modified 3 Years ago.

How to link GLTR_HIST with idh_hist

Post Date: 4/15/19 (Bronze, 5 Posts) Recent Posts

Have a need to link gltr_hist with idh_hist to get item number details. The GLTR_line is not same as idh_line. The trgl_det which links gltr_hist and tr_hist does not store GL Reference that begins with

"SO". One project code can have multiple line items and the gltr_project idh_project will be same for all the line items.

Am at a loss to find out which item in the invoice links to GLTR_HIST record.

Please help!!!

 

link gltr_hist with idh_hist
thumbnail
Phill Norrey, modified 7 Years ago.

Re: How to link GLTR_HIST with idh_hist

Post Date: 4/15/19 (Yoda, 1010 Posts) Recent Posts

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

 

Raghu Rao, modified 7 Years ago.

Re: How to link GLTR_HIST with idh_hist

Post Date: 4/16/19 (Bronze, 5 Posts) Recent Posts

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.

thumbnail
Phill Norrey, modified 7 Years ago.

Re: How to link GLTR_HIST with idh_hist

Post Date: 4/16/19 (Yoda, 1010 Posts) Recent Posts
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

Message place holder