I am attempting to add the JobMtl.TotalCost column to the Materials Landing Grid in Job Tracker and experiencing weird results.
I am displaying this column in the Classic UI as shown below.
I was hoping TotalCost would just be hidden in Personalization in the Kinetic UI, but it wasn’t listed. I created a new Layer, found the Materials Landing Page, Edit, highlighted the grid, went to Data > Grid Model > Columns and added the TotalCost column as described in the Epicor Learning Center Course ‘My First Layer in Application Studio’ with properties entered as shown below.
When I preview the layer, my Total Cost column does not appear.
The only way I can get the column to appear is to change the Field property to be JobMtl.TotalCost
As you can see from the screen shot above, the field is blank to the particular Job I entered in Job Tracker. I checked the JobMtl table for the Job and there should be an amount displayed. I have tried varying combinations in Properties for this field and it does not populate.
I checked under DataViews for JobMtl and the field is listed under Columns, so I’m assuming I don’t need to create a dataview and event to have this field populate?
This is only the 5th Customization I’ve recreated in App Studio so I’m still learning, but I feel like this should be easy; what did I miss?
Thanks in advance.