Missing old PO's on MRP reports

[rvb001]

I have several Purchase Orders that for one reason or another have been open for 15 months or more.
When I run MRP regenerations, these older purchase orders are not included in the report by date, and new requirements are generated.
I think it is a problem with one of my calendars, but am not sure how to fix it.
Which calendar is used by MRP?

 

[dgillz]

If you have date problems, you should see a message to this effect on the 1 page report that the MRP regen creates. Do you see this message?

If so modify your reporting calendar to expand the date range back at least 15 months ago (in your case) and the message should go away, and the POs will show up again.

However there are a number of other reasons why the POs would not show up on MRP reports, such as the location not being included in the MRP regen.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[rvb001]

I think the problem may have been I was using the weekly shop calendar instead of the monthly calendar.
The weekly calendar appears to be restricted to 64 weeks.
I changed to the month calendar and I will rerun tonight.

I will also look at the messages tonight after the run. The locations are included.

 

[tpllc]

If you run the MRP by date it will not use a reporting calendar. That should fix the issue. The MRP uses the calendar you define in the Manufacturing setup as the default Material Plan Calendar No.
The weekly and monthly reporting calendars that you are referring to come from the MRP setup where you define the Forecast Calendar to use that is used to determine how to consume the forecast. When you run an MRP report by period it will default to this calendar but you can change it for any report.
I usually set up a calendar that I call Steve’s crazy calendar. I use the daily formant and for my start date I begin a year ago. I then set the “Period type units” in the following manner. The first period I set to 365 units, days, then the next 30 periods I set to one day each and then the next 20 I set to 7 and the balance is set to 30. This way I get a calendar that has all my late items in the first period and I am looking at the next 30 days in daily buckets and the next 20 buckets in weekly periods and the balance in monthly. I get a view that shows what is late, what is time critical in the present and less time critical in the future. You can adjust these number how it suite you. I do have to maintain the calendar on a weekly basis and some of my clients do it daily.

You need to be careful in expanding the shop calendar. There is a problem with the newer code version 7.6.300 and beyond that often returns the out od range error on shop calendars that are longer than 7 years.

Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.