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
Chris Martin	825

How to Find out the requesting location of an invoice

2 Replies

0 Subscribed to this topic

40 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

New Poster

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.