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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

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