I tested our custom AR Invoice in our 2024.1 environment and received an error about an Invalid Column, ‘Invalid column name ‘Calc_MtExtPrice’.’. I did some digging on the forum and found where this column had been an issue in an older version, so I removed the T5 reference to it (RptLabels) and left the T4 reference (FSCallMt) in the ARForm query. I also removed the entry for the label in the Fields section of the dataset properties. This fixed the form when printing/previewing from Kinetic itself, but I cannot place a GUID in Report Builder.
When I place a GUID, it thinks for a moment and then I receive the error ‘Object reference not set to an instance of an object’. I removed the textbox that referenced the field from the form which did not fix the issue. I then created a new RDD, updated my Report Style to use the new RDD, and still received the error in Report Builder. I can preview the base ARForm along with any other report in Report Builder, just not my custom ARForm.
Has anyone else encountered this? If so, how did you resolve it?
Yes and no. I couldn’t find exactly what was causing the issue, so I created a new custom invoice, inserted the added tables/fields into the dataset query, and then copied and pasted everything from the old custom invoice into the new one, editing row visibility, etc. along the way.
I did remove every instance of the problem field. I also found the field in use on the form and removed it. The error remained. I compared the base form to my custom one via Notepad++ and the field giving the error remained in base which was confusing. Recreating our custom invoice row by row and adding back the extra tables/fields our company needed was the only path forward I could find.