Salesline table-amount precision

(0) Share

Report

Posted on by Community Member

Trying to determine what controls the decimal extension of an amount field in the salesline table. Some orders contain a value with extended decimal positions (4.393333333333) others don't (3.570000000000). Have a customer that requires 4 decimal positions (2.9358 vs 2.936).

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 303,988 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The system position is 2 decimals. If you need more, you can also work with price units to prevent cumbersome customizations. If you do see values with e.g. 4.393333333333 it is most likely caused by customization where the currency rounding was not applied.

Even when you are using the price unit, you can create display/edit methods to present 4 decimals on the order lines and invoices but have the system running the standard logic with 2 decimals and e.g. price unit per 100.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

ETD has a properties called "NoOfDecimals" that determine the precision.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

you need some customization and taking Rounding in your consideration as Andre mention you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks

Was this reply helpful? Yes No