Skip to main content

Notifications

Announcements

No record found.

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

Automatic Running of Planning Worksheet

Posted on by 30

Hi everyone, 

Can planning worksheet be set to run automatically at a specific time rather than to manually trigger it?

Best Regards,

XT.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automatic Running of Planning Worksheet

    XT,

    Adding to Bilal's reply... You can setup a Job Queue extension to define your Planning Worksheet or Requisition Worksheet to running overnight based on parameters you fill in on the Option page. You can work with your Partner to accomplish this. I have done this before.

    Thanks,

    Steve

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Automatic Running of Planning Worksheet

    Hi

    We had the same question recently and the answer is no. I wish the answer was yes since it makes a lot of sense.

    In order to do this you need a customization. See the following for more info

    https://www.olofsimren.com/schedule-mrp/

    Thanks 

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Automatic Running of Planning Worksheet

    Hi,

    As far as I know Requisition Worksheet can be used without Planning Worksheet. Yes, but if you need to run calculate net or regenerative plans then planning worksheet is required before.

    Functionally on this I cannot given any opinion I have not much knowledge on this module but in terms of development both calculate regenerative plan and calculate net plan are reports and you can run reports automatically in the background after regular intervals using job queue. If these reports need some user input then you cannot use them properly using job queue.

  • LXT Profile Picture
    LXT 30 on at
    RE: Automatic Running of Planning Worksheet

    Hi :),

    The purpose of wanting BC to automatically run the planning worksheet is not to carry out the action but to allow someone to run the requisition worksheet. As the requisition worksheet cannot be populated before the planning worksheet being populated first.

    Best Regards,

    Xiao Tian.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Automatic Running of Planning Worksheet

    Hi,

    If you add more details then it will be better for understanding of your question/requirement.

    But as far as I get from your question: There are a number of decisions involved at planning worksheet so better to be run manually and for required.

    Regardless of this, you can execute any report or code unit in the background using job queue after regular intervals.

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