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

(0) Share

Report

Posted on by Microsoft Dynamics ...

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)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 95,311 Super User 2025 Season 2 on at

Like (0)

Report

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

More details:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No