Solved

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

  • 10 October 2023
  • 5 replies
  • 68 views

Userlevel 1

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

icon

Best answer by ChandraM 10 October 2023, 23:02

View original

5 replies

Userlevel 7
Badge +17

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 

Badge

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

 

 

Badge +18

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

Userlevel 7
Badge +9

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.

Userlevel 7
Badge +16

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. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved