TDS : Bank Challan Report

[pradyuman_singh]

Hi experts,

While doing SAP TDS entries I selected the all the A/P invoices but I need to create a report in which I incorporate all those such invoices which I selected there so that any user can get that in particular TDS challan which A/P invoices is has been selected.

I created a query and tried on many dates but this is not returning any data.

For reference i attahced pic of selected a/P invoices.

Please help me.

Select
ovpm.CardCode, OVPM.CardName ,ocrd.LicTradNum,ocrd.City,
ovpm.DocNum, ovpm.DocDate,vpm6.TxblAmntFC,
vpm6.TaxbleAmnt,vpm6.WTSumFC, vpm6.WTSum ,opch.NumAtCard,OVPM.Comments
,ovpm.DocTotal ,
--INTO TB1
from OCRD
join OVPM on OCRD.CardCode = ovpm.CardCode
inner join
VPM6 on VPM6.DocNum = ovpm.DocEntry
inner join
OPCH on opch.CardCode =OCRD.CardCode

where
ovpm.Canceled <>'y' and OVPM.[DocDate] = '2020-07-03'

[jitin_chawla]

Hi,

This query will not return any data as the TDS type Payment will not have any entry in the VPM6 table (which i assume).

Instead try creating a query based on the OPCH (DocType 'D' = TDS), OVPM, VPM4 & VPM8 table. Check if you get the query for your dates then.

regards,

Jitin