You’re offline. This is a read only version of the page.
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?
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
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
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)...
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (