Prev
Next
Forums Lawson Design Studio

Drill from GL to AP detail

Sort:
You are not authorized to post a reply.
Author
Messages
Eddie Smith
Advanced Member
Posts: 39
Advanced Member
8/18/2010 8:49 PM
    I know per Lawson KB articel 556138, that if the system code and the source code are AP, then drill back is not available (we are seeing that on GL90.1 drill around); however, we are trying to create a portal page with DME queries that start from APPAYMENT but cannot seem to get back to APDISTRIB. Has anyone been able to do this using DS? We are able to get back to APINVOICE and get the first distribution record associated with the payment using related tables, but how can we get all?
    John Henley
    Senior Member
    Posts: 3349
    Senior Member
    8/18/2010 9:18 PM
      You can't. First of all, it's a multi-level join, which DME can't do. And (theoretically and often practically) it's a many-to-many-to-many join. =
      Thanks for using the LawsonGuru.com forums!
      John
      You are not authorized to post a reply.