AP Open Invoice Report

Sort:
You are not authorized to post a reply.
Author
Messages
Rajashanmugam
Basic Member
Posts: 18
Basic Member
    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: 468
    Veteran Member
      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
        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
          Thanks for the help. Appreciate it.
          You are not authorized to post a reply.