baymax Posted February 21, 2020 Share Posted February 21, 2020 I was using 7.9.1 and the Transactions report's filter for Currency is not working. I've updated to 7.9.2 but it looks like this hasn't changed. Is anyone else experiencing this problem? It does produce the currency but it just does not filter if I enter a specific currency to be filtered. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 21, 2020 Share Posted February 21, 2020 8 hours ago, baymax said: It does produce the currency but it just does not filter if I enter a specific currency to be filtered. because as written, it would be searching for the currency value in the tblaccounts table - and that value is always zero... or at least off-hand I can't think of an occasion when i've seen any other value there! you can see this if you filter on currency equal/containing 0 and it should return all results (effectively the same as not adding the filter). this has been the case in every WHMCS version that i've used as far back as v5.3 - it's fixable though. 0 Quote Link to comment Share on other sites More sharing options...
baymax Posted February 24, 2020 Author Share Posted February 24, 2020 Hey Brian. Something to do with tblhosting.userid and tblcurrencies.id? 🙂 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted February 24, 2020 Share Posted February 24, 2020 9 hours ago, baymax said: Something to do with tblhosting.userid and tblcurrencies.id? 🙂 something along those lines... 🙂 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.