TDS Report

[Former Member]

Hi Experts,,

After adding outgoing payment of TDS, from where i can found on which invoice or document I have paid the TDS??

after adding the document there is no update in table VPM6-WTAX.

Could anyone have a query of TDS paid report??

Thanks

Manoj S

[former_member325312]

Hi Manoj

pls check out this query

SELECT T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName],T4.[WTAmnt], T1.[DueDate], T1.[CheckNum], T1.[CheckSum] FROM OVPM T0 INNER JOIN VPM1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OPCH T2 ON T0.DocEntry = T2.ReceiptNum INNER JOIN PCH1 T3 ON T2.DocEntry = T3.DocEntry INNER JOIN PCH5 T4 ON T2.DocEntry = T4.AbsEntry WHERE T0.[DocNum] =[%0] GROUP BY T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName],T4.[WTAmnt], T1.[DueDate], T1.[CheckNum], T1.[CheckSum]

if ur prob solved pls do close thr thread

cheers

Jenny

Edited by: Jennifer Anderson on Jun 21, 2010 10:40 AM

Edited by: Jennifer Anderson on Jun 21, 2010 10:44 AM

[Former Member]

Hi Jennifer,

Thanks for reply!!

But the querry is not working and not according to my requirement.

I need a report after adding Outgoing Payment of TDS with below fields :-

Outgoing payment - Docnum, date, location, BSR code, challan Date,Challan No., Bank Name, Total amount, Section Code, Section Name, Assessee Type,

and from TDS Entries i need - DocNum, date, Vendor Code, Base aamount, TDS Amount, Surcharge amount, cess amount, Hsc Amount,

and from payment means - Bank transfer- GL Account, transfer date.

Thanks & Regards

Manoj S