Report Error after Upgrading 10.2.400 to 10.2.700

Epicor ERP 10
,
1

Help,
I am trying to upgrade to 700 level, and i am running into an issue while printing invoices. I have searched for the answer and what i have read I cannot seem to fix. Can someone please help me.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.ArgumentException: Column ‘Calc_TotalAdvBillCred’ does not belong to table InvcHead.
at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.set_Item(String columnName, Object value)
at Erp.Internal.AR.ARInvForm.SetColumnValues(String tableName, DataRow row) in C:_releases\ERP\ERP10.2.700.40\Source\Server\Internal\AR\ARInvForm\ARInvForm.cs:line 5338
at Ice.Core.RptTaskBase1.RunSetColumnValuesProcess(String tableName, DataRow row) in C:\_releases\ICE\ICE3.2.700.40\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 212 at Ice.Core.RptBase.ReportRowDataWriter.WriteRow(IRow row) in C:\_releases\ICE\ICE3.2.700.40\Source\Server\Internal\Lib\TaskLib\RptBase\ReportRowDataWriter.cs:line 65 at Erp.Internal.AR.ARInvForm.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP10.2.700.40\Source\Server\Internal\AR\ARInvForm\ARInvForm.cs:line 1315 at Ice.Core.TaskBase1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE3.2.700.40\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE3.2.700.40\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE3.2.700.40\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\ICE3.2.700.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 454

2

Just to clarify, are printing a custom version of the invoice or the standard?

Basically the error is telling you there is a mismatch between the Rdl and the Rdd.

3

Matthew,

It’s saying the field doesn’t exist in the dataset, I forget if its on the report data definition side or the .rdl side, but I think it’s on the former. You may have to start with the base report data definition from the base SSRS invoice form that comes with 10.2.700 and if you were using a modified version of the 10.2.400 base rdd for the invoice, you need to make those same changes to a copy of the 10.2.700 base rdd and then assign that rdd to your custom invoice and see if it prints fine. Is what I said clear to you or do I need to elaborate?

1 Like
4

It happens when i print a custom report.

worked just fine in 400 level.

5

Then yes, you will have to tweak either the RDD (Epicor) to add the field or the RDL (SSRS) to remove the field.

I have never have a version update in Epicor/Kinetic that did not require work with the AR Invoice, every single version they have changed something, going from 2022.2 > 2024.1 at some point in there they added a whole new RDD that basically caused me to rewrite our custom invoice, I am not sure that was the first time that I had to do that, I feel like the Invoice is one of those ones that after every upgrade I end up recreating my custom RDD and RDL from their Base ones in order to make it all work. I can’t think of any other form that requires such extensive work consistently, most are super simple uplifts.

6

Thank you so much. I will give it a try. Not very knowledgeable as i am still learning.