on 04-14-2011 7:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.