In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Trap for Invalid (Missing) Field in Report Designer
I have added a user field to POOrder to be printed on Purchase Orders. Works great when the customization is published but results in error when saved ran instance that does not have the customization:
Invalid field name POOrder.UsrRevisedDate has been specified.
Is there a way in Acumatica Report Designer to allow the report to run, giving that missing field a NULL value?
Refreshing the tables in schema editor might fix this.
Open the Report.
Click File -> Build Schema...
Make sure "Tables" tab is selected in the dialog.
Click "Refresh All" button near bottom right corner.
I think the field has to exist if your report calls for it. I don't think that it will treat it as NULL.