I'm on Sage50, 2019. I've connected to the ODBC driver and have found the following query gets me part way there.
SELECT a.Reference, a.AmountPaid,a.Description,
a.JrnlKey_Journal, a.TransactionDate, a.MainAmount, a.Reference, a.TrxName,
a.* FROM JrnlHdr a
WHERE completeddate = '2022-06-30'
AND AmountPaid <0
I cannot get accurate check numbers for the checks.