https://netsuiteprofessionals.com logo
m

mattb

01/10/2017, 3:59 AM
the criteria is just the customers and item record. the formula i was trying to adapt from a saved search that lists all customers and their last transaction date (even those who have not purchased) is: CASE WHEN {type} = 'Invoice' then {trandate} ELSE NULL END