Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

SQL to link APDISTRIB to PO line Details

Sort:
You are not authorized to post a reply.
Author
Messages
Peter Brayton
New Member
Posts: 3
New Member
3/25/2009 2:51 PM

    Hello,

      Has anyone successsfully linked apdistrib records back to the PO line items that make up that amount specific amount, i.e. Qty X Price = Ext amount?  I have had some success, but not consistent success with all PO's.  Just checking to see what level of success others have had.

    Thanks.

    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    3/25/2009 5:29 PM
      I have done some work on backlink reports like this (as well as further from GL and AC), and this one is tough. Particularly because of many-to-many relationships between AP invoice, PO receipt, PO line, req line, etc. As well as potentially different UOMs for req, po, receipt, invoice, etc. Some times you have to accept "good enough" (e.g., matching at vendor only), and just report what is there :)
      Thanks for using the LawsonGuru.com forums!
      John
      Peter Brayton
      New Member
      Posts: 3
      New Member
      3/27/2009 1:27 PM
        Thank You John for your reply!
        You are not authorized to post a reply.