Views Reply Votes
Stephen Lee
Stephen
 0
how to find work order no associated with a GL labor posting
37
2
0 (0 Votes)
Posted: Nov 08, 2018   
Votes
Francis Malengier
Francis
 13
Replied 

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

 

+1 (1 Vote)
Replied: Nov 08, 2018
Votes
Phill Norrey
Phill
 1019
Replied 
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
+1 (1 Vote)
Replied: Nov 09, 2018
Forums
All
Forum Help
Help Using Forums