Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in TDS calculation in AP Invoice through DTW


My scenario is like this:

I select Service Type AP Invoice, and enter Rs. 308990 in LineTotal, and select WT Liable as Yes.

In WT Table, we manually change the Taxable Amt to 275000, so that TDS @ 10% comes to 27500.

This works fine from the SAP application.

But when I try to upload a similar invoice using DTW, it calculates the TDS amount on 11236, instead of 10000.

Screenshot1: My Excel file for DTW

In the above screenshot,

I am using the first file for Documents, 2nd file for Document_Lines, 3rd file for WithholdingTaxData. It gets upload but TDS does not match.

I also tried using the 3rd file for WithholdingTaxLines, instead of WithholdingTaxData. But then it does not upload only. It gives Internal Error.

Screenshot 2: Manual Entry in SAP Business One client application

Screenshot 3: AP Invoice uploaded through DTW:

What is the solution?


Not what you were looking for? View more on this topic or Ask a question