payment gateways reports

[dsfsfg]

We have 3 payment gateways, and I'd like to find out which customers use which payment gateway, but the reports section doesn't show this to me. Is there any other way of doing this?

[othellotech]

Looking at the Transactions List will be the quick method

Querying the tblaccounts table slightly more complex

Creating a custom report if neither of those give you it in a way you want to use if the slowest solution

[sentq]

1) Clients table "tblclients.defaultgateway" has (should, not anymore) the last payment method this client used to pay his invoice.

2) Orders table "tblorders.paymentmethod" has the payment method selected while client placing his order (didn't check before if this value updated when the invoice paid using different ).

3) Invoices table "tblinvoices.paymentmethod" has the last payment method used to pay for the invoice (the last transaction if the same invoice has multiple)

4) Transactions table "tblaccounts.gateway" is the most accurate one, because with each transaction it save the payment method used, I would recommend to use this table to generate your report.