Prev
Next
Forums Financial Management Lawson S3 Financials

AP Open Invoice Report

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Rajashanmugam
Basic Member Send Private Message
Posts: 18
Basic Member
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 Send Private Message
Posts: 477
Veteran Member
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 Send Private Message
Posts: 1020
Veteran Member
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 Send Private Message
Posts: 18
Basic Member
1/7/2021 10:48 PM
Thanks for the help. Appreciate it.