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
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
    Posts: 476
    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
      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
        Posts: 18
        Basic Member
        1/7/2021 10:48 PM
          Thanks for the help. Appreciate it.