Skip to main content
Solved

Email Template Group By Function

cmoreland
Semi-Pro III
Forum|alt.badge.img

I have an email template that I would like to send that summarizes the days shipments. 

Is there a way to group by shipment nbr but still show the lines? Something like:

 

ShipmentNbr1

Line1 

Line2 

ShipmentNbr2

Line1 

Line2 

Best answer by chrisgold

cmoreland wrote:
chrisgold wrote:

I was attempting something similar today with PPV by line. It looked like the intension for business events with larger data results is to schedule the delivery of a report.

On SM204003 - Email Templates > Attach reports - you could have a ‘shipments’ report, with a parameter set for @today on ship date.

Thanks @chrisgold  I was thinking this would be the path. I was just hoping there was a quick email function that would work while we developed a bigger report. 

In our instance there appears to be a standard report “SO621500 - Shipment Details by Inventory Item”, you might be able to adapt that fairly easily, or might work as a stop-gap measure.

View original
Luck is what happens when preparation meets opportunity. ~Seneca
Kandy Beatty
1 person likes this
  • Kandy Beatty
    Kandy Beatty
Did this topic help you find an answer to your question?

3 replies

C
Jr Varsity II
Forum|alt.badge.img
  • chrisgold
  • Jr Varsity II
  • 27 replies
  • June 6, 2024

I was attempting something similar today with PPV by line. It looked like the intension for business events with larger data results is to schedule the delivery of a report.

On SM204003 - Email Templates > Attach reports - you could have a ‘shipments’ report, with a parameter set for @today on ship date.

cmoreland
Chris Hackett
2 people like this
  • cmoreland
    cmoreland
  • Chris Hackett
    Chris Hackett
cmoreland
Semi-Pro III
Forum|alt.badge.img
  • cmoreland
  • Author
  • Semi-Pro III
  • 109 replies
  • June 6, 2024
chrisgold wrote:

I was attempting something similar today with PPV by line. It looked like the intension for business events with larger data results is to schedule the delivery of a report.

On SM204003 - Email Templates > Attach reports - you could have a ‘shipments’ report, with a parameter set for @today on ship date.

Thanks @chrisgold  I was thinking this would be the path. I was just hoping there was a quick email function that would work while we developed a bigger report. 

Luck is what happens when preparation meets opportunity. ~Seneca
C
Jr Varsity II
Forum|alt.badge.img
  • chrisgold
  • Jr Varsity II
  • 27 replies
  • Answer
  • June 6, 2024
cmoreland wrote:
chrisgold wrote:

I was attempting something similar today with PPV by line. It looked like the intension for business events with larger data results is to schedule the delivery of a report.

On SM204003 - Email Templates > Attach reports - you could have a ‘shipments’ report, with a parameter set for @today on ship date.

Thanks @chrisgold  I was thinking this would be the path. I was just hoping there was a quick email function that would work while we developed a bigger report. 

In our instance there appears to be a standard report “SO621500 - Shipment Details by Inventory Item”, you might be able to adapt that fairly easily, or might work as a stop-gap measure.

cmoreland
Chris Hackett
2 people like this
  • cmoreland
    cmoreland
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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