Create New column Fee 2 and Fee 3 on Annual Income Report

[zitu4life]

Hi all

Is there a simple way to add new column fee on annual income report. I am looking for to have Fee 1 Fee2 Fee3. And also this should be counted on final balance.

annual_income_report.php file is not encrypted so we can managed it, but also we would face problem when adding manual transition there is only one field for Fee not Fee2 and Fee3

--------------------------------------------------------------------------------------------

 

 

The way should be editing annual_income_report.php ?

 

[brian!]

22 minutes ago, zitu4life said:

Is there a simple way to add new column fee on annual income report.

yes - you just edit the report code and add them... 🙂

... but modifying the report is not the issue with this question (it's easy to add new columns) - it's finding a way to add the other fee values to the database and work them into the equations.

22 minutes ago, zitu4life said:

I am looking for to have Fee 1 Fee2 Fee3

then you need to find a way to add them separately - unless Kian wants to chip in with an idea, you may end up throwing money at a developer for this, because you might be looking at creating a new db table (unless you modified tblaccounts), plus a method to enter the 3 separate fees... then you'd still have to modify the report sql query to account for the changes.

so I think to answer your question - it's simple enough to add columns to the report... but the rest might take some additional coding. 😕

[zitu4life]

6 minutes ago, brian! said:

yes - you just edit the report code and add them... 🙂

Yes @brian! I have already did it editing annual_income_report.php but actually the challenge was creating all those scripts or codes or database... The needed was trying to use what already exists in WHMCS to has a clearly reports helping  control those major Fee by class and then know quickly, monthly by monthly if It was paid (delivered to government). Actually it is likely I am trying to reducing the fact that WHMCS do not has a built in Expenses, at least allowing us to add manual amount out categorized as Fee 1 Fee2 Fee3 or anything we need and then displayed it on the current report  annual_income_report.php. I will insist until day integrate it as an official addon. @WHMCS ChrisD

@Mauwiks

 

[WHMCS ChrisD]

@zitu4life Whilst I cant say if we will or will not develop an official expenses module now or in the future, I would remind you WHMCS is not designed to replace an accounting system

[zitu4life]

@WHMCS ChrisD Thank you for your feedback. Actually I agree that WHMCS is not designed to replace an accounting system, and I already has my accounting system, but considering that WHMCS are helps a lot in management, and reports, and also helping in analysis business health, it would be even better if reports could shows status of not all income in but also balance regarding expenses...That is why it could be just an addon not core directly integrated.

I am not asking WHMCS to develop it on next release or even next months, but this brain storm is to try to make developers think about...All business exists in a way or another...all regard profit. So like there is these official addon: Project management, Software Licenses, Live chat, etc, etc, Expenses could be an addon too. Of course it will need man work, and later only relax and grow profit for WHMCS.

With an expenses track will help a really better analysis of business Heath every moment and this is not related to be an certified  accounting system. I agree that WHMCS will not be an account system because lots of requirement rather than expense.... I wont post anymore regarding this topic, to avoid been a bored person. 😉

 

 

Edited July 24, 2019 by zitu4life

[WHMCS ChrisD]

@zitu4life If you haven't already done so, please submit a feature request here there is an older request at https://requests.whmcs.com/topic/expense-balance-feature that may go some of the way towards what you are looking at but at this stage, we don't have any plans to add a expense feature, not to say that we will or will not in the future of course.