I'm a BI guy so please excuse my lack of understanding on how this is handled in ECC. For some time now we've been extracting MRP data into BI for the current day going forward into the planning horizon. Recently it was noted that requirements generated for subcontracted materials were not being transferred to BI. The reason for this is while the requirement for the assembly is in the future, due to lead times in the subassemblies the requirements for the subcontracted subassembly are appearing in the past and thus not being transferred to BI.
Is it normal practice for requirements to be generated in the past? Is there a way to lump all past due requirements on the current calendar day that way these requirements will be transferred to BI. Any input you can provide would be much appreciated.
Is it normal practice for requirements to be generated in the past?
This is a business decision. I have seen both methods (requirements in the past; vs no requirements in the past) successfully used in production systems.
Is there a way to lump all past due requirements on the current calendar day that way these requirements will be transferred to BI.
Hold on! You want to change a business process, simply because your data extraction logic is faulty? Isn't your job to create BI functionality based upon supporting existing business processes?
I suggest that you first consult with the local Planning people who are responsible for this particular business process. There are many ways to get the proper data into your BI. Normally, as a BI expert, wouldn't you change the extraction process? And, yes, there is a way to set up MRP such that it will never create proposals with dates in the past. Such a change, however, should not be made without serious consideration of all other business processes that will be affected.