Skip to Content

Automatically run mrp in Sap B1


we are a new partner.

Our first customer needs to automatically run mrp with a default scenario, as he used to do with his old software.

I have read in a previous question and answer that it could be done with SDK, but with no details. I did not find any class / method in DI API to manage the mrp wizard, only the database tables of scenarios are described, but I do not need them as the data are already there.

Is it correct that it can be done with a console application using DI API? If so can somebody give me some hints?

Or mist be done connecting to the Integration service? Or to the DI server?

Or is it impossible at all?

We are using 9.3 PL07 (will move to PL08) with sql database.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Feb 26, 2019 at 11:36 AM

    At the end we found a solution.

    We simply recorded the keystrokes needed to run the MRP and wrote a script to run them again every night.

    To obtain it we used the selenium webdriver (that we use to automate the testing of web applications), and connected to Sap B1 through the Chrome browser. We obtained a python program that can be called by the planning utility of Windows.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 22, 2018 at 11:39 AM

    Hello Stefano...

    I have not heard of an automatic MRP development being done in Standard SAP B1, but I do know some Third Party / Add-Ons / SSPs (Software Solution Providers) do have something like that in their packages. If you are with an SAP B1 Partner, you can get a list of those on the Partner Portal - it used to be called "SAP Business One Add Ons" some time ago. The name might have changed since I was in there.

    Has he tried the MRP Wizard??? Seems pretty straight forward with the ability to save scenarios. Or does he have seasonal requirements in the MRP???

    If he has seasonal requirements, a good SSP starts with the letters Valo...

    LOL - not sure if I am allowed to say the full SSP name or not in the forums. The moderator might get me!!!



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 24, 2018 at 07:01 PM

    FIrst thing how automatic MRP will done whatever the case it must need some input values..You can save the scenario of inputs in standard MRP wizard and run it without selecting values on each step of MRP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2019 at 09:03 AM

    Thank you both of you, but my problem is a bit different.

    I know that you can save a scenario and from the client run it without selecting values. But what my customer expects is that a job is launched by the system every night e.g. at midnight and runs a chosen scenario, so that when he connects next morning he can find the sytem's recomendations according to the scenario he chose as standard. He was used to have this feature in his old ERP.

    I also have heard from other partners (I am myself a partner, but just at the beginning...) that there may be an addon that does this task, but probably it will do a lot of other things that my customer does not need... and accordingly will cost more than he wants to spend.

    So I thought that maybe I could write a small program that colud connect to Sap read the scenario record and use the method that runs it. Unfortunately it seems that this method is not exposed to any of the APIs (neither DI api, nor DIS, nor integration framework).



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.