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 User Defined Fields in Reports
I'm in the process of updating a report with the Report Designer and can't seem to pull in User Defined Fields from DAC tables.
When I create a generic inquiry, I'm able to pull the field so it's clearly in the table. I can't locate these user-defined data fields in the Report Designer.
Has anyone experienced this before?
Have you tried refreshing your report schema?
In the Schema Builder, under the Tables tab, there is a Refresh All button at the lower right. Clicking that should add any new fields that have been created.
Including a couple of screenshots:
Edit: I have found them in the POOrderKvExt table, which joins to the main POOrder via POOrderKvExt.RecordID = POOrder.NoteID
We've recently been using Attributes on purchase orders to add a new user-defined field, which we want to have show up on a report.
I can see in the database in which tables the attribute and its values are defined (CSAttribute, CSScreenAttribute, CSAttributeDetail).
We can see the values are being saved when we save the purchase order, but they are not being saved to the POOrder table as the Customization->Inspect Element (Ctrl+Alt+Click) function seems to indicate.
We need to know how to find those values in the database so we can use them on the report.
Any thoughts on where we should look?