Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Payroll Calculation - Azure function or Console App?

Posted on by 865

Hello,

I want your suggestions and the most appropriate approach to the technology that we should use to implement the following requirements:

We have around 2500 employees and we plan to build a payroll calculation process on PowerApps model-driven.

Per employee, it will take approximately 12 records to generate his full salary.

So in total 30-40K records will be created when the calculation is over. Not to forget the other GET API operations to check the setup tables etc.. (Huge number of API calls)

I would like to know which product we should extend to handle this process and I thought about the following:

Using Azure Functions or the Console App with Dataverse.

We want to choose wisely as the product should be very stable and we want to avoid any timeout or delay issues during the calculation process.

Your advice and explanation of why we should use it and the pros and cons would be greatly appreciated.

Thank you,
EBMRay

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Payroll Calculation - Azure function or Console App?

    Hi,

    Execute multiple request can be used for batching

    learn.microsoft.com/.../execute-multiple-requests

    You can increase default 2 mins timeout value in CrmServiceClient.

    Please read below article

    ramontebar.net/.../

    You can use paging in fetchXml and query expression to retrieve more than 5k records

    learn.microsoft.com/.../page-large-result-sets-with-fetchxml

  • EBMRay Profile Picture
    EBMRay 865 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hello Bipin Kumar ,

    Thank you for your suggestion.

    I will determine which option is best for us.

    Can you provide some documentation regarding the best practices to handle timeout, CRUD operation with batches (pagination), and If I missed anything please feel free to provide it.

    Awaiting your response.

    Best regards,

    EBMRay

  • EBMRay Profile Picture
    EBMRay 865 on at
    RE: Payroll Calculation - Azure function or Console App?

    Hello Guido Preite ,

    Thank you for your input.

    We need to test both products as we need to check which one is more performant. This is because we have a lot of API calls to read from dataverse to fetch the related information for the employee and the setup tables etc..

    We tried to calculate one employee using an Azure function (not durable) and it took around 5 minutes to calculate his salary which is a LOT of time.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Payroll Calculation - Azure function or Console App?

    Hi,

    You can use azure function with premium plan which has unlimited timeout period

    The following table shows the default and maximum values (in minutes) for specific plans:

    Plan                   Default Maximum

    Consumption plan 5 10

    Premium plan       30 Unlimited

    Dedicated plan 30 Unlimited

    You can also create console application and host it on azure web jobs which can run on schedule

  • Suggested answer
    Guido Preite Profile Picture
    Guido Preite 54,063 Moderator on at
    RE: Payroll Calculation - Azure function or Console App?

    that amount of data can be orchestrated with a durable azure function but is not an easy task.

    easier way will be to create a console application

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans