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

Is it possible to sum data in a data exchange definition?

(0) ShareShare
ReportReport
Posted on by 193

I an creating an export that will send many records by date that we want to not only group but to sum and only send the total.  Is that possilbe. 

We have a custom that allows the user to enter timesheets for their employees and then export to a 3rd party payroll system.  If we send in detail the employee would have a line for each day they entered hourly time on their paycheck 

    • 5/1/2023 8 hour
    • 5/13/2023 8 hour
    • 5/14/2023 8 hour; 2 OT
    • 5/15/2023 8 hour

Would like the data exchange to send 40 hour; 2 OT

I have tried the grouping but that only seems to sort them together. 

Any help would be appreciated. 

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    98,231 Super User 2026 Season 1 on at

    Hi, this requires a little customization as far as I know.

    More details:    

    Hope this helps.

    Thanks.

    ZHU

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 1,960 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,084 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,047 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans