Skip to main content

Notifications

Announcements

No record found.

Project Operations forum
Unanswered

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

Posted on by

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?

  • gorka.santamaria Profile Picture
    gorka.santamaria 95 on at
    RE: Sales price with 4 decimals or by day in F&O?

    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

  • MarkB45 Profile Picture
    MarkB45 755 on at
    RE: Sales price with 4 decimals or by day in F&O?

    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

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

    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

  • gorka.santamaria Profile Picture
    gorka.santamaria 95 on at
    RE: Sales price with 4 decimals or by day in F&O?

    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,

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans