Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 297
	Members: 0
	Total: 297

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Invoice Status

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

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: 1163

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.