Announcements
No record found.
Hi,
I want to extract payment data against invoices. Is there any relation between tables VendInvoiceJour and BankChequeTable or any other way to get these records
Regards,
Arshad
*This post is locked for comments
Hi M.Arshad,
I believe the best way is to use VendTrans. From VendTrans you can find which invoice was settled with which payment (by using LastSettledVoucher, TransType = Payment and Purchase order) and from there you can easily take check number if you join BankChequePaymenttrans
If you make a payment from a bank account then you can see directly from the bank account all of the invoices that have been paid. You do not need a report for that. Here is a screenprint that shows you the form:
An alternative is the payment history function that lists you all payments and the invoices that have been paid with them.
Best regards,
Ludwig
What would be the joining field between Vendtrans and BankChequeTable
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
