on 07-30-2020 2:42 PM
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'
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
9 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.