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

Report over PO #

 4 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
sgoins
Basic Member
Posts: 4
Basic Member
3/27/2013 1:36 PM
I am trying to find a way to run AP report that provides both invoice # as well as PO#. Just wondering if anybody had any suggestions on the best way to do this? Any help would be appreciated.

Thanks!
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
3/27/2013 2:57 PM
Do you use Crystal at your site?
What kind of information besides PO# and Invoice# are you after?

We've got a bunch of Crystal report written that return this kind of information... If you can define just what you're after, I can share one with you.
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
3/27/2013 3:14 PM
If you are looking for purchase orders related to the invoice and you use some kind of a query tool you can use the table APINVOICe. this contains PO_NUMBER field that has the purchase oder number related to the invoice
sgoins
Basic Member
Posts: 4
Basic Member
3/27/2013 4:29 PM
Ruma,

We were able to write a sql query over the APINVOICE table. Thanks for your help!

Greg,

We do not use Crystal, but thanks for the reply!
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
3/27/2013 5:07 PM
APDISTRIB and/or APINVOICE are the two tables that we use most to get this kind of information.