Automatically run mrp in Sap B1

[former_member600081]

Hi,

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

[former_member600081 · Accepted solution]

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.

Stefano

[former_member600081]

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).

Best

Stefano

[Abdul]

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

[zal_parchem2]

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!!!

Regards,

Zal