I'm not 100% sure on this, but I think you can query the customerTransactions by voucherType(11) and date, and also use the paidstatus (1 or 2). The customerTransaction, is by what I understand, get rows for each action for the invoice happens. The openCustomerEntries  only shows which invoices that are open NOW ... View more