Forums
Lawson S3 Procurement
Invoice Status
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
5/12/2017 2:52 PM
What Lawson table can I find invoice status?
JonA
Veteran Member
Posts: 1162
5/15/2017 6:03 PM
Table: APINVOICE
Field: REC_STATUS
0 = Unreleased
1 = Released
9 = History
apurdion
New Member
Posts: 4
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.