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

Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

(0) Share

Report

Posted on by Revathi.T

My requirement is to display TDS Amount in the posted purchase invoice page to the Posted purchase invoices list page. So I extended the posted purchase invoices page and try to access "TDS Entry" Table to show TDS Amount. But I'm unable to access in VS Code as this TDS Entry Table is a Temporary table. So thought to use G/L Entry table, but don't know how to use filters in coding to get the TDS Amount. Please suggest me to get TDS Amount from the temporary table "TDS Entry" in VS Code to show in Posted Purchase Invoices Page.

All responses (5)

Answers (0)

Suggested answer

Community member 4 on at

Like (0)

Report

Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

How to display invoice line amount in Update TDS Register?
Revathi.T 76 on at

Like (0)

Report

RE: Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

Yes it is available in BC. In Posted Purchase Invoice page, Click -> Process -> Find Entries -> TDS Entry. In TDS Entry we can able to see the TDS Amount.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

Try to find the TDS entry page from BC and check if you have same record available you are trying to find.
Revathi.T 76 on at

Like (0)

Report

RE: Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

Hi Nitin Verma,

In order to show TDS Amount in Posted Purchase Invoices list page. I extending the Posted Purchase Invoices list page as

pageextension 50102 TDSAmount extends "Posted Purchase Invoices"

{

layout

{

addafter("Amount Including VAT")

{

field(TDSAmount; TDSAmt)

{

ApplicationArea = All;

Caption = 'TDS Amount';

}

}

}

trigger OnAfterGetRecord()

var

TDSEntry: Record "TDS Entry"

begin

TDSEntry.Reset();

TDSEntry.SetRange("Document No.", Rec."No.");

if TDSEntry.FindFirst() then

begin

TDSAmt := TDSEntry."TDS Amount"

end

else

TDSAmt := '';

end;

var

TDSAmt: Decimal;

}

In the above code, I'm unable to get the table "TDS Entry" in VS Code. how to get the amount from the "TDS Entry Table"?

In posted purchase invoice page, The TDS amount is seen only on the factbox side in the table "Tax Transaction Value".
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Need to display TDS Amount in Posted purchase invoices list page from posted purchase invoice page

Hi,

You can make a flowfield on Purch. Invoice Header table showing the Amount from the TDS Entry table, based on the document type and document no. filter based on the posted purchase table.