Send report automatically using job queue

casanova
casanova Member Posts: 194
edited 2013-04-25 in NAV Three Tier
hi all
I want to send report using job queue
for example Statement (report 116) and Reminder (report 117)
so i want to generate report (maybe as pdf file) for customer A, and then send to Customer A's email
how to do this using job queue?
thanks

Comments

  • yukon
    yukon Member Posts: 361
    Hi casanova,

    Many people dicuss and solved this requirement. I hope you can find in forum.

    Regards,
    Yukon
    Make Simple & Easy
  • casanova
    casanova Member Posts: 194
    yukon wrote:
    Hi casanova,

    Many people dicuss and solved this requirement. I hope you can find in forum.

    Regards,
    Yukon

    hi yukon,
    i know but i haven't found any discussion about automatic print as pdf (and then separate for each customer)
    and then send to their email directly
  • BardurKnudsen
    BardurKnudsen Member, Microsoft Employee Posts: 137
    Assuming you are running NAV2013, I would
    1) Create one or more codeunits to execute the reports in the Job Queue.
    2) In the codeunit, set filters etc. and use Report.SAVEASPDF.
    3) In the codeunit, use codeunit 400 SMTP Mail (requires some setup of server and login info) to create a mail and attach the pdf file from step 2.
    Bardur Knudsen
    Microsoft - Dynamics NAV
  • Excepti0nal
    Excepti0nal Member Posts: 74
    BardurKnudsen wrote:
    Assuming you are running NAV2013, I would
    1) Create one or more codeunits to execute the reports in the Job Queue.
    2) In the codeunit, set filters etc. and use Report.SAVEASPDF.
    3) In the codeunit, use codeunit 400 SMTP Mail (requires some setup of server and login info) to create a mail and attach the pdf file from step 2.


    BardurKnudsen is correct, we did a similar modifcation to email an invoice when posted.
  • yukon
    yukon Member Posts: 361
    Dear casanova,

    I search for you :D

    How to save Navision Reports as PDF http://mibuso.com/forum/viewtopic.php?f=5&t=18331&hilit=bullzip
    Sending NAV Reports by mail as PDF : http://mibuso.com/forum/viewtopic.php?f=23&t=55325&hilit=bullzip
    Send email with PDF attachment in NAV 2009 : http://blogs.msdn.com/b/nav/archive/2009/10/08/send-email-with-pdf-attachment-in-nav-2009.aspx
    PDF Creation from NAS JOBQUEUE : http://mibuso.com/forum/viewtopic.php?f=32&t=49398&hilit=jobqueue+pdf

    It's not exactly same what you want, i hope you can refer from above link. "BardurKnudsen" already gave best idea to you. :thumbsup:

    Best Regards,
    Yukon
    Make Simple & Easy
  • Rob_Hansen
    Rob_Hansen Member Posts: 296
    If the client would prefer not to reinvent the wheel here, we have an add-on for NAV2009R2 and NAV 2013 that provides this functionality. It also has an option to include copies of all open invoices along with each statement (so it produces a single PDF for each customer with the statement and copies of all open/unpaid documents). You can PM me if you'd like more info. (I don't want this to come across as me spamming out a pitch for our product!)
    Rob Hansen
    http://www.epimatic.com

Categories