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

All responses (3)

Answers (1)

Verified answer

YUN ZHU 79,097 Super User 2025 Season 1 on at

Like (0)

Report

Calculated field on Purchase Order

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

Hope this helps.

Thanks.

ZHU
Suggested answer

Saurav.Dhyani 14,312 Super User 2025 Season 1 on at

Like (0)

Report

Calculated field on Purchase Order

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
gdrenteria 15,635 Most Valuable Professional on at

Like (0)

Report

Calculated field on Purchase Order

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