Skip to main content
Solved

Is Acumatica storing last Sales Order created date for a Customer?


Is Acumatica storing last Sales Order created date for a Customer?

Best answer by ChandraM

Hi @ranjithd46 If you are just looking to find the customer’s last order’s created datetime you have the existing Sales orders Generic Inquiry or have a new generic inquiry based on your requirements.

If you are looking to use this on your customization, then create a BQL view for the below SQL:

Example: Select max(CreatedDatetime) from SOOrder where Customerid=’ABCStudios’ or use the Current Customer.

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • October 10, 2023

HI @ranjithd46 

There is not a field that holds that. The only way to find the last order date is you could use the Sales Order Details by Customer report. 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • Answer
  • October 10, 2023

Hi @ranjithd46 If you are just looking to find the customer’s last order’s created datetime you have the existing Sales orders Generic Inquiry or have a new generic inquiry based on your requirements.

If you are looking to use this on your customization, then create a BQL view for the below SQL:

Example: Select max(CreatedDatetime) from SOOrder where Customerid=’ABCStudios’ or use the Current Customer.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 10, 2023

Hello @ranjithd46 ,

You may be able to make a quick GI to show you customer and last order date, using Customer table and SoOrder table:

Laura


Forum|alt.badge.img+1

In SO screen , You need filter by customer and order the date in descending . Please refer bellow screen print 

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • November 13, 2023
ranjithd46 wrote:

Is Acumatica storing last Sales Order created date for a Customer?

No, Acumatica is not storing the Last Sales Order for a Customer. As mentioned, you can work with the GI @ranjithd46 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings