Prev
Next
Forums Financial Management Lawson S3 Financials

Report over PO #

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
sgoins
Basic Member
Posts: 4
Basic Member
3/27/2013 1:36 PM
    I am trying to find a way to run AP report that provides both invoice # as well as PO#. Just wondering if anybody had any suggestions on the best way to do this? Any help would be appreciated.

    Thanks!
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    3/27/2013 2:57 PM
      Do you use Crystal at your site?
      What kind of information besides PO# and Invoice# are you after?

      We've got a bunch of Crystal report written that return this kind of information... If you can define just what you're after, I can share one with you.
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      3/27/2013 3:14 PM
        If you are looking for purchase orders related to the invoice and you use some kind of a query tool you can use the table APINVOICe. this contains PO_NUMBER field that has the purchase oder number related to the invoice
        sgoins
        Basic Member
        Posts: 4
        Basic Member
        3/27/2013 4:29 PM
          Ruma,

          We were able to write a sql query over the APINVOICE table. Thanks for your help!

          Greg,

          We do not use Crystal, but thanks for the reply!
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          3/27/2013 5:07 PM
            APDISTRIB and/or APINVOICE are the two tables that we use most to get this kind of information.