Last Order Date
Is there a way to identify in Acumatica the "last order date" or "most recent order date?"
I would like to create a report that would provide a customer average timeframe between sales orders as well as the timeframe from "todays date" and their last order.
The datediff function only seems to be useful when you can target the specific dates.
What if you group orders by customer and then use MAX(OrderDate)?
My test case is super simple so it may still not solve your problem, but I was able to use MAX() in a parameter to the DateDiff() function with expected results.
I don't have any quick ideas for average length of time between orders by customer within a generic inquiry.