The inventory planning tool in NAV is one of the most complex functions in the system and the number of different parameters having an effect on the result are a lot. So I understand that you would like to have report which will give you a result which is much easier to understand. In fact I wanted to do the same when they first introduced the calculate plan functionality in its current way. But not only did I find out that creating that report would take a lot of time. I also found out that setting the right parameters made the system give me the exact result I wanted. And learned to ignore the re-planning warnings which
So I’ll suggest that you create a clean demo company and a number of items similar to the ones you have in your production/live database and start testing the different parameters systematically. I can recommend this link http://msdn.microsoft.com/en-us/library/hh173147%28v=nav.70%29.aspx to get started. I know it’s for NAV 2013, but except for a few new options, then it basically works the same. The page includes links to the different parameters available.
And when I have said that, then I definitely will recommend that you hire a Navision consultant specialized in the supply chain planning and manufacturing (most “normal” consultants don’t even understand it fully), to go over any issues you still might have. It is very difficult to say what is going wrong in your system, unless you have direct access to your system. So getting a consultant on-site with you will be the most effective and fast method. Especially if the system wasn’t setup correctly in the first place.
If your background is not within MPS and inventory planning, then I’ll also suggest that you might read some books about the topic, which will give you a more theoretical introduction to the subject, and it doesn’t have to be specific about NAV, as NAV in general uses the same terms as most other ERP/MRP systems.