Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

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

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

Req_number and related PO_number

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

fategolf

New Member

Posts: 1

4/12/2007 4:22 PM

Is there a way to determine the PO_NUMBER that is related to a particular REQ_NUMBER other than using the POLINESRC.SOURCE_DOC_N?

John Henley

Posts: 3353

4/13/2007 10:57 AM

That is the correct way (POLINE) to relate Requisitions to Purchase Orders. Keep in mind that it should ideally be done at the line level (REQLINE to POLINE). If you're trying to do this for reporting purposes, make sure you include other key/index fields as well for efficiency purposes.