Master Planning doesn't explode item in sub levels

(0) Share

Report

Posted on by add

Hello guys,

We have updated to Dynamics AX 2012 R3 CU12 from Dynamics AX 2012 R3 CU10 two weeks ago and since then our Planning department has complained about the Master Planning functionality. It seems like it doesn't explode the item in sub levels meaning that it doesn't create the planned orders as expected. When we use Explode manually it works fine. It explodes the item with all expected sub levels. We haven't changed any of the settings from the old version. Is it a matter of settings or it is some kind of bug? Has anyone seen this before? Any info would be greatly appreciated. Thank you!

*This post is locked for comments

All responses (31)

Answers (1)

Weaveriski 23,616 Moderator on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

I suggest you post a new post defining your version and what you have tried.
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

Hi,

I have the same problem. The whole system MRP runs but MRP does not run at itemized level. I tried everything but still not happening.

Any pointers or help will be a great help.

Thanks,

Lakshmi
Juan Carlos Gallegos 40 on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

Hola

Adicional a las recomendaciones de la tabla ReqInventLevel comentar el siguiente código en la tabla: ReqTrans.createTransferDemand(...), esto de acuerdo a un análisis de código en CU9, CU10 y CU12 fue necesario comentar la línea.

//BEGIN [RMG] FIX-MRP no genera ordenes de compra planeadas

//community.dynamics.com/.../220753

//inventDim.wMSLocationId = '';

//END [RMG]
Verified answer

add on at

Like (1)

Report

RE: Master Planning doesn't explode item in sub levels

Hello guys,

I am happy to say that we resolved our problem. It turned out to be some wrong records in tables InventModelGroupItem and InventItemGroupItem. The wrong data was generated by wrongly set up templates. We corrected the templates and it is ok now.
Community Member on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

I had same problem and I found a error when i import item list included BOM_Level column. I delete this column and reimport item list to solving this problem

Regards,

BOMLevel

2

2

2

2

2
Suggested answer

guk1964 10,886 on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

The mrp session log is found under Master Plan set up. https://technet.microsoft.com/en-us/library/aa591284.aspx Click Master planning > Periodic > Master scheduling and the session log button

Maybe also look into the InventSumLogTTS table, the delete function is triggered by the setup of the dynamic masterplan, see classes\ReqCalcScheduleItem\InsertItemSched - this is cleared when you run a regeneration mrp. The InventSumLogTTS is a log file, is used in Master Planning, and stores transaction records. However, it can get very big - hence my prior question about whether you run regen. with a multi level BOM there is more update to do per BOM so more possibility of this being a bottleneck e.g. due to recursion, or record locking.

A very useful post on this topic is http://dbinsight.com.au/dbinsight/tuning-dynamic-ax-master-resource-planning-process

This post also gives some background to it. http://ibisinc.com/blog/running-a-dynamic-plan-in-dynamics-ax/

also see https://msdn.microsoft.com/en-us/library/inventsumlogtts.aspx

There is no real harm in deleting this file, a full mrp run does that anyway.

Also you can try this to better understand when and where the problem occurs - ; Master planning / Inquiries / Processes / Unfinished scheduling processes:

The status column and BOM level columns change when updating (F5) to show where the program is currently in the process. This enables you to ‘track’ the progress from Initialization through coverage planning by each BOM level, through to Future & Action Messages through Statistics, and to updating the Dynamic Master plan.

Click on Inquiries to see the Process task duration screen - Check the box for reviewing the tasks. Normally, don't check this box because it increases processing time – however, its useful to understand where the time in utilized in the Master Scheduling Process, .

View ‘MRP’ process as it goes step by step and item by item – and the time taken.

To make this screen available, click on the process task duration checkbox on the Master Scheduling screen.

Otherwise for fulltracing take look at blogs.msdn.microsoft.com/.../logging-and-tracing-dynamics-ax-mrp-runs

PS a little known recent wrinkle - In CU11 and AX7 there is a new master planning parameter that you might want to have a look at called disable all planning processes. You can find this in the master planning parameters form. Select this when you are not using master planning.
add on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

Where can I find this mrp log file?
Suggested answer

guk1964 10,886 on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

Please check whether your mrp log file is full/has enough space

Ax updates the log file after each level is master planned

It is short of space, then it may stick at an intermediate level.
Suggested answer

guk1964 10,886 on at

Like (1)

Report

RE: Master Planning doesn't explode item in sub levels

It tells mrp when to stop moving to the next level for that item - which plans across all BOMs that use the item. For a specific bom it may be level 3, but it may be at a higher or lower level in another BOM- and the released product will show the lowest level in all BOMs in which that component is used.

So the low level code on a specific BOM may differ form that on the released product different form.

If two companies have different levels for the same item, then they may not have the same set of BOMs overall.

So I think this is a red herring and not your real problem.
add on at

Like (0)

Report

RE: Master Planning doesn't explode item in sub levels

Here is a screen with an example:

This is a manually exploded item in the company where MRP doesn't work. The item level is 1 but in the explosion screen we see level 0. This happens only where MRP doesn't work. There is no such difference where MRP works at 100%.