I want to make a report of Withholding Tax

[saad_omair]

i'm unable to find withtholding tax information which was registered in AP Invoice, i want to generate the report from Bank Payment to calculate how much amount is withhold categorywise.

moreover, i'm unable to find data in INV5 Table to generate this.

need help from the expert.

regards

[Former Member]

Hi,

Check Below Link,

http://scn.sap.com/thread/3667126

Regards

Bhanu

[Former Member]

Hi Saad,

Please follow the below provided threads for TDS query report:

1. 1. TDS QueryReport:
2. http://scn.sap.com/thread/3665492 

Hope this will helpful for you.

Regards,

Bhushan Verma

[Former Member]

Hi Saad,

Try the following Query.

Add or delete the fields as per your requirement.

SELECT distinct T0.[AcctCode], T2.[AcctName],  T5.TaxId0 as 'PAN No',T1.[DocType], T1.[DocDate], T1.[CardCode], T1.[CardName], T1.[NumAtCard], T0.[LineTotal],T1.[VatSum],  T1.[DocTotal], T1.[DocNum],T3.[AbsEntry], T3.[TdsAcc],T3.[WTCode], T3.[Rate], T3.[TaxbleAmnt], T3.[WTAmnt] FROM PCH1 T0  INNER JOIN OPCH T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OACT T2 ON T0.AcctCode = T2.AcctCode INNER JOIN PCH5 T3 ON T1.DocEntry = T3.AbsEntry INNER JOIN OCRD T4 ON T0.BaseCard = T4.CardCode  left join CRD7 T5 on T4.Cardcode=T5.cardcode

where T0.DocDate >= [%0] AND T0.DocDate <= [%1]

Hope this is an answer to your query.

Regards,

Rupesh

[Former Member]

Hi,

Does above query resolved your issue...?

If yes then please close the thread.

Regards,

Rupesh