News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... I want to add a colum...

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

Answered

I want to add a column VAT in the Purch.Inv.Line table and I want to add a column

(1) Share

Report

Report

Posted on by Community member

21

I want to add a column VAT in the Purch.Inv.Line table and I want to add a column which will have values = Amount including Vat - Amount. how to do this? Please help !!!!!!!!!!!!!

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (1)

Community member 21 on at

Like (1)

Report

I want to add a column VAT in the Purch.Inv.Line table and I want to add a column

Thanks a lot.
Verified answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (1)

Report
I want to add a column VAT in the Purch.Inv.Line table and I want to add a column

Hi, this requires customization. Hope the following helps.

pageextension 50122 MyExtension7 extends "Posted Purch. Invoice Subform" { layout { addafter("Line Amount") { field(TotalVAT; TotalVAT) { Caption = 'Total VAT'; ApplicationArea = All; } } } trigger OnAfterGetRecord() begin TotalVAT := 0; TotalVAT := Rec."Amount Including VAT" - Rec.Amount; end; var TotalVAT: Decimal; }

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans