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
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.
In Object ID to run enter the newly created codeunit and tick the checkbox of friday so it will run every friday
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
Check for Job Queue for setting up your report
Follow this link
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156