Change Sales order line unit Price to 3 decimals

(3) Share

Report

Posted on by SKO

468

Hello,

I want to modify the Unit Price field on Sales order line to 3 decimals instead of the default 2 values using the EDT approach. (I am aware of the Currencies form approach)

The challenge is that, both the properties on form control called "NoOfDecimalsMode" and "NoOfDecimals" are greyed out.

The sales price EDT has NoOfDecimalsIsExtensible property set to false. So, I created a custom EDT and set the NoOfDecimals = 3 and assigned it to salesprice field on salesline table. By doing this the table browser shows 3 decimals but the form still shows 2 decimals.

Any ideas

Thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @SKO,

You need to create a form extension SalesTable or SalesLine form (where the SalesPrice control exists):

public void run() { next run(); FormRealControl unitPriceControl = this.design().controlName("SalesPrice") as FormRealControl; if (unitPriceControl) { unitPriceControl.noOfDecimals(3); } }

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Verified answer

Mariano G. 3,598 on at

Like (1)

Report
Copy link

Link copied!

In my company we have solved it by extending the UnitAmountCur EDT, in your extension you'll be able to modify the number of decimals, take notice that SalesPrice extends PriceCur, and PriceCur extends UnitAmountCur, doing this way you'll see 3 decimals, you should also extend UnitAmountMST EDT. You won't need to extend any form.

Was this reply helpful? Yes No
SKO 468 on at

Like (0)

Report
Copy link

Link copied!

Thanks Mohamed and Mariano.

Both approaches will work

Was this reply helpful? Yes No