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

Notifications

Announcements

No record found.

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
    Nitin Verma Profile Picture
    21,698 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
    76 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,698 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
    76 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
    Community member 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,226

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,047 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,257 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans