After the upgrade to Acumatica ERP 2023 R1, I cannot open or print a custom Check Form with Remittance (AP641000) form due to the “The report cannot be opened because it includes a table (ROUTINGNBR) or a field (AccountID) that does not exist” error message as shown in the following screenshot.
Best answer by mbridges00
There was a change in the CashAccountPaymentMethodDetail DAC sometime around 2022R2 that requires a change for custom check forms, or on the subreport if using a MICR Line. You will need to refresh the schema on the report and change the join to the CashAccountPaymentMethodDetail to use the “CashAccountID” field instead of the obsolete “AccountID” field.
More detailed step-by-step instructions can be found here:
There was a change in the CashAccountPaymentMethodDetail DAC sometime around 2022R2 that requires a change for custom check forms, or on the subreport if using a MICR Line. You will need to refresh the schema on the report and change the join to the CashAccountPaymentMethodDetail to use the “CashAccountID” field instead of the obsolete “AccountID” field.
More detailed step-by-step instructions can be found here:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
