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

DEVELOP A REPORT FOR PO CHANGES

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
cmarcous
Basic Member
Posts: 5
Basic Member
8/25/2009 4:27 PM

    I need to develop a query selecting PO number, vendor#, Vendor name, user id, before and after images and PO Audit Update Date where a PO Change has resulted in a net increase of over $25,000 from the previous PO total amount or in the case where no previous revisions are made, the original total PO amount.  I've attempted this with POAUDIT, PURCHORDER, PO COMPANY, & APVENMAST however there is something amiss with the joins or selection criteria.  Also tried unsuccessfully with the addins.

    Thanks in advance for your assistance.

    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran Member
    8/31/2009 2:46 PM
      Without looking at your code, I'd suggest that you start with POAUDIT by itself.  find the appropriate changes on the field you need (as you know, the field number is the key).
      then, work on checking the changes - still working with POAUDIT.
      Once you have that done, you should be able to add joins to each file in turn and get the same result.