Is Acumatica storing last Sales Order created date for a Customer?
Is Acumatica storing last Sales Order created date for a Customer?
Userlevel 7
+19
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
In SO screen , You need filter by customer and order the date in descending . Please refer bellow screen print
+18
Hello
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
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
+16
HI
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.