Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

PurchTable Opening Same Order for Other Users With Added Aggregate View

(0) ShareShare
ReportReport
Posted on by 20

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

  1. 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
  2. I set the link type to inner join on the view view to PurchTable in the datasources by purchid. 
  3. I added the aggregate column to the purchtable maintab -> tabpagegrid -> grid by dragging the aggregate column from the aot newly added view from datasources
  4. 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.
  5. 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.
  6. 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.

  1. reset browser cache for the quality environment
  2. tried multiple browsers.
  3. reset user usage data in D365 
  4. 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.
  5. 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.


pastedimage1679929263055v1.png

  • jason.bouchard Profile Picture
    jason.bouchard 20 on at
    RE: PurchTable Opening Same Order for Other Users With Added Aggregate View

    bump?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans