Solved

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

  • 10 October 2023
  • 5 replies
  • 73 views
R
Rank
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

C
Rank
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.

Chandra M
Laura02
Rank
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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ ⏩ https://www.augforums.com/episode130/
Naveen Boga
Rank
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 

Naveen B
Kandy Beatty
Rank
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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
H
Rank
Badge

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

 

 

Reply


Terms & ConditionsCookie settings
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