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
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: 3353
    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