Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

SQL to link APDISTRIB to PO line Details

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
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
    Posts: 3353
    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!