I am trying to find the duplicate records across cross company, and it gives me an error on count keyword. Please help to identify it.
while select crosscompany : conCompanies AccountNum from vendTable group by vendTable.AccountNum Having count(vendTable.AccountNum) > 1 order by asc
Hey Mohit,
This worked. Thanks again
For that case you can simply give a SQL query in SSMS which saves time. Any issue there?
Hi, You can't use count in where condition. There is an alternative which I think we have discussed before, please check this article.
allaboutax.blogspot.com/.../duplicate-records-in-dynamics-365.html
while select crosscompany AccountNum, count(RecId) from vendTable order by vendTable.AccountNum asc group by vendTable.AccountNum { if (vendTable.RecId) > 1) { //Duplicate record } }
Refer to the below thread.
Thanks,
Girish S.
Hi Girish,
I am looking for all the vendor accounts which have same value accross different legal entities.
Can you tell me what is the meaning of that line "Having count(vendTable.AccountNum) > 1"
If it throws error that means you are not allowed to use count function in that place.
I guess that without that line you will get the desired output.
Thanks,
Girish S.
Its giving me the same error Girish
Can you use only count(AccountNum) instead of count(vendTable.AccountNum).
Thanks,
Girish S.
Hi Girish,
I tried this on X++ only. There its giving me the error on count - invalid token
Hi Harshal,
Have you tried the same with X++ code?
Thanks,
Girish S.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156