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

AP Open Invoice Report

 3 Replies
 0 Subscribed to this topic
 44 Subscribed to this forum
Sort:
Author
Messages
Rajashanmugam
Basic Member
Posts: 18
Basic Member
New Poster
New Poster
Congrats on posting!
12/9/2020 8:24 PM
Open Invoice Report. Need to create one. My Manager wants to see the combination of AP150 and AP136 before running AP150. They want to run this report on demand and decide which invoice is to be paid and which one is not to be.

Researched and looked into AP20 and AP30 screens along with AP150 and AP136's table list here in LawsonGuru.com. The list is long.

Started with APINVOICE, looking into APDISTRIB, but stuck here. Business users are not as much help as they also do not know how to help/explain. All I got is screen names and process that they follow on processing the invoices. But that does not help as much.

Can anyone help?

Raj
Ragu Raghavan
Veteran Member
Posts: 477
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
12/9/2020 8:43 PM
I would think SELECT APINVOICE WHERE REC_STATUS = 1 will give you all the released Invoice open for payment.
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
12/11/2020 8:00 PM
Values I know: 0 = Unreleased; 1 = Released and 9 = Paid -- the unreleased ones are what we look at when working buyer messages.
Rajashanmugam
Basic Member
Posts: 18
Basic Member
New Poster
New Poster
Congrats on posting!
1/7/2021 10:48 PM
Thanks for the help. Appreciate it.