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

Report over PO #

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
sgoins
Basic Member Send Private Message
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 Send Private Message
Posts: 1498
Veteran Member
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 1498
Veteran Member
3/27/2013 5:07 PM
APDISTRIB and/or APINVOICE are the two tables that we use most to get this kind of information.