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

(1) Share

Report

Posted on by Community member

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:

Business Central

All responses (2)

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 71,656 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