PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/14/2016 12:56 PM by  JonA
Add in Query for AP Data
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
AaronH
Decision Support Analyst
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
04/08/2016 4:11 PM

     

    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
    Private
    Private
    Veteran Member
    (2819 points)
    Veteran Member
    Posts:991


    Send Message:

    --
    04/14/2016 12:56 PM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.