Small and medium business | Business Central, N...

Entering Quantities by Calculation on Numeric Fields

(3) Share

Report

Posted on by BA-14031437-0

Hello

I have created an AL Code page extension with some decimal and integer fields. I am finding I cannot enter an expression like 2*60 or 60+60 into the field - doing so generates a UI error that the entry cannot be evaluated into an integer or decimal value. On many fields such as quantities in Sales order Lines, entering such expressions works. Any ideas what I am doing or not doing to enable entering quantities by calculation in my own numeric fields

Many thanks

Rhodri

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Ashwin Nimbulkar 164 on at

Like (1)

Report

You can only use expressions with fields of the decimal data type, not with the integer data type.

Let me know if you find a way to do this with the integer data type.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

Hi, good day

You could copy or check the standard quantity field and see that it is the same as yours.

BC Tip 15 - Easily Calculate Numerical Fields - Acumen Consulting

BC Tips: Fast Data Entry - Simple Math in a Field

Best Regards
Gerardo

Was this reply helpful? Yes No
Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

Business Central doesn’t natively allow direct expression evaluation in custom fields. However, you can achieve this by implementing a custom validation also Use a Calculated Field Approach.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-calcfields-property

https://www.youtube.com/watch?v=iKkF9vwAIo4&ab_channel=GetYourNewView

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, please refer to the following standard practices

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Like Below, Technical Experts can answer in a better way.

Was this reply helpful? Yes No
Vahid Ghafarpour 12,166 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No