+ Reply to Thread
Results 1 to 2 of 2

Thread: From gltr_hist need to find what sales order it came from

  1. #1
    Join Date
    Jun 2007
    Posts
    112
    Rep Power
    17

    Default From gltr_hist need to find what sales order it came from

    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.

  2. #2
    Join Date
    Aug 2006
    Posts
    21
    Rep Power
    14

    Default Re: From gltr_hist need to find what sales order it came from

    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).

+ Reply to Thread

Similar Threads

  1. Sales Order Delete
    By gtmsb in forum QAD's MFG/PRO
    Replies: 12
    Last Post: 25 Sep 2008, 06:46 PM
  2. Replies: 0
    Last Post: 3 Jul 2008, 08:56 AM
  3. Sales Order
    By gtmsb in forum QAD's MFG/PRO
    Replies: 1
    Last Post: 28 Sep 2006, 03:57 AM
  4. Discrepancy in Sales Order
    By gtmsb in forum QAD's MFG/PRO
    Replies: 1
    Last Post: 19 Jul 2006, 12:58 AM
  5. Sales Order
    By gtmsb in forum QAD's MFG/PRO
    Replies: 0
    Last Post: 26 Jun 2006, 09:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts