Sage 100

MAS 4.4 PU8 - Client has 60 inventory items that they need to know the last sold data, invoice # and unit price for for specific group of customers. Is there any native way to pull this data out? Or are we talking a Crystal report?

I'd say Crystal.

What about the customer last purchase history screen?

Thanks - Problem with last purchase screen is they want to know the last time any customer within the group (25 in the group) bought it. 60 items X 25 customers makes inquiry a PITA. What is even more painful is that there are 23,000 item records and they only need info on 60................

I think you could then create a Crystal Report based on the last purchase history to limit it to just those 60 items and only the last record (although some items could be sold multiple times on the same day to different customers).

Jeff, you could use BIE. Remember to open preview on invoice visit view.

Epilogue - I ran a query in AR History for all item type ""1"" for the past 10 years for any customer beginning with ""Carg"". This pulled 76K lines. I then inserted a column in that data, inserted an @vlookup formula to return a 1 or zero if that detail line was one of the 60. From there, I created a pivot table filtering on the 1's (included items). I wasn't able to JUST display the most recent invoice for each item, but I got it close enough for the client to take it the final yard. Spent about 45 minutes on the project. Priced the project at three hours of value.