AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Last Order Date
 
Notifications
Clear all

Last Order Date  

    Last Post
RSS

WildlifeTracker
Posts: 9
 WildlifeTracker
January 12, 2021 10:31 am
(@wildlifetracker)
6-20 Posts
Joined: 3 months ago

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!

4 Replies
Dianne A
Posts: 10
 Dianne A
January 12, 2021 10:36 am
(@dianne-a)
6-20 Posts
Joined: 8 months ago

What if you group orders by customer and then use MAX(OrderDate)? 

Reply
WildlifeTracker liked
WildlifeTracker
 WildlifeTracker
(@wildlifetracker)
Joined: 3 months ago

6-20 Posts
Posts: 9
January 12, 2021 11:36 am
Reply toDianne ADianne A

@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!

This post was modified 4 days ago by WildlifeTracker
Reply
Dianne A
Posts: 10
 Dianne A
January 12, 2021 12:26 pm
(@dianne-a)
6-20 Posts
Joined: 8 months ago

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.

image

I don't have any quick ideas for average length of time between orders by customer within a generic inquiry. 

Reply
WildlifeTracker liked
WildlifeTracker
 WildlifeTracker
(@wildlifetracker)
Joined: 3 months ago

6-20 Posts
Posts: 9
January 12, 2021 2:51 pm
Reply toDianne ADianne A

@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!

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,644 Topics
7,640 Posts
2 Online
1,099 Members

Latest Post: Adding bill description on check stub Our newest member: mlaraiv Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×