cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query for Payment Drafts Report

Former Member
0 Kudos

Hi experts,

I would like to know if can I get the excaly same data I get when I go on Banking -> Banking Reports -> Payment Drafts Report using a SQL Query, because this will be in a report along with other data.

I found out that in OPDF table I can find the data I want but with so many more entries and I could not identify what differs the data from Payment Drafts Report and other data in the table.

Hope you can help me.

Regards,

Lucas

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Lucas,

We don't use this part. But you can try this way:

Run:

SELECT T0.DocNum, T0.DocDate, T0.CardCode, T0.DocTotal, T0.Comments,T0.Canceled FROM OPDF T0

WHERE T0.CardCode = '[%0\]'

Compare system report to decide how to link to Incoming/Outgoing payment table ORCT/OVPM

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

sorry, but I think I missed something.

I need them as drafts. If they are not inserted as Outgoing/Incoming Payment they are not shown in OVPM/ORCT right?

What I need is to return exactly what I get when going in Banking -> Banking Reports -> Payment Drafts Report.

Regards,

Lucas

Former Member
0 Kudos

Since I do not have data in our db, I just give you a wrong table list. They should be OINV/OPCH instead.