PO64.1 PO Line Item History Report?

So, would a Crystal report written against POLINE table be sufficient for you? That would be a good starting point, in my opinion.

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!

did you have any luck building this report, i am being asked to create the same type of report?

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.

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.