web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales price with 4 dec...
Finance | Project Operations, Human Resources, ...
Unanswered

Sales price with 4 decimals or by day in F&O?

(0) ShareShare
ReportReport
Posted on by Julien Goessens

Hello,

In D365F&O, the sales price is defined by hour and with 2 digits. 

Our company works with daily rate. We have the following problem:

- Price per day is 600 euros and we work 7,7 hours by day

--> 600 / 7,7 = 77,922077 so 77,92 in D365 limited with 2 decimals

- I work one day, so 7,7 hours in my timesheet. The invoice proposal will be 7,7 * 77,92 =599,98 euros...and not 600€

If I can have 4 decimals in D365FO, I will have 7,7 * 77,9921 = 600 euros and it will always work.

How can I change FO to have 4 decimals?

I have the same question (0)
  • gorka.santamaria Profile Picture
    gorka.santamaria 95 on at

    Hi Julien,

    The only standard way is to use price quantity for that. Prices are limited to 2 digits as you already seen.

    If you want to avoid the system to round your price, you can define the price quantity for 100 units (7799,21) so the system won't round it. This is quite confusing at the beginning but you finally get used to it.

    I hope it helps.

    Best regards,

  • Julien Goessens Profile Picture
    Julien Goessens on at

    Hi Gorka,

    Sorry but the problem is that there is not that possibility when you define the sales price by hour in the project module FO...what you propose is only valid in sales order (and very well known)...

    pastedimage1633416851022v1.png

  • MarkB45 Profile Picture
    MarkB45 755 on at

    Hi Julien,

    There is not a functional way to increase the decimals on a price field but it could be increased through the back end. Used to do this on AX2012 quite a lot to get the required accuracy for the cost/sales amount.

    Increase the setting on the SQL table to be 4 d.p. not 2

    K.R.

    Mark

  • gorka.santamaria Profile Picture
    gorka.santamaria 95 on at

    Hi Julien,

    Sorry for my misunderstanding.

    Unless there is a workaround that I don't know, you need to customize. In Ax2012, if I am not confused, I also think you could use DMF to load prices with more precision (>4decimals) and the stored them correctly. After the system only rounded after doing the product.

    For example:

    Hours:100 hours

    Sales prices: 77,9921

    Total: 100 * 77,9921= 7799,21

    This is D365FO and I don't know any standard way.

    Best regards

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 540 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans