Calculated field on Purchase Order

(1) Share

Report

Posted on by RB-10051553-0

Hi,

Need little advice, On purchase Order's at the moment we have got Item unit of measure set to cases to calculate the total quantity, I want to add another field next to Line Amount that will calculate the total amount of quantity in kilos using the net weight in the item card.

Field Line Amount Kg = Quantity * Net Weight

Can you please let me know the best way to do this? thanks in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Gerardo Rentería Ga... 25,369 Most Valuable Professional on at

Like (0)

Report

Hi

You can use the onaftervalidate event of the quantity field.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/triggers-auto/fieldextension/devenv-onaftervalidate-fieldextension-trigger

https://www.hougaard.com/many-ways-to-validate-a-field-in-al-and-business-central/

BR

GR

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

In summary here are steps -

1. Add a new field via tableextension in the Purchase Line Table.

2. Using page extension add that field into purchase order subform page.

3. Using a codeunit subscribe to event OnAfterValidate for field quantity.

4. Write your logic in the subscribed event.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi, because the required fields are all on the Purchase Line, you can simply follow the code below.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No