Who's On?

	Membership:
	Latest: Kenny
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5214

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

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

v10 - Requisition Release Date

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

RobJC

Basic Member

Posts: 8

New Poster

5/5/2017 6:23 PM

Is there a table that tracks all of the requisition release dates? When I view the REHEADER and REQLINE tables I only see the latest and greatest. We use custom workflows for our procurement, and there are times when requisitions are released and returned for edits. Then re-released for approvals. I think I may have found something in the PFIWORKUNIT table, but I wanted to get a different perspective on this issue. Thank you.

Kat V

Veteran Member

Posts: 1020

New Poster

Engaged Reader

Avid Reader

5/9/2017 8:49 PM

Not that I know of, in v10 there is a lawson.rqaudit table, you may try there. You can see it in query wizard.

For what it's worth, our IPA creates a comment when the workunit is created with the workunit number. We can tell when something's been unreleased and re-released by that comment trail. It would have multiple workunits.