MRP Regen Revisted

[AKPolarBear]

I was wondering if anyone has come up with any new tweaks or "check this" setting for MRP Regeneration reports. These are taking about 45 minutes during our slow time of year. We are about to move to some new servers (same OS software) and in testing, the regen worked much faster but there were no users on line either. We are running these types of functions after hours but would like to speed them up and or run them during the day. One problem may be our Citrix server is the bottle neck and not the SQL server.
We use version 7.6.100a.

 

[MacolaHelp]

Did you do your file validations to be sure you don't have any discrepancies in the files? Also, resetting low level codes appears to need to be done after a major BM mass replace. I've had a number of problems with inventory allocations going out of whack after major revisions to bills. I just ran a regen in 28 mins with about 25k items & 45k inventory location records. At the time, I had very few customer orders, pos, pops, because I was just trying to run mrp on with a few items to show my customer what their results would look like. Bandwidth has definitely made a difference at other sites where I've implemented MRP, but I'd sure check the data files no matter what.

 

[dgillz]

I have found Bills of Material to be a major culprit here, especially if you have a component in your BOMs that doesn't actually have an item master record on file.

As Macolahelp stated, the file validation reports will help you sort this out.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[AKPolarBear]

We have run the file validation report with little change.

Is there a way to not have the Regen look at BOM?

While looking at the setup for that answer, we did notice that the set up for shop floor is set for S but is grayed out and id unchangeable. At one time we had shop floor installed but later turned it off and no longer use it.

Could this be a problem if the regen is looking for shop floor that is not longer in use?

 

[dgillz]

When you say "that the set up for shop floor is set for S but is grayed out and id unchangeable" what do you mean? On what screen do you see this?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[MacolaHelp]

To eliminate shop floor as the problem, go back into company setup, turn it on. Go to MRP & tell it to ignore shop floor. Then turn off shop floor in company setup. If you feel brave, initialize the shop floor/mca files as well. Do you purge things like POs & stuff to make the files mrp queries as small as possible? Why would you not look at BOM during a regen? How do you get component requirements if you don't?

If you have some items that you don't care about mrp calculations, turn off the order policy code in the item master & they will be ignored during regen.