Prev
Next
Forums Lawson S3 Supply Chain

How to Find out the requesting location of an invoice

Sort:
You are not authorized to post a reply.
Author
Messages
manish dasila
New Member
Posts: 3
New Member
4/4/2012 9:15 AM
    Hi
    I am trying to develop a custom report containing invoice number and the requesting location of that invoice among other fields.
    I cannot see a direct relationship between APINVOICE and RQLOC or REQUESTER table.

    So far I have been able to determine a relation pathway of
     APINVOICE  -> POLINE -> POLINESRC -> REQUESTER to determine the req location of the invoice.

    Please let me know if this is correct way of getting the req location or there is some other shorter pathway to getting the req location of the invoice.
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    4/5/2012 10:54 AM
      Sorry, I think that's the only way to get there (unless you create a database table view and base your report off of that).
      David Williams
      JonA
      Veteran Member
      Posts: 1162
      Veteran Member
      4/5/2012 12:09 PM
        That is how I would build that report in Crystal. But you would only need to link to REQUESTER if you needed the requester's name or link to RQLOC if you needed the req location name. Otherwise POLINESRC has the requester and the req loc.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        You are not authorized to post a reply.