Error Printing Edit Lists

Good Morning,
I’ve found a couple topics similar to this, but the fixes do not help. I have not added any UD fields, but suddenly I am getting this error SPORADICALLY, when running a custom SSRS version of the Edit List. Just wondering if beyond UD fields and possible a datasync issue, what could be the cause of this?

Program Ice.Services.Lib.RunTask raised an unexpected
exception with the following message: RunTask:
Column ‘Calc_Rpt1ExtTransValue’ does not belong to table
RcvDtl.

Thanks in advance for the assist,

Eric

If it is a custom SSRS, you could simply remove this field from the SQL statement. I would be surprised if you are using it.

Thanks Jason.
It looks like the rcvdtl.ExtTransValue field is not used anywhere in the SSRS report. I excluded it in the RDD and the report works fine now, but I want to be sure I am not screwing anything up. I did not build this custom version and nothing has been changed, but we started to get this error last week. It also seemed to resolve itself at one point, but now happens sporadically. Is there somewhere I can see the entire Query for the report, including the calculated values to make sure I am not missing it somewhere?
Eric

If you have SQL access, you can see the generated output tables. However, if this is a minor customization, you may want to revert back to the standard SSRS and make the changes again.
Also, if your Report Data Definition had any fields deleted, you may want to revert that as well and start over.

I’d guess that there is something particular in those groups (Credit/Debit memo, Adv or pre-billed/paid invoice, etc…)

Not knowing what that field Calc_Rpt1ExtTransValue actually shows, makes it hard to predict what types of group items might need it.

So after reviewing the RDD for both the system AP_Edit and the custom, this field was missing. Wonder if copying the report before customizing leaves out calculated fields? Even if it is not using that field, there was a call to it causing it to error. Once I created the calculated fields that were missing, the error stopped.

Thanks for pointing me in the right direction!!!