My company is on the Multi-Tenant SaaS Cloud and so we’ve been preparing for this… A word to the wise: Epicor 10.2.600 breaks custom AR Invoice forms created in SSRS; I re-implemented both the Report Data Definition and my custom SSRS form (a tweaked version of the standard Epicor form). Some elem…

102.200.6 to 10.2.700.6 Had the same error message about those two fields. Had to get the log from the server, though. Did not appear in the system monitor details Query execution failed for dataset ‘ARForm’. —> System.Data.SqlClient.SqlException: Invalid column name ‘Calc_MtExtPrice’. Invalid …

Same error message in 10.2.700.10 for me. Error message did appear in the System Monitor. Same fix applied.

Ran into this same error, but I only removed the Report Table references for the fields (T5). Also have a Custom RDD here, but when I reviewed the Standard SSRS report and it’s RDD both fields were included. Removing the Report Labels references to these fields caused the Report to render ok. It’…

How did you get access to the log on the server or where is the log located? Which AR Form query did you remove the fields? Is this in Report Builder in the sql expression query?

I wish I’d seen this tread a few weeks ago - our AR custom documents all broke. Had to rewrite them all.

Hi @cchang You asked about the server log. Cloud customers gain access via a program called “Server File Download,” located in System Management > Schedule Processes. On-prem customers can presumably configure logs to appear in many places. My on-premises server (version 10.2.300.21) was installed…

[image] PaulKile: You asked about the server log. Cloud customers gain access via a program called “Server File Download,” located in System Management > Schedule Processes. On-prem customers can presumably configure logs to appear in many places. My on-premises server (version 10.2.300.21) was…

Hey Mark. What usings or references does your code require? Doing it in Standard DD. The type or namespace name ‘ServerPathSvcContract’ does not exist in the namespace ‘Ice.Contracts’ (are you missing an assembly reference?) Thanks!

I needed to add this reference: [image] Happy New Year, Sir!

10.2.600 & AR Invoice Form

Epicor ERP 10

josephmoeller (Joseph Moeller) February 5, 2023, 11:04pm 33

This is an old post but is still near the top of search results here: AR Form appears to have a bug related to externally-processed CSF system tables which I mention here: AR Form Error - #8 by josephmoeller

Topic		Replies	Views
AR Invoice Form Printing Error Kinetic ERP ssrs , ar-invoice , printing-error	8	1315	October 25, 2022
ARForm report broken after upgrade from 10.1.600 to 10.2.400 Epicor ERP 10 e10	28	2544	July 21, 2021
Upgrading from 10.1.400.0 to 10.1.600.0 - Custom Reports Fail due to data sets being invalid Epicor ERP 10	11	1214	December 11, 2017
AR Form 10.2.200.3 custom report RDD and style failing Epicor ERP 10	25	3558	January 16, 2019
10.2 to 10.4 conversion (SSRS report error) Epicor ERP 10 ssrs	17	1520	September 9, 2019

10.2.600 & AR Invoice Form

Related topics