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?