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

(0) Share

Report

Posted on by Microsoft Dynamics ...

191

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.

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 73,171 Super User 2024 Season 2 on at

Like (0)

Report

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

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

More details:

Hope this helps.

Thanks.

ZHU