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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Job Queue does not send email to customers (statement)

(0) ShareShare
ReportReport
Posted on by 564

I am working with a client and they want to send customer statements via email using the Job queue. We have setup the job queue in the sandbox and have scheduled it to run everyday. For testing we have put put the client's email in the email field so that the actual customer does not get the emails. The test email is working without any issues. 

when i check the logs, it says successful but then we don't get any email with attachment for the customer we have setup the job queue. 

We created to Job queues and in the log it shows that it was successful but did not receive any statement for the customers.

Does anyone have any idea if we are missing any step. 

pastedimage1685637663659v3.png

pastedimage1685637669257v4.png

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,739 Super User 2025 Season 2 on at

    Hi, as far as I know, what you are doing is not the automatic email feature, but the Schedule Reports

    More details: https://www.innovia.com/blog/two-ways-to-schedule-reports-in-business-central

    And https://www.youtube.com/watch?v=iDQqyNzcRj8

    If you want to automatically send emails to customers, unfortunately this needs to be customized.

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    rostad.exe Profile Picture
    60 on at

    Your can automate this with Power Automate integration with business central.

    So that everytime a report named "Customer Statement" gets created in your inbox it will pick the .pdf up and send an email.

  • Hatimali84 Profile Picture
    564 on at
    Hi All,
    Thank you very much for the response on this. 
     
    It seems like there are some limitations to this job queue and we had also reached out to Microsoft but It was not resolved. 
     
    Running the scheduled statements works fine its kind of manual trigger. When we try to reschedule it starts giving an error and does not run the day we want it to run. 
     
    For now we will stick to manual process. 
     
    Thank you. 

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans