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, ... I want to assign rec i...

Finance | Project Operations, Human Resources, ...

Answered

I want to assign rec id's of one table to rec id field in temp table but gettin '0'?

(0) Share

Report

Report

Posted on by imran_balti115

105

Only recId field is getting '0' while other fields( dataAreaId and tableId) are fine. when I hover on inventTable it shows "no data selected".

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Martin Dráb 237,924 Most Valuable Professional on at

Like (1)

Report

Your query groups by ItemId, therefore RecId doesn't have any value defined. You need to either group by RecId too, use an aggregation function or redesign the query completely.

By the way, which version of AX is it about?

Was this reply helpful? Yes No
imran_balti115 105 on at

Like (0)

Report

goshoom Thank you so much, including recid in group by worked for me

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,924 Most Valuable Professional on at

Like (1)

Report

If my reply answered your question, please mark is as such (by using Did this answer your question? > Yes).

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