Prev
Next
Forums Financial Management Lawson S3 Financials

PO64.1 PO Line Item History Report?

 5 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Dave McGown
New Member
Posts: 2
New Member
3/29/2012 4:52 PM
    We use PO64.1 a lot to view activity on PO lines. We have been looking but cannot find a report that would print out this same information so we could dump it to excel. Does one exist? We would like to be able to look at the PO Line Item History for all our open Capital PO's. (Note we do not have Add-Ins but I do use Crystal Reports).

    Thanks!

    Dave

    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    3/29/2012 5:47 PM
      So, would a Crystal report written against POLINE table be sufficient for you? That would be a good starting point, in my opinion.
      Dave McGown
      New Member
      Posts: 2
      New Member
      3/29/2012 7:57 PM
        Yes, That is where I will need to start and then bring in the APINVOICE, MAINVDTL tables to show the activity. Just was looking for a shortcut with a big pile of work on my desk! Thanks!
        cperry67
        New Member
        Posts: 1
        New Member
        8/2/2012 5:48 PM
          did you have any luck building this report, i am being asked to create the same type of report?
          mark.cook
          Veteran Member
          Posts: 444
          Veteran Member
          8/2/2012 7:51 PM
            I have built this in crystal, I started with MAINVDTL and then added the POLINE, Purchorder, APInvoice, Venmast and it worked ok. The piece I orginally missed was returns and voids so I had to add those into the mix. If you're looking for an easy solution that ties to PO64 then I will be the first to push you toward Mashup Designer. Much easier to pull all that data together in one nice view and interact with the data.

            This PO64 report took a couple of weeks in work time to get nailed down. Then add some another week or two for tweaks and formatting changes from users. The key thing with starting with MAINVDTL is that you have a timing issue of getting all the data until you have Invoices in Lawson. Starting with the PO would be a better starting point but at this point, to many other priorities to recode that change.
            Adam Jacobson
            Veteran Member
            Posts: 69
            Veteran Member
            8/3/2012 2:24 PM
              I would start with POLINE and then create LEFT OUTER JOINS to the appropriate MAINVDTL (invoice detail) and PORECLINE receipt files. There are others that you may want but that will get your started.

              the tricky part here is that PO64.1 combines different records into the same "fields" on the bottom of the report so it takes a little manipulation to get everything to line up correctly.