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".

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Martin Dráb 230,414 Most Valuable Professional on at

Like (1)

Report

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

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

Like (0)

Report

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

goshoom Thank you so much, including recid in group by worked for me
Martin Dráb 230,414 Most Valuable Professional on at

Like (1)

Report

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

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?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2

Martin Dráb 230,414 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans