Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 284
	Members: 0
	Total: 284

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

Report for all open requisitions

3 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Bev Edwards

Veteran Member Send Private Message

Posts: 366

6/8/2018 7:19 PM

Is there a canned report that shows all open requisitions that have not been released to PO23?

We ran a query for all reqs (specified date), with a status of '9', but there are reqs in the data that are showing closed in Lawson.

JimY

Veteran Member Send Private Message

Posts: 510

6/11/2018 9:09 AM

You could run a query against the table POINTERFAC. Select those with an ORIGIN_CD of RQ.

Kat V

Veteran Member Send Private Message

Posts: 1020

6/12/2018 2:47 PM

PO234 is the canned "Show me everything in PO23".

JonA

Veteran Member Send Private Message

Posts: 1163

6/14/2018 10:34 AM

Bev, once the req has been released the non-inventory lines are immediately in PO23 unless you have an approval process in place and those reqs/lines are waiting on approval. Is that what you're looking for? Reqs with a status of Needs Approval will have R_STATUS = 1.