Dynamics Community Forum Thread Details

PurchTable Opening Same Order for Other Users With Added Aggregate View

Background - I'm working on adding a simple aggregate to the purchtable form from the purchline table.

I've added a view to the PurchTable form data sources which does a simple aggregate on one column from PurchLine table grouped by purchid
I set the link type to inner join on the view view to PurchTable in the datasources by purchid.
I added the aggregate column to the purchtable maintab -> tabpagegrid -> grid by dragging the aggregate column from the aot newly added view from datasources
I saved, built, tested this in a developer environment and it works fine in the developer environment. I can click on any order and goto the line details, I can see the aggregate in the purchtable form.
I deployed to a quality environment and tested it to work fine for me in that environment. I can click on any order and goto the line details, I can see the aggregate in the purchtable form.
Other users, when they go into the quality environment, they can see the aggregate column value in the purchtable form, but when they click on any purchorder (first column in form grid), it continually goes to the same purchase order details.

Some things that were tried to resolve the issue after the issue was discovered by user testing.

reset browser cache for the quality environment
tried multiple browsers.
reset user usage data in D365
explicitly grant read on the view in d365 to the AP clerks roles in the quality environment, had users logoff, login and still clicking orders goes to the same order. It doesn't seem like a permissions issue as the users can see the aggregate even prior to granting the read on the view.
used developer options in browser to examine links and can see the links to the purchase order do point to the correct order numbers.

Any help is appreciated. Below is picture of highlighted links that are going to the same order after adding the aggregate to the grid.