• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Invoice Line item detail

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Parx400
New Member
Posts: 2
New Member
6/27/2013 6:53 PM
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
6/27/2013 7:14 PM
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
6/27/2013 10:46 PM
That File seems to be pretty small. Are EDI Invoiced kept in MACINVDTL?
Bob Canham
Veteran Member
Posts: 217
Veteran Member
6/28/2013 2:34 PM
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.