News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Update Subtotal Excl. VAT

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

Suggested answer

Update Subtotal Excl. VAT

(0) Share

Report

Report

Posted on by Community member

Article := GetServiceArticleNo();

SalesLine.SetRange(/Document Type/, Rec./Document Type/);

SalesLine.SetRange(/Document No./, Rec./Document No./);

SalesLine.SetFilter(/No./, '=%1', Article);

if (SalesLine.Count <> 0) and (SalesLine.FindFirst()) then begin

PriceListLine.SetRange(Status, PriceStatus::Active);

PriceListLine.SetRange(/Product No./, SalesLine./No./);

PriceListLine.SetRange(/Source Type/, SourceType::/All Vendors/);

PriceListLine.SetFilter(/Starting Date/, '<=%1', DueDate);

PriceListLine.SetFilter(/Ending Date/, '>=%1', DueDate);

if PriceListLine.FindFirst() then begin

SalesLine.Validate(Quantity, Round(MontageSum / 60, 0.01));

SalesLine.Validate(/Unit Price/, Round(MontagePrice / SalesLine.Quantity, 0.01));

SalesLine.Modify;

end;

end

I have the issue with update Subtotal Excl. VAT after this code, is not updated after recalculation

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 85,674 Super User 2025 Season 1 on at

Like (0)

Report

Update Subtotal Excl. VAT

Hi, hope the following can give you some hints as well.

Dynamics 365 Business Central: How to add new fields to Total Area on the Document Subform page (View Total Quantity, Number of Lines on the Sales Order)

https://yzhums.com/25033/

Thanks.

ZHU
Suggested answer

Ariba Mehdi 160 on at

Like (0)

Report

Update Subtotal Excl. VAT

Hi there,

For the business central's out of the box field, we use Event Subscriber to modify the value of the field.

For this, create a code unit and use the relevant event subscriber and pass the record to the codeunit.

Here's an example of how:

Look for OnAfterCalculateSalesSubPageTotals in the Document Totals codeunit. Do the changes and modifications inside this method.

Incase this event subscriber doesn't work, try debugging, or try some other event subscriber methods in the Document Totals codeunit or by exploring how Subtotal Excl. VAT field is being calculated.

Hope this helps!

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans