Hi,

This is what I did in a browse (gl916, unposted transaction browse), but it can also be applied to all gl entries.

In the browse I defined a function in the local variables :

Function GetReferringDoc returns character (input  parTransType as character, input parReference as character).
define variable returnDoc as character.
returnDoc = "N/A".

if parTransType = "WO" then do:

  for first opgl_det no-lock where opgl_domain = global_domain and opgl_gl_ref = parReference,
       first op_hist no-lock where opgl_domain = op_domain and opgl_trnbr = op_trnbr:
    returnDoc = op_wo_nbr.  
  end.
end.
if parTransType = "IC" then do:
  for first trgl_det no-lock where trgl_domain = global_domain and trgl_gl_ref = parReference,
       first tr_hist no-lock where trgl_domain = tr_domain and trgl_trnbr = tr_trnbr:
    returnDoc = tr_nbr.  
  end.
end.
     
return returnDoc.
end function.

then I added a caclulated field using this function :

GetReferringDoc (glt_tr_type, glt_ref)

 

I hope this can help you.

 

kr,

Francis

 

Labor and burden transactions are stored in the op_hist.  Have you tried running Operations Accounting Report?  Depending upon which version of QAd you are using it will either be at menu 17.13.10 or in EE it will be at 16.20.13.10