• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization S3 Customization/Development

Joining PURCHORDER to APINVOICE

 1 Replies
 0 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
kwisser
Basic Member
Posts: 12
Basic Member
2/27/2012 6:36 PM
Is there any way to pull in PURCHORDER.PO-USER-FLD-1 into the following call?

http://lawtest.ccf.org:40203/servlet/Router/Data/Erp?_PDL=FPDE5&file=APINVOICE&FIELD=INVOICE&select=&out=csv&DELIM=|&MAX=1

I want to do something like

http://lawtest.ccf.org:40203/servlet/Router/Data/Erp?_PDL=FPDE5&file=APINVOICE&FIELD=INVOICE;PURCHORDER.PO-USER-FLD-1&select=&out=csv&DELIM=|&MAX=1

but it tells me that the reference is not valid.

Thanks,
Kevin
John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
2/28/2012 1:15 PM
Logically, you can't go from an invoice to a purchase order, since it's a many-to-many relationship via invoice lines to po lines.
Thanks for using the LawsonGuru.com forums!
John