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

(0) Share

Report

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)

All responses (4)

Answers (0)

Sort by

gorka.santamaria 95 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Julien Goessens on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarkB45 755 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
gorka.santamaria 95 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No