Joining PURCHORDER to APINVOICE

Sort:
You are not authorized to post a reply.
Author
Messages
kwisser
Basic Member
Posts: 12
Basic Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
      You are not authorized to post a reply.