Invoice Line item detail

Sort:
You are not authorized to post a reply.
Author
Messages
Parx400
New Member
Posts: 2
New Member
    I am working on a project where I have most of the Lawson tables extracted and put into ACL(Audit tool). I have Invoice numbers for invoices that were paid in 2011 and 2012 after running APPAYMENT and APINVOICE. I need to know the line item detail of these invoices so I can see what the paid price was fro each item. I have aprox 2.3 mil line items associated with the PO numbers found in APINVOICE. I need to be able to join the POlines that have PO pricing to the actual price paid on the invoice and see the difference.

    I have all the parts I need except the price paid for each item on the invoices. What table is this located in?

    Thank you
    Bob Canham
    Veteran Member
    Posts: 217
    Veteran Member
      Hi, assuming you are using Detail Matching, you should be able to get the line details from MAINVDTL.
      Parx400
      New Member
      Posts: 2
      New Member
        That File seems to be pretty small. Are EDI Invoiced kept in MACINVDTL?
        Bob Canham
        Veteran Member
        Posts: 217
        Veteran Member
          Are you using the Invoice Matching module to do a Detail Match for invoices you bring in with EDI? If you are, then you should see the records here, but if not, I don't think you will be able to find the line item details. If you bring up the invoice in AP90 and drill around, you should see an "Invoice Line Detail" folder if you have match information for the Invoice.
          You are not authorized to post a reply.