I have a Generic Inquiry that was created from scratch. It is published to the UI & it is exposed over Odata. It is a combination of 3 source tables. PX.Objects.CT.Contract; PX.Objects.PM.PMForecast and PX.Objects.PM.PMForecast details.
Within Acumatica itself this rendering as I want. The results grid shows each column with the desired custom captions. This all appears to be working as desired.
If I try to connect to this OData feed via Excel\PowerQuery via OData there are issues when I try to navigate to the actual result of the GI.
Specifically the Custom Column that I created as a concatenation of two columns doesn’t appear to be in the dataset and there is at least one column not currently in the definition of the GI that IS showing up.
I *think* that this was the previous iteration of the GI as I was working on it. My question is that after “saving” the GI with the desired updates, do I need to re-publish to the UI to have my changes visible on the OData feed?