Prev
Next
Forums Integration / Customization S3 Customization/Development

Joining PURCHORDER to APINVOICE

 1 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
kwisser
Basic Member Send Private Message
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
Send Private Message
Posts: 3351
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