Jump to content

Income Reports and Currencies


DimaK

Recommended Posts

Hello,

In WHM I have 3 Currencies and now  some important reports  are very non-informative.

Income Forecast
Income by Product
Sales by Product

They show separate reports in different currencies. We have to manually change the currency.

Is it possible to make these reports with all currencies in one table (counted in main currency) ?

 

Maybe somebody already have such reports ?

 

Thanks.

 

 

Link to comment
Share on other sites

14 hours ago, DimaK said:

Is it possible to make these reports with all currencies in one table (counted in main currency) ? 

Income Forecast would be difficult unless you know what the currency rates are going to be in the future - but if you can predict them, you shouldn't be using WHMCS, you should be lying on a beach somewhere! 🏖️

the simplest way you could do it would possibly be to base it on today's exchange rate, but that's going to fluctuate over the period you're forecasting, so it's not going to be an accurate forecast.

the problem with the other two reports is that they're querying tables that don't store exchange rates - neither the hosting or invoice tables will contain exchange rates, only the product amount - and not even the currency used as that is assigned to the client, not the order... possibly you could pull the exchange rates for each invoice from tblaccounts for your calculations, but this is more than a minor tweak to the reports!

14 hours ago, DimaK said:

Maybe somebody already have such reports ?

the old Community Addons site used to have a lot of free reports in there, but none spring to mind that combined currencies in the way you want them to above.

Link to comment
Share on other sites

  • 1 year later...

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