Where can I find the last date of sale for particular item or items?
271
260
Where can I find the last date of sale for particular item or items?
OESHDT, or OEAUDD
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.
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
*Community Hub is the new name for Sage City