Invoice Fees in Database?

[Adam]

Hey,

Does anyone know how Invoice fees are calculated in the database? I can find the total amount of an invoice that is paid, but can't find how much the fees where involved in the transaction.

I searched both tblinvoiceitems and tblinvoices but couldn't find anything.

What I'm trying to do a custom report for my self, more or less a copy of /whmcs/admin/transactions.php with a few options made for my backend system.

Any ideas?

Thanks,
Adam

[Dominic]

tblaccounts I think, offhand :)

[Adam]

tblaccounts I think, offhand :)

Hey,

I would never expect it to be named that, but it shows the fees :)

Thanks,
Adam