Those ones should exist in the OrderHed_UD table.
In SQL if you search the view rather than the table, you should see all columns
Ok, I’ll do that and post the results tomorrow. I have a meeting coming up. Thanks for the input and help.
The fix was to reimport the reports, and regen the data model. That fixed all the invalid columns, but now I get to fix other issues with the reports. Things like:
The Value expression for the text box ‘EachQty’ refers to the field ‘EachQty’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
With this as the formula it is referring to:=iif(Fields!InvcDtl_SalesUM.Value=“PK125”,Fields!InvcDtl_SellingShipQty.Value*125,Fields!InvcDtl_SellingShipQty.Value)