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
Thanks, but that didn't work. I need to find when the item was last sold.
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).
*Community Hub is the new name for Sage City