Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Report to be executed every friday to the corresponding users.

Posted on by Microsoft Employee

Dear NavPeers,

I want the report( weekly report ) to be executed in nav every friday and how it can be done.?

And i want that report to be send as a mail to corresponding person can u pl give me a outline of how it can be done.

Thanks for your answers.

*This post is locked for comments

  • Suggested answer
    Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    RE: Report to be executed every friday to the corresponding users.

    Hi,

    You have to write the code for email to be executed in the OnRun() trigger of your codeunit. You can refer the below link to send am email.

    https://saurav-nav.blogspot.in/2013/08/send-mail-with-attachment-from-navision.html

    Now create a new job queue as per the below screenshot.

    3000.job-queue.JPG

    In Object ID to run enter the newly created codeunit and tick the checkbox of friday so it will run every friday

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Report to be executed every friday to the corresponding users.

    On the job queue entry record in the recurrence tab select run on Fridays, and in the codeunit/report which you setup to run save the report as PDF and send them email.  There are several examples how to save the report to PDF and send it as email. You can check them.

    community.dynamics.com/.../how-to-print-reports-to-pdf-and-send-email

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Report to be executed every friday to the corresponding users.

    Check for Job Queue for setting up your report

    Follow this link

    msdn.microsoft.com/.../hh879427(v=nav.90).aspx

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Report to be executed every friday to the corresponding users.

    Hey,

    You can write your Codeunit based on all your conditions with email code.

    Once your logical part is done you can navigate to job queue and activate it and make it recurring  every Friday.

    Jo queue has many option you can choose as per your need.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans