mauwiks Posted June 10, 2019 Share Posted June 10, 2019 Great @brian! Thanks, Buddy! 0 Quote Link to comment Share on other sites More sharing options...
mauwiks Posted June 10, 2019 Share Posted June 10, 2019 It shows on the Reports Section but when I tried to click through it, it returns an error. 0 Quote Link to comment Share on other sites More sharing options...
Chance Posted June 10, 2019 Author Share Posted June 10, 2019 (edited) @Mauwiks These reports were originally posted for others back in 2011 and have not been updated by us for the latest versions of WHMCS. The code in these scripts does not rely on core-architecture of WHMCS. From what we hear from @brian!, it appears these old reports do work with v7.7.1 although we have not tested that ourselves. Odds are, if they do work with v7.7.1 they might work with the latest as well. However, the old reports utilize mysql, which is deprecated and no longer even supported in current versions of PHP. So for those servers/hosts that do not have the mysql extension installed/enabled, these old reports will NOT work. @brian! Thank you for confirming compatibility with v7.7.1. As to your personal thoughts on not classifying it as a P&L report, please note the very first post where I stated these reports were from our highly-customized WHMCS install. At the time we provided these reports in this thread we had written a lot of customized accounting code. We do track expenses and costs of goods related to the products and services we sell. As such, these reports did report both sides of the T-bar with breakdown of gross, cost, and net. Knowing other users did not have the expense-tracking side of our customization, we truncated the code for this thread and left the reports named as they were. For all that are interested, we have authored a full-fledged add-on module to WHMCS that provides QuickBooks-like accounting. It is quite extensive and provides all the missing functionality that WHMCS lacks, and it greatly enhances other WHMCS interfaces (invoices, quotes, transactions, etc). It offers a chart of accounts, items lists, vendor list, much more in-depth sales tax agency/rules that allow one to properly track sales tax collected, proper client credit handling (both admin and client side) with ability to track/manage that unearned revenue accurately, better handling of clients paying two invoices at the same time, proper tracking of gateway processing fees (COGs), better billable item and billable time tracking, proper recording of income from product add-ons (like SSL, dedicated IP, etc.), and the list goes on. It is impossible to list every feature. For those interested in the accounting add-on, please see this topic: https://whmcs.community/topic/274605-double-entry-accounting-module/ as we are wanting to determine if the user-base is large enough to warrant us releasing the add-on to the WHMCS market place. Chance Edited June 10, 2019 by Chance 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 10, 2019 Share Posted June 10, 2019 (edited) Hi @Chance 23 minutes ago, Chance said: @Mauwiks These reports were originally posted for others back in 2011 and have not been updated by us for the latest versions of WHMCS. The code in these scripts does not rely on core-architecture of WHMCS. From what we hear from @brian!, it appears these old reports do work with v7.7.1 although we have not tested that ourselves. Odds are, if they do work with v7.7.1 they might work with the latest as well. However, the old reports utilize mysql, which is deprecated and no longer even supported in current versions of PHP. So for those servers/hosts that do not have the mysql extension installed/enabled, these old reports will NOT work. i'd forgotten about that deprecation when testing... originally tested in v7.7.1 using PHP 5.6 and works fine; switched to php v7.1 and it fails - "mysql_free_result is not supported"... with some tweaking, it could be fixed to work with Capsule. 23 minutes ago, Chance said: @brian! Thank you for confirming compatibility with v7.7.1. As to your personal thoughts on not classifying it as a P&L report, please note the very first post where I stated these reports were from our highly-customized WHMCS install. At the time we provided these reports in this thread we had written a lot of customized accounting code. We do track expenses and costs of goods related to the products and services we sell. As such, these reports did report both sides of the T-bar with breakdown of gross, cost, and net. Knowing other users did not have the expense-tracking side of our customization, we truncated the code for this thread and left the reports named as they were. no offence meant ☺️ Edited June 10, 2019 by brian! 0 Quote Link to comment Share on other sites More sharing options...
Chance Posted June 10, 2019 Author Share Posted June 10, 2019 (edited) @brian!Both links are valid. They both refer to the same accounting add-on module that we use ourselves. Thank you for pointing this out. I will update my reply with the link specifically targeted for user-interest. Thank you! Edited June 10, 2019 by Chance 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 10, 2019 Share Posted June 10, 2019 3 minutes ago, Chance said: Both links are valid. only for you.... everyone else would have got an error message following your original link... edited my post to remove the link you posted originally. 🙂 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 10, 2019 Share Posted June 10, 2019 25 minutes ago, Mauwiks said: It shows on the Reports Section but when I tried to click through it, it returns an error. probably a PHP error as I state above... I originally tested on PHP 5.6 as that's what the dev was last using... the PHP7 deprecations never occurred to me until Chance mentioned it. 0 Quote Link to comment Share on other sites More sharing options...
mauwiks Posted June 20, 2019 Share Posted June 20, 2019 Thanks Bri... :) 0 Quote Link to comment Share on other sites More sharing options...
mauwiks Posted June 20, 2019 Share Posted June 20, 2019 Thanks Bri... :) 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.