Announcements

No record found.

Project Operations forum

# 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 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 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)...

• 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,

#### 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 . . .

#1

AndrÃ© Arnaud de Cal... 288,459 Super User

#2

Martin DrÃ¡b 225,783 Super User

#3

nmaenpaa 101,148