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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

TDS Calculation in Negative - D365 BC

(3) ShareShare
ReportReport
Posted on by 344

Dear Experts,

Request your guidance on the below case related to TDS adjustment.

I had posted an Advance Payment of Rs. 12,94,327, in which TDS was deducted on Rs. 10,97,000, and the TDS amount was Rs. 1,097.

Now, I am posting the Purchase Invoice and applying the above advance payment against it.

Details are as under:

Applied Payment Amount: Rs. 10,97,000

(TDS Amount: Rs. 1,097)

Total Purchase Invoice Amount (TDS applicable): Rs. 11,27,338.50

 

After applying the advance payment, the remaining amount is Rs. 30,338.50.

Accordingly, the TDS amount should be Rs. 30.34, which is correctly updated in the third line.

However, the issue is that a negative TDS amount of Rs. –285.91 is calculated in the second line.

Further, in Preview Posting, I noticed that TDS entries are generated for Rs. –255.57 with a TDS base amount of 0, which is not clear.

 

Kindly guide on the following points:

1.Why is a negative TDS entry generated during the application of advance payment?

2.Why is the TDS base amount showing as zero for the negative TDS entry?

3.Why is the system generating a negative TDS adjustment instead of directly posting the correct TDS amount of Rs. 30.34 on the remaining invoice value?

 

Your guidance on the above will be highly appreciated.

 
Purchase Invoice details line wise:
 
I have the same question (0)
  • Suggested answer
    Dynamics_Decoded_Gokul Profile Picture
    483 on at

    1. Why is a negative TDS entry generated during the application of advance payment?

     

    In Business Central, when an advance payment with TDS already deducted is applied to a Purchase Invoice, the system reverses the TDS impact of the advance at the invoice stage. This reversal is required so that TDS can be recomputed on the full invoice value and then adjusted against the TDS already deducted on the advance.

    This reversal appears in Preview Posting as a negative TDS entry.

    2. Why is the TDS base amount showing as zero for the negative TDS entry?

     

    The negative TDS line is not a fresh TDS calculation but an adjustment/reversal entry. Since it does not relate to any taxable invoice value, Business Central sets the TDS Base Amount to zero and posts only the adjustment amount to correct earlier TDS posted on the advance.

    3. Why is the system generating a negative TDS adjustment instead of directly posting the correct TDS amount of Rs. 30.34?

     

    Business Central follows a compliance-driven posting logic where:

    • TDS is first normalized at the invoice level, and

    • TDS already deducted on advances is reversed and re-applied.

    • This ensures a complete audit trail between advance TDS and invoice TDS. Therefore, instead of directly posting Rs. 30.34, the system posts:

    • a negative TDS adjustment (reversal of advance TDS), and

    • =a final net TDS, resulting in the correct payable TDS of Rs. 30.34.

  • Suggested answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    10,875 Super User 2026 Season 1 on at
    Hello ,
     
    Negative TDS is an adjustment of TDS already deducted on the advance payment
     
    TDS base = 0 because it’s a reversal entry, not a fresh deduction
     
    BC must reverse first, then re-apply TDS on the remaining invoice value
     
     
    Net result is correct: only ₹30.34 TDS on the balance, total TDS stays compliant.
     
    This is standard India TDS behavior, not a setup issue.
     
    Regards,
    Oussama Sabbouh
  • Dharmesh Profile Picture
    344 on at
    But how system calculated Rs.-285.91 and there is not any details for Rs.30.34.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,155 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,043 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 955 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans