Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Job Queue does not send email to customers (statement)

(0) ShareShare
ReportReport
Posted on by 258

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

  • Hatimali84 Profile Picture
    Hatimali84 258 on at
    Job Queue does not send email to customers (statement)
    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. 
  • Suggested answer
    rostad.exe Profile Picture
    rostad.exe 60 on at
    RE: Job Queue does not send email to customers (statement)

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,802 Super User 2024 Season 2 on at
    RE: Job Queue does not send email to customers (statement)

    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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans