Jump to content

help with SQL to retrieve Transaction Data?


Recommended Posts

Hi all


I want to pull out client names, amounts and payment methods from WHMCS to use with my accounting software. This data used to be in the Transaction Export CSV (was there last time I used it) but now is not - boo :(


Anyway -- I am attempting to create a custom report for this, but got stuck when it came to the querying the DB to pull it all out (the most important bit, yeah :) I have no idea which tables/columns I need to query... and I'm rusty on programming...


So, I am hoping someone here can give me a hand? :idea:


These are the columns I want out of the DB:

  • Date
  • Client Name
  • Invoice ID
  • Amount In
  • Fees
  • Amount Out
  • Payment Method


Here is WHMCS docs I was referring to: http://docs.whmcs.com/Reports

but I didn't get much further than renaming my PHP file and choosing my tableheadings... the next part took way too much brain-power to decipher without comments :crushed:


Hopefully this is super easy for someone and they can point me in the right direction...



- Mrs K

Link to comment
Share on other sites

UPDATE: Looks like I just need to update my WHMCS install to get the report I need:



For future reference, is there a DB table/column listing somewhere on this site? That would make it easier to work out where I can pull report data from... otherwise do I have to log into PHPMyAdmin to view the tables/columns there?



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated