web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 76

         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
    Community member Profile Picture
    4 on at
    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 Profile Picture
    76 on at
    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.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
    Nitin Verma Profile Picture
    21,575 Moderator on at
    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 Profile Picture
    76 on at
    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 Profile Picture
    21,575 Moderator on at
    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.

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans