AP Query

Sort:
You are not authorized to post a reply.
Author
Messages
Boyd
Advanced Member
Posts: 39
Advanced Member
    I am looking to create a query that includes vendor #, vendor description, payment # and payment date. Any thoughts or help is appreciated.

    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      APPAYMENT for the vendor number, payment number and payment date. Link to APVENMAST for the vendor name.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      O. Johnson
      Basic Member
      Posts: 8
      Basic Member
        Below SQL returns the data for one vendor for all checks cut in 2018:

        SELECT ap.vendor AS vendor,
        TRIM (v.vendor_vname) AS vendor_name,
        TRIM (ap.invoice) AS invoice,
        ap.tran_chk_amt AS check_amount,
        ap.check_date AS check_date
        FROM lawson.appayment ap, lawson.apvenmast v
        WHERE ap.vendor = v.vendor
        AND ap.void_seq <> 9999
        AND TO_CHAR(ap.check_date, 'YYYY') = '2018'
        AND ap.vendor = ' 36600'
        Boyd
        Advanced Member
        Posts: 39
        Advanced Member
          Thank you for the help. I have a query that is pulling total spend for an accounting unit for 2017. This results in many vendors being pulled into my query. Any thoughts on how to accomplish this from AP items coded to an accounting unit during a year.

          O. Johnson
          Basic Member
          Posts: 8
          Basic Member
            Table APDISTRIB is going to have the coding, column DIS_ACCT_UNIT is the accounting unit it was coded to.
            Boyd
            Advanced Member
            Posts: 39
            Advanced Member
              Any idea where payment is stored so that it can be linked?

              You are not authorized to post a reply.