WebHostingPeople Posted October 5, 2018 Share Posted October 5, 2018 I have Tax enable and 2 rules in Level 1 & 1 rule in level 2. That all working fine and Invoices are fine with Tax. But please let me know how can I get monthly paid invoices reports in csv format that should be show both level Tax. At present if I get report from Sales Tax liability option, that show total Tax not both level wise Tax. Please guide me how can I get monthly paid invoices reports in csv format that should be show both level Tax. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 5, 2018 Share Posted October 5, 2018 34 minutes ago, webhostingpeople said: Please guide me how can I get monthly paid invoices reports in csv format that should be show both level Tax. upload the attached file to /modules/reports and you should see an additional report on the Reports page called "Sales Tax Liability Taxlevels"... when you run this custom report, you should see the Tax values output split correctly between L1 & L2. the report is written for WHMCS v7.6.1, but should work for previous versions too. sales_tax_liability_taxlevels.php 0 Quote Link to comment Share on other sites More sharing options...
WebHostingPeople Posted October 5, 2018 Author Share Posted October 5, 2018 Hi, Thanks lot Mr. Brian. It`s working fine. One thing more that i forgot to post. I made a custom field for the client profile for mention client Tax No.. I require that custom field value also in this report. Please guide me. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 5, 2018 Share Posted October 5, 2018 17 minutes ago, webhostingpeople said: One thing more that i forgot to post. I made a custom field for the client profile for mention client Tax No.. I require that custom field value also in this report. Please guide me. custom fields are awkward - especially when I don't know it's exact name or ID... therefore, you are going to have to change one of the lines of code in the attached report at line 89. AND tblcustomfieldsvalues.fieldid = '37' if you go to the Custom Client Fields page, right-click on your Tax No field and choose 'Inspect Element' (or similar), you should get to see the source of the client field - the fieldname value in that code will be the number you need to change '37' to in the above report code... so if you see name="fieldname[101]" in the source code, - you would change that line of code in the report to... AND tblcustomfieldsvalues.fieldid = '101' once you find the correct value, then the report will output the correct Tax No value for each client. sales_tax_liability_taxlevels.php 0 Quote Link to comment Share on other sites More sharing options...
WebHostingPeople Posted October 5, 2018 Author Share Posted October 5, 2018 Hi, Great! It`s working fine. But as I have 2 rules in Level 1 and 1 rule in level2. Result is showing 2 items Tax & Tax2 . Tax has both rules. Let us explain in details. client A has rule1 Client B has rule2 & rule3 result is showing : Client A > rule1 value in Tax Column -- ok Client B > rule2 value in Tax Column AND rule3 value in Tax2 Column BUT RESULT should be in FOLLOWING manner: Client A > rule1 value in Tax Column -- ok Client B > rule2 value in Tax1 Column AND rule3 value in Tax2 Column means should 3 cloumn Tax1 for level1 , Tax2 for level2 , Tax3 for level3 Please also guide me how can rename in table heading Tax1, Tax2 , Tax3. 0 Quote Link to comment Share on other sites More sharing options...
WebHostingPeople Posted October 5, 2018 Author Share Posted October 5, 2018 Hi Mr. brian Another issue in this script. Result is showing suppose total Invoice found 16 but in rows are coming 9 . Means all rows are not coming to display. I tested export csv file that is also showing 9 rows. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 5, 2018 Share Posted October 5, 2018 20 minutes ago, webhostingpeople said: Please also guide me how can rename in table heading Tax1, Tax2 , Tax3. by default, you can only apply two taxes to each invoice (1xL1 & 1XL2)... if you're based in India and need GST solutions, you might want to check out the addons is Marketplace - there were a couple of GST addons in there the last time I looked (though one might have just been temporarily removed). 0 Quote Link to comment Share on other sites More sharing options...
WebHostingPeople Posted October 5, 2018 Author Share Posted October 5, 2018 (edited) Hi, I know and you should also know about them . Please look here https://whmcs.community/topic/291550-whmcs-global-services-hacked-and-doing-nothing-about-it/ Your script is perfect but require some fine tuning . Main issue is that not showing all records rows. Edited October 5, 2018 by webhostingpeople 0 Quote Link to comment Share on other sites More sharing options...
WebHostingPeople Posted October 5, 2018 Author Share Posted October 5, 2018 Hi Mr. brian, Your first given script is perfect that is without custom field. When we add code for showing custom field then full result is not come. 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.