+21Hi,
One of our customers is experiencing an issue. MRP is creating purchase requisitions without any lines (part or no part), so only the purchase requisitions header. But, this is ad-hoc (this happens occasionally).
Is there a way that MRP can create purchase requisitions without any lines ?
I have checked whether there is any custom task to delete the PR lines of certain parts, but there’s no.
Thank you,
Best answer by ShawnBerk
Turn on history logging on the purchase requisition lines - this is typically dangerous in most instances as it can be a lot of data. But in every case like you’ve described, I’ve found it was because someone - who didn’t own up to it - was deleting the requisition lines as they were processing them.
Sometimes it was because they delete the lines legitimately and combine the requisitions together, they just didn’t go back and remove the header.
Other times, it was intentionally done to hide the lack of work being accomplished.
I’ve not found that MRP creates empty requisitions.
+21Hi Mats
Any idea on the above behavior ?
Thanks,
Hi Tushitha,
Do you have any warning in Background Jobs details? Or anything suspicious in MRP Action Proposals?
Could it be that we are trying to generate a 0 supply qty for a PO Req Line but it fails.
If you have access to the database check if you can run below SQL
select *
from mrp_part_supply_demand
where order_no = ‘your requsition no’.
To check if it has written anything there.
Keep digging :-)
-Mats
Turn on history logging on the purchase requisition lines - this is typically dangerous in most instances as it can be a lot of data. But in every case like you’ve described, I’ve found it was because someone - who didn’t own up to it - was deleting the requisition lines as they were processing them.
Sometimes it was because they delete the lines legitimately and combine the requisitions together, they just didn’t go back and remove the header.
Other times, it was intentionally done to hide the lack of work being accomplished.
I’ve not found that MRP creates empty requisitions.
+21Hi Tushitha,
Do you have any warning in Background Jobs details? Or anything suspicious in MRP Action Proposals?
Could it be that we are trying to generate a 0 supply qty for a PO Req Line but it fails.
If you have access to the database check if you can run below SQL
select *
from mrp_part_supply_demand
where order_no = ‘your requsition no’.
To check if it has written anything there.
Keep digging :-)
-Mats
Thanks Mats,
No warnings in the relevant background job. Currently monitoring for another occasion for the same issue to happen, so that I can check whether that sql query return anything.
I’ll try with the customer enabling the history logging for the deletion of the PR lines if any users manually deleting them, as Shawn has suggested.
Thanks,
+21Turn on history logging on the purchase requisition lines - this is typically dangerous in most instances as it can be a lot of data. But in every case like you’ve described, I’ve found it was because someone - who didn’t own up to it - was deleting the requisition lines as they were processing them.
Sometimes it was because they delete the lines legitimately and combine the requisitions together, they just didn’t go back and remove the header.
Other times, it was intentionally done to hide the lack of work being accomplished.
I’ve not found that MRP creates empty requisitions.
Thanks Shawn,
I’ll try to have the customer to enable the history log. I had the doubt of users deleting the PR lines, because there were like 120 PRs without lines. I was not ready to believe a user deleting that much of PR lines manually 
.
But, there’s a possibility I can see, as you have pointed out. Will keep this thread updated.
Thanks,
+21Thank you very much.
Thank you for confirming that human behavior is universal. Glad you traced the problem.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
