web

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

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to remove duplicat...

Small and medium business | Business Central, N...

Suggested answer

How to remove duplicate values in word layout report in business central

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

For example: I have 3 fields. i.e. no,description, quantity.

in my no field ,i have the duplicate values.& also description have same values.

I want ,that 2 same entry ,should i get in one entry.as shown in below image.i.e. result.

And that same entry have quantity also , so i want sum of that quantity as shown below image.

.

Is there is any way to do this.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 94,369 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to remove duplicate values in word layout report in business central

Hi, Sorry I don't know how your report is designed.
I think the easiest way to deal with it is to use Query.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-method-property

Here is an example using a group of dates, Sum is even simpler.

https://yzhums.com/14547/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,921

#2

YUN ZHU 2,012 Super User 2025 Season 2

#3

Jainam M. Kothari 1,999 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans