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.
Not sure what version you are running but if I remember correctly, (I will check later) it is tr_xgl_ref
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.