Time Phase Material Requirement Report Error

Epicor ERP 10
1

Kindly refer to the below error message on executing the Time Phase material Requirement Report.

Anyone get similar error as this?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.NullReferenceException: Object reference not set to an instance of an object.
at Erp.Internal.IM.IMR60.TotalBinOH() in C:_Releases\ERP\RL10.2.600.0\Source\Server\Internal\IM\IMR60\IMR60.cs:line 1065
at Erp.Internal.IM.IMR60.PrintAll() in C:_Releases\ERP\RL10.2.600.0\Source\Server\Internal\IM\IMR60\IMR60.cs:line 657
at Erp.Internal.IM.IMR60.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\RL10.2.600.0\Source\Server\Internal\IM\IMR60\IMR60.cs:line 492
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\UD10.2.600.8FW\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 80
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\UD10.2.600.8FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 112
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\UD10.2.600.8FW\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\UD10.2.600.8FW\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\UD10.2.600.8FW\Source\Server\Services\Lib\RunTask\RunTask.cs:line 452

2

The last time that we had this error we had an open order for a part that got inactivated.

3

I am not sure if you are still having this issue or not, but I did write and SQL script to find the issue for ours.
select p.PartNum, p.PartDescription, p.ClassID, p.TypeCode, p.InActive, w.OnHandQty, b.OnhandQty
from Part p, erp.PartWhse w, erp.PartBin b
where ClassID = ‘Class ID that won’t run’
and p.PartNum = w.PartNum
and w.PartNum = b.PartNum
and w.WarehouseCode = b.WarehouseCode
and w.OnHandQty != b.OnhandQty

The returned a part where the quantities did not match. After we adjusted it we could run time phase again.

4

This issue for us was we had orphaned PartBin records (PartBin exists but WhseBin did not.)