Just this week, MRP has been trying to create a job for a part called “MISC” and I cannot seem to identify where it’s finding this demand all of a sudden.
Logs and screenshots below. Anyone have any ideas?
it may be a job that has the part marked as a make direct (job to job)… to find it, create a BAQ on the JobMtl table searching for “Misc” in the material part number, and display the job #e10… but also, you can simply go into the settings on the part and uncheck the “Process MRP” setting as well as the “Generate Suggestions” checkbox. Then this part will be skipped altogether.
There are a number that come up, but only one that’s not marked Job Complete, although the JobHead table shows it as closed.
None of them, open or closed, reflect the date in MRP of 6/11/2018.
That last image shows MISC as a material… so check the BOM of part 101472. And as @timshuwy said, uncheck Process MRP at the Site level.
Ernie, 101472 is actually a project, not a part. That job doesn’t look like it’s been touched since 2014, so I don’t honestly think it’s the one driving demand.
Unchecking Process MRP is the easy way out (and I have to clear it with some functional areas to make sure that they truly do not want MRP to process this part).
I’m more interested in where this 40 piece demand is coming from when none of the screens I know of show that anything is required. 
Well, the consensus from the team was to unmark the “Process MRP” and inactivate the part all together.
I guess the root cause shall forever be unknown!
Thanks all.
If you want to step into the abyss, query up erp.partdtl table for that part and there are ways to backtrack to the order or job that needs that part. In my travels through the table, be forewarned that revisions, plant information in that table may or may not be correct.
@Dave_Leannah, that was actually my first stop. There were no records where PartDtl.PartNum=‘MISC’.
Wouldn’t that be PartMtl?
1 Like
PartMtl will show all materials associated to jobs… PartDtl shows all references to a part, no matter where it comes from (sales order, jobhead, JobMtl, po, transfer, etc, etc)… it is what TimePhase uses.