web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by 86

         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. 

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    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.

  • Revathi.T Profile Picture
    86 on at

    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 Profile Picture
    21,812 Moderator on at

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

  • Revathi.T Profile Picture
    86 on at

    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.MicrosoftTeams_2D00_image-_2800_7_2900_.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.pngMicrosoftTeams_2D00_image-_2800_9_2900_.png

  • Suggested answer
    AK-27040926-0 Profile Picture
    4 on at
    How to display invoice line amount in Update TDS Register?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans