Prev
Next
Forums Lawson S3 Financials

APINVOICE

Sort:
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
8/14/2014 1:48 PM
    How do I get a list of all invoices that have been paid from certain date? I need to provide auditors with a crystal report

    Mark F. Hardy
    Veteran Member
    Posts: 44
    Veteran Member
    8/14/2014 3:46 PM
      Try AP270.
      Cindy
      Advanced Member
      Posts: 29
      Advanced Member
      8/14/2014 5:17 PM
        APVENMAST has the vendor information. APPAYMENT has the payment information. On this website look under the TECH tab at data dictionary - tabels and you can find the file relationships to know where the data you need resides.
        Chesca
        Veteran Member
        Posts: 490
        Veteran Member
        6/17/2015 12:49 PM
          Thanks Cindy! How do I get to list only AP invoices/payments in certain zip codes? I tried adding the APADDRESS file but it duplicated the records.
          JonA
          Veteran Member
          Posts: 1162
          Veteran Member
          6/22/2015 7:18 PM
            APVENADDR should get you what you need.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            You are not authorized to post a reply.