By using this website, you agree to our Terms of Use (click here)
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.
Thank you!
What if you group orders by customer and then use MAX(OrderDate)?
@dianne-a That does tell me the last order date, thank you! Though, I don't think I could do a datediff between that number and today's date?
I'm also still struggling with my goal of reporting avg length of time between orders. These seem like a reasonable metric you would want to know.
I guess this is another case where it would be helpful if Acumatica had a SQL View tool.
Thanks for the reply!
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.
@dianne-a Thank you so much Dianne! That does does exactly what I need.
For future viewers, the formula is actually switched. Should be...
=DateDiff('d', MAX([SOOrder.OrderDate]), Today())
I'll sit on the AVG for now. Thanks again!