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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Project day-rate to ho...
Microsoft Dynamics AX (Archived)

Project day-rate to hour-rate rounding problem

(0) ShareShare
ReportReport
Posted on by AR-01121610-0 4,971 Moderator

Dear all,

we currently implement Project module at a professional service Company who is used to work and invoice at day based rates, 8 h= 1 day.

We calculate the hour rate from the day rate to get the corresponding hour sales prices having now three Digits (e.g. 799 pd --> 99,785 ph). The project hour rate only has two digits and these are also used later for invoicing. So we have always some differences between the ordered 100 days each 799 EUR (=79.900 Eur total), and invoiced 100 days each 799,04 (entering 99,785 Eur/h, but saved 99,88 Eur/h) we have 79.904,00 Eur total.

Did anybody run into the same issue? How could we handle this in smart way?

Thanks for replies

BR Andreas

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Andreas,

    I do not fully understand your math and your abbreviations pd, ph and how you used the decimal separator.

    Can you illustrate your issue in a simplified way that you create in an Excel spreadsheet/screenshot that you upload and attach.

    Many thanks and best regards,

    Ludwig

  • AR-01121610-0 Profile Picture
    AR-01121610-0 4,971 Moderator on at

    Dear all,

    the problem is that Dynamics saves the hour sales Price only with two decimal places.

    RoundedHourSalesPricePJA_2D00_1.gif

    I hope i could clarify the issue we have with this example.

    Thank you in advance.

    BR Andreas

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Andreas,

    Thank you very much for this table and the explanations provided :-)

    I don't think that there is a standard solution available for this $4.00 price difference ($79,000.00 vs. $79,004.00)

    You could of course ask a developer helping you to extend the number of decimal places. Such an adjustment can, however, be quite dangerous if it is not done properly and it can cause issues elsewhere.

    My recommendation would be increasing the price per day to $800.00; that is, to an hourly price of $100.00 to avoid this problem. The price increase is not even 1% and helps avoiding issue elsewhere in Dynamics. The only consideration is that things are done differently from what your customer was used to in the past. Hope you can convince your customer to align its process closer to Dynamics rather than trying to modify the system.

    Best regards,

    Ludwig

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans