OESHDT, or OEAUDD

Thanks, but that didn't work. I need to find when the item was last sold.

select from OEAUDD, order by DAYENDNUM descending, and grab the TOP 1 record.  Or, join to OEAUDH and grab MAX(INVDATE).

I/C Transaction History Inquiry will show you.  Look for the last shipment at the bottom of the list.

I need a report that can be produced to show the last sale date for all items in the database. Your suggestion only allows me to inquire per item.

SELECT ITEMNO, MAX(TRANSDATE) AS LASTDATE FROM ICHIST

WHERE TRANSTYPE = 4

GROUP BY ITEMNO ORDER BY ITEMNO

IC Location details stores LAST SHIP DATE and LAST RECEIPT DATE.   Seems a lot simpler to just use that date.