Query showing where Item was last used on a AP Invoice and AR Invoice

Dear Experts,

I need to create a query that shows the Item code and the latest date where it was used on any Document (AR, AP and Inventory movements and Production....

Is there a quick way to do this?

If not, I would appreciate you showing me the right direction by only using 2 document types....

Example:

SELECT T0.[ItemCode], T0.[ItemName], 
****Last DocDate whether that was on a AP or AR Invoice**** 
FROM OITM T0