I have an sData view I created that combines Company info with the AR_Customer table in Sage100 VIA a linked server. The idea is that a salesperson will have a list of customers to call, and when the highlight a record on the list they can see up to date collections info in the 'SData Record Summary' widget.

My issue is that the only fields available in the sdata record summary are just the company table, none of the fields from the linked server tables are present. Am I missing something?