Topic: Fixed Assets
Any one can help to how to use Fixed Assets and depreciation for frontaccounting 2.4?
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
Fixed Assets was an extension in FA 2.3 and is builtin to FA 2.4 natively. The wiki does not yet have a page on it.. Fixed Assets on the Wiki
To configure the Fixed Assets, enable the role for it (Fixed Assets Configuration), save the role and logout and login again.
The attached screenshots are self explanatory.
Re: Fixed Assets
I got the same problem too. can't process depreciation and i can't find any tutorial about this.does anyone can help??
Re: Fixed Assets
Re: Fixed Asset Purchase
Hi, good folks.
fixed asset purchase comes with 1 qty item? the qty column(field) is greyed out. if you have two items of an asset, you cannot capture the other one. has anyone a clue about how to enable the qty field editable?
in anticipation of your kind response
Re: Fixed Assets
Normally, fixed assets are treated as separate units to depreciate them individually.
Example, there are 5 Air Conditioners (same model) installed in a company but all purchased on different dates.
Therefore, each AC is allotted separate ID for ease of calculation of depreciation.
In your case, you can have similar NAMEs of the FA adding -a, -b, -c at the end.
Suppose you have 2 Photo Stat Machines, 1 for the Administration Section and the other for Account Section.
You can name them as Photo Stat - A and Photo Stat - B.
Re: Fixed Assets
Dear All
I cannot process depreciation. It said :
"There are no active fixed asset defined in the system."
But in --> Fixed Assets Valuation Report. I See the Fixed Assets was there.
I'm using 2.4.3 version.
Don't know what to do.
Please help,
Regards,
Agus Widi
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
Precisely that - enter the fixed assets into FA first. Enable those permissions in the Setup => Roles for the user role you want those permissions for, logout and then login again and the said use with the appropriate role will be able to create fixed assets.
Re: Fixed Assets
Helo,
Thank you apmuthu for the reply.
FYI I logged in as System Administrator which is Checked for everything in Setup --> Role, including Fixed Assets.
I'm All ready input : Fixed Assets Class, Categories, Location, And Fixed Assets itself.
Also After that I Already input : Fixed Assets > Transactions > Fixed Asset Purchase.
So I can see the Fixed Asset Item listed on 'Fixed Asset Valuation Report'
Now the problem is I cannot 'Process Depreciation'.
It keeps saying : "There are no active fixed asset defined in the system."
FYI :
My fiscal Year Start 01-01-2017
My fiscal Year End 31-12-2017
I input one purchase on date : 01-01-2017
What should I do?
Regards,
Agus Widi
Re: Fixed Assets
Hello,
Dear apmuthu,
I've looking for the source code : 'data_checks.inc'
ON line 251, I 've found this code :
function db_has_stock_items()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='F'");
}
I changed it to :
function db_has_stock_items()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='F'");
}
Now 'Process Depreciation' works.
Still I'm confused and worried, is there any consequence on another module if I change this.
Is this a BUG?
Regards,
Agus Widi
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
The normal stock items are not Fixed Assets and no such change is needed.
You need to look at the function db_has_depreciable_fixed_assets() in the same file - includes/data_checks.inc. You probably need to set the fixed asset as depreciable and choose what method of depreciation you want and make sure you have completed the year for it to be able to process depreciation.
Re: Fixed Assets
Hello,
Yes I see the function db_has_depreciable_fixed_assets().
But my issue was not that one.
As I mention the errror message was : "There are no active fixed asset defined in the system."
And it refer to Function : db_has_stock_items().
I still go on with changed script.
I see The Process Depreciation work well, as it should.
I'll inform the further problem.
Regards,
Agus Widi
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
Rather than change the function, change it to a call to another function by making line 135 in fixed_assets/process_depreciation.php:
check_db_has_stock_items('There are no active fixed asset defined in the system.');to be:
check_db_has_depreciable_fixed_assets('There are no active fixed asset defined in the system.');@joe: commit if okay.
Re: Fixed Assets
Janusz is looking at this tomorrow.
Joe
Re: Fixed Assets
Joe, Any progress on this issue?
Regards,
Mugao
Re: Fixed Assets
Yes. Janusz reports that this is of priority.
Joe
Re: Fixed Assets
Hello @joe, @apmuthu,
Please this fantastic module needs the attention it deserves from the bosses mentioned.
the module seems not to be working since the process depreciation is raising a red flag even with the recommended commits from @apmuthu.
we need to find a solution.
Re: Fixed Assets
Hello,
the file data_checks.inc is not in the includes folder. Please where is it located. or am i the one getting the location wrong. thanks
apmuthu wrote:
The normal stock items are not Fixed Assets and no such change is needed.
You need to look at the function db_has_depreciable_fixed_assets() in the same file - includes/data_checks.inc. You probably need to set the fixed asset as depreciable and choose what method of depreciation you want and make sure you have completed the year for it to be able to process depreciation.
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
It is there - see this link - maybe you are using some version other than v2.4.3+.
Re: Fixed Assets
Hello Dear Apmuthu.
I guess you mean is : process_depreciation.php. (Yes, stands corrected now. Thanks).
BTW. I follow your suggestion. It works.
I think this is the best update so far.
Thank you.
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
@joe: Can commit post 12 herein.
Re: Fixed Assets
Will fix it later today.
Joe
Re: Fixed Assets
This has been committed to 2.4 official repo.
/Joe
Re: Fixed Assets
Hello,
Dear Joe and Apmuthu.
Thanks for the the update below:
https://github.com/FrontAccountingERP/FA/commit/2e95a5672e4cabeaba603da7ac1105c3acb865ea
I follow and tested the script.
The Process Depreciation is working, I'm using the original file of "data_checks.inc".
Now I go to Manage > Fixed Assets.
Usually I can select Fixed Asset that I have inputed before (I have several).
But Now I cannot see this : ---> Select an item: (which is usually placed on top).
So it makes me cannot modify an Fixed Asset.
Fortunately, I did following (AGAIN):
I've looking for the source code : 'data_checks.inc'
ON line 251, I 've found this code :
function db_has_stock_items()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='F'");
}
I changed it to :
function db_has_stock_items()
{
return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='F'");
}
Now, I can manage Fixed Asset.
I can select Fixed Asset and edit them.
I guess this problem related to "Process Depreciation" problem that I have submitted before.
Regards,
Agus Widi
- apmuthu
- Moderator
- Offline
Re: Fixed Assets
This should not be done. A stock item is not a fixed asset item. We are now using a different function for the checks here: check_db_has_depreciable_fixed_assets()
Re: Fixed Assets
apmuthu wrote:
This should not be done. A stock item is not a fixed asset item. We are now using a different function for the checks here: check_db_has_depreciable_fixed_assets()
Where should I change to use :
check_db_has_depreciable_fixed_assets
Since I'm a new beginner. It's too complicated for me, please explain more. Like, which file, and row number. 
Regards,
Agus Widi