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.

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

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. 

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

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