Skip to main content
Solved

Daily Sales Report

  • January 5, 2023
  • 2 replies
  • 329 views
  • Translate All

Forum|alt.badge.img

Hi All,

 

Our company is looking for a custom daily report which runs automatically in the evening and distributes to a email list. The report would consist of all the SO’s entered in that day. So first, what would you recommend for a GI build? A simple copy and customization of the Sales Order screen and then just setting up a automated schedule?

Best answer by Manikanta Dhulipudi

Hi @byates 

Created a Generic inquiry which shows the Order created for “Today”

Using Business events, Schedule a Business events and attached the Sales order summary report that sent to each person at the end of the Day.

Attaching Business events and GI for your review.

 

View original

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

Hi @byates! Your proposition sounds fine, copy the GI and potentially remove any tables which aren’t directly related to populating SO order numbers or data needed. There is a great article on troubleshooting Business Events:

 

Translate

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

Hi @byates 

Created a Generic inquiry which shows the Order created for “Today”

Using Business events, Schedule a Business events and attached the Sales order summary report that sent to each person at the end of the Day.

Attaching Business events and GI for your review.

 

Translate