Add in Query for AP Data

Sort:
You are not authorized to post a reply.
Author
Messages


AaronH











New Member



Posts: 1




New Member



     

    I have written an add in query for AP data with the below fields. This query works but due to a condition within the criteria it is excluding non-PO invoices. I need to see both PO and non-PO invoices. Is there a work around for this query or another way to write it such that I can get both?

    Fields:

    mmdist.company, mmdist.acct_unit, mmdist.account, vendor, apvenmast.vendor-sname, po-number, invoice, apinvoice.tran.inv.amt, apinvoice.invoice.dte, distrib_date, item, item-desc, ent_uom, ent_unit_cst, entered_qty, tot-dist-amt

     

    Thanks!

     

     

     



    JonA











    Veteran Member



    Posts: 1162




    Veteran Member



      Instead of using MMDIST and POLINE, try using APDISTRIB and APINVOICE. I think you can get all of the fields above from those two and it should include both PO and non-PO activity.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      You are not authorized to post a reply.