From gltr_hist need to find what sales order it came from

N

nate100

Member
From a given gltr_hist record, how can I figure out what sales order it came from?
I see gltr_doc may be of use but not sure how to tie it tall together.

Thank you.
 
If the posted entry has come from the SO module (gltr_tr_type = "SO"), the Document field (gltr_doc) should contain the invoice. You can obtain the sales order from a few different places, but the easiest way is probably via the Invoice History table (ih_hist where ih_inv_nbr = gltr_doc).
 
You must log in or register to reply here.
Back
Top