Jump to content
Ragonz

Creating a new report

Recommended Posts

Trying to work out how much income we take from a specific country. Does anyone know if there is a way or how to create a report to gain the following information

 

Transactions + total income but able to choose a country where the clients are based

UK VAT report

Share this post


Link to post
Share on other sites
2 hours ago, Ragonz said:

Trying to work out how much income we take from a specific country. Does anyone know if there is a way or how to create a report to gain the following information

Transactions + total income but able to choose a country where the clients are based

do you need a detailed list of the transactions or just the totals for each year (and the grand total)?

the usual 3 solutions are to either...

  • find an existing report that is similar to what you want and modify it for your needs.
  • use a MySQL query directly in phpmyadmin or similar.
  • write a WHMCS report from scratch.

ultimately, all you're doing is joining tblclients to tblaccounts, specifying only GB results and then it's just a case of working out what values you need in the results.

Share this post


Link to post
Share on other sites

For now all I need is the toal value per year we take from a selectable country

 

in future it would be useful to be able to see a list of the transations from said country for said time frame

Share this post


Link to post
Share on other sites
3 minutes ago, Ragonz said:

For now all I need is the total value per year we take from a selectable country

check your PM for the mySQL query for that. 🙂

26 minutes ago, Ragonz said:

in future it would be useful to be able to see a list of the transactions from said country for said time frame

it shouldn't be difficult to add a country filter to the transactions report that would allow you to specify a 2-letter country code to search for, e.g GB, US etc.

Share this post


Link to post
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.

Guest
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