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)

Sort by

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

Like (0)

Report
Copy link

Link copied!

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,419 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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 99,322 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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