Prev
Next
Forums Lawson S3 Procurement

Invoice Status

Sort:
You are not authorized to post a reply.
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
5/12/2017 2:52 PM
    What Lawson table can I find invoice status?
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
    5/15/2017 6:03 PM

      Table: APINVOICE

      Field: REC_STATUS


      0 = Unreleased
      1 = Released
      9 = History
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      apurdion
      New Member
      Posts: 4
      New Member
      6/30/2022 3:10 PM
        When running a SQL query they only results are 0, 1, & 9, but when you pull an addins query there are transactions that return a cancelled status. Is there another indicator in the database that shows the difference between the regular 9 = history and 9 = cancelled? I can see that there is a field (CANCEL_SEQ), but don't understand why the addins query can decipher the cancelled vs history.
        You are not authorized to post a reply.