Hello all, Is there any way to add "LAST ORDER DAT...
# beginners
l
Hello all, Is there any way to add "LAST ORDER DATE" of an item in/using Netsuite reports? Not the SS.
c
I have a saved search that does that:
message has been deleted
a
You can try
Formula (Date) | Summary Type: Maximum | CASE WHEN {type}='Sales Order' THEN {trandate} ELSE '01/01/1900' END
Something along those lines will gave you the latest associated sales order date. @Charles Boyer’s solution is good also. It gives you days since it was last ordered.