Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Nav 2018 Job Queue - Recurring, but Change Date Parameter Automatically?

Posted on by 605

So, I want to set up a report to run automatically using the Job Queue, say... 10050 Daily Invoicing Report.  I want it to run every night for the previous days invoices (posting date).  Is there a way to automate the date change or would that have to be done manually every single day?

pastedimage1625069968443v1.png

Thanks for any help

Rachel

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Nav 2018 Job Queue - Recurring, but Change Date Parameter Automatically?

    Rachel,

    Adding to Marco's reply... I have created Job Queues before but for the ones that require parameter/option population, I worked with a programmer to create a Job Queue that applied specific logic. In your case the Posting Date should always equal TODAY. Connect with your Partner to create this simple Job Queue for you.

    Thanks,

    Steve

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Nav 2018 Job Queue - Recurring, but Change Date Parameter Automatically?

    Hello,

    I assume this requires customization via PTE. Maybe your partner can assist you with this task.

    Thanks.

  • RSchaefer6944 Profile Picture
    RSchaefer6944 605 on at
    RE: Nav 2018 Job Queue - Recurring, but Change Date Parameter Automatically?

    Marco,

    Thank you for your reply.  Yes, I plan on doing that, but my issue is that the filter I use will be the posting date.  So if I have it run today, I would schedule it with a posting date of 6/30/21, then tomorrow I want the posting date to change to 7/1/21.  I want it to run every day, but have the posting date change to the previous day automatically.  Is there a way to do that or do I have to change the filter manually even if I set it up as a recurring job?  The issue is I need to set up this job for multiple users, so changing this date daily would be... tedious at best.

    Thank you,

    Rachel

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Nav 2018 Job Queue - Recurring, but Change Date Parameter Automatically?

    Hello,

    You can setup job queue as a recurring one and schedule it?

    Thanks.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans