web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Schedule open sales qu...
Small and medium business | Business Central, N...
Suggested Answer

Schedule open sales quote report daily and send to email

(0) ShareShare
ReportReport
Posted on by Imari 164

Hi,

Good day! We would like to generate a report for open sales quote that we have and sends the report daily at a given time to an email group. 

I tried the print management function and used the printer email address to indicate the email address where the report should be sent to but I only got the report in the report inbox center but not on the email. 

How do we generate sales quote which can give us a report like the total number of quotes created for the day, total unit price, etc. 

Appreciate your assistance. 

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    Hi

    For email you have 2 options

    1) Go to Printer Management then click on Email Print and Add an email printer and define the name and then email address (group email). Make sure you have SMTP setup in your BC. Then use this printer id to send email to email you added there.

    2) Use free app appsource.microsoft.com/.../PUBID.canarys_automation|AID.canarys_mail_utility|PAPPID.2edd7224-5609-4939-b317-8379086daf53

    For the report. I cannot recall any out of box report here. But you can

    1) Develop that report in BC.

    2) Use Jet Report

    3) User Power BI Desktop free and manually email the report.

    4) Use ODATA in Excel to generate and email the report.  www.youtube.com/watch

    5) Use Power Automation. Something like this idea (which is for CRM) www.syvantis.com/.../how-to-use-microsoft-flow-to-automatically-send-a-weekly-email-of-open-leads-in-dynamics-365

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Maybe Power Automate is a good plan. You can extract the sales quote you need on a scheduled flow. You could output the details into Excel or just a html table in the email itself.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans