Who's On?

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

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

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

How to Find out the requesting location of an invoice

2 Replies

0 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

manish dasila

New Member

Posts: 3

4/4/2012 9:15 AM

Hi
I am trying to develop a custom report containing invoice number and the requesting location of that invoice among other fields.
I cannot see a direct relationship between APINVOICE and RQLOC or REQUESTER table.

So far I have been able to determine a relation pathway of
APINVOICE -> POLINE -> POLINESRC -> REQUESTER to determine the req location of the invoice.

Please let me know if this is correct way of getting the req location or there is some other shorter pathway to getting the req location of the invoice.

David Williams

Veteran Member

Posts: 1127

4/5/2012 10:54 AM

Sorry, I think that's the only way to get there (unless you create a database table view and base your report off of that).

JonA

Veteran Member

Posts: 1163

4/5/2012 12:09 PM

That is how I would build that report in Crystal. But you would only need to link to REQUESTER if you needed the requester's name or link to RQLOC if you needed the req location name. Otherwise POLINESRC has the requester and the req loc.