web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How do I get a report showing 1 transaction per item?

(0) ShareShare
ReportReport
Posted on by 10

I got the Registered Warehouse Lines and the Destination No. is what I want.  So, how do I combine them under one Registered WP number and the Destination No.?

I have a example:

pastedimage1674750816186v1.png

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,161 Moderator on at

    Maybe you can share the source code of your report? That makes it easier to assist you.

  • MMatthewsJr Profile Picture
    10 on at

    Here's the AL file and the RDLC file.

    [View:/cfs-file/__key/communityserver-discussions-components-files/758/Rep_2D00_Ext50351.WhseShipCreatePick.al:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/758/WhseShipRegPick2.rdl:320:240]

  • Suggested answer
    Nitin Verma Profile Picture
    21,788 Moderator on at

    You need to do the grouping on First column.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans