Dynamics Community Forum Thread Details

Issue with SalesTableListPage → SalesTableDetails Navigation After Adding a Computed Column

Hi everyone,

I’m facing an issue with the SalesTableListPage → SalesTableDetails navigation in D365 F&O and would appreciate some guidance.

I have a business requirement to add a Status field that needs to be filterable on the Sales Order List page.

To achieve this, I:

Created a View with a computed column for the Status.
Added the computed column to the SalesTableListPage.
Added the View as a data source to the form query so that the Status field can be filtered.

The issue is that after adding the View to the query, the navigation from the list page to the Sales Order details form no longer works correctly.

For example, if I’m on the list page and click the blue link for Sales Order 250, instead of opening Sales Order 250, it opens Sales Order 1 (or whichever Sales Order is found first).

Interestingly, if I remove my View from the form query, the navigation works correctly again.

So it appears that adding the View/data source or modifying the query is affecting how the selected SalesTable record is passed to the SalesTableDetails form.

Has anyone encountered a similar issue?

Could this be related to the join between SalesTable and the View, the data source relations, or the link/reference fields used for navigation?

I would especially appreciate any guidance on how to add a filterable field from a View to the SalesTableListPage without breaking the standard navigation to SalesTableDetails.

Thanks in advance!

View I created