web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Form grid loss focus a...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Form grid loss focus after add a view on OUTER JOIN

(0) Share

Report

Report

Posted on by Diego Mancassola

272

Hi community, strange problem.

On the SalesTable form i have added a datasoure based on a View.

This view, has some data at InventTransId level, and i have linked to SalesLine in OUTERJOIN mode, join is made on SalesId and InventTransId

After adding datasource the sales line's grid loss focus and moves to the first line when i peform an operation on sales line.

If i remove the new DS the focus remain on selected line.

I don't know, there are some limitations using VIEW on a form?

Thanks a lot

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Diego,

Its hard to find the issue. But you can solve this issue by calling positionToRecord method on datasource executeQuery method.

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 559 Most Valuable Professional

#2

André Arnaud de Cal... 464 Super User 2025 Season 2

#3

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans