Date of Last Part Sold

You should be able to do that as a direct search on customer order lines, export it and use excel tools to do that if you don’t have access to create quick reports or the SQL query tool.

If you can create the SQL query for the information you want to see, it would be something like this:

ID                  NUMBER
USER_ID            NUMBER
DATE_ADDED          DATE
DATE_VIEWED        DATE
DOCUMENT_ID        VARCHAR2
URL                VARCHAR2
DOCUMENT_TITLE      VARCHAR2
DOCUMENT_DATE        DATE

Select * 
FROM test_table 
WHERE user_id = value 
AND date_added = (select max(date_added) 
   from test_table 
   where user_id = value)

What do you mean by “Sold”, specifically Customer Order Lines ? Or do you include stuff from like Sales Contracts items in there, that get pushed to Project Invoices through application for payment ?

If you mean just customer order lines, this query will do it:

select distinct p.part_no,
max(t.date_entered) as latest_order_line_date
from ifsapp.part_catalog p
left join ifsapp.customer_order_line t on t.part_no = p.part_no

group by p.part_no

You’ll need to possibly add filters on the Customer Order Lines as right now this includes any status including cancelled lines.