FrontAccounting forum — How to input fixed assets workings?

Re: How to input fixed assets workings?

null@example.com (itronics) — Fri, 28 Oct 2011 09:56:47 +0000

You have improperly installed asset register extension. I do not know rea for this, but you can reset installation running modules/asset_register/sql/update.sql file via phpmyadmin.

Re: How to input fixed assets workings?

null@example.com (itronics) — Fri, 28 Oct 2011 09:56:40 +0000

You have improperly installed asset egister extension. I do not know rea for this, but you can reset installation running modules/asset_register/sql/update.sql file via phpmyadmin.

Re: How to input fixed assets workings?

null@example.com (ahmed.kabir) — Sun, 16 Oct 2011 06:53:52 +0000

Dear Janusz,
I installed the Asset register as you said. But it shows an Error when ever i try to enter.

For Amortisation Posting It Says -

DATABASE ERROR : could not get year assets
error code : 1146
error message : Table 'erp.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE (a.inactive = 1) AND (YEAR(a.disposal_date) = 2011)

For Asset Type Entries :-

DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'erp.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive

For Asset Entries it says :-

DATABASE ERROR : could not get all assets
error code : 1146
error message : Table 'erp.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive

What is the fix to it?? Please Help..

Thank you
ahmed

Re: How to input fixed assets workings?

null@example.com (ahmed.kabir) — Tue, 23 Aug 2011 07:07:32 +0000

I have Installed the Asset register as you said. But I cant find it. And could you give me an wxplaination on what it does? It would be rather helpful.
Ahmed

Re: How to input fixed assets workings?

null@example.com (itronics) — Sun, 21 Aug 2011 09:26:52 +0000

You can void transaction in n Setup/Void a Transaction. Voided transaction remains in database, but with no amount/quantity info.
Janusz

Re: How to input fixed assets workings?

null@example.com (ahmed.kabir) — Sun, 21 Aug 2011 09:12:23 +0000

Ok. Thank You. Another question I had to ask was is there any way to completely delete a transaction without losing any other data?

Ahmed

Re: How to input fixed assets workings?

null@example.com (itronics) — Fri, 19 Aug 2011 09:04:08 +0000

You can also install Asset Register extension in Setup|Install/Activate Extensions.
Janusz

Re: How to input fixed assets workings?

null@example.com (joe) — Thu, 11 Aug 2011 14:23:17 +0000

You should be able to use the items. Mark the 'not for sale' checkbox.
Then use an inventory account for this asset.

/Joe

How to input fixed assets workings?

null@example.com (ahmed.kabir) — Thu, 11 Aug 2011 10:21:38 +0000

Dear Joe,

I am working with all my might but i can't seem to find a way to enter all my workings especially my Fixed assets in the Balance sheet.

What do i do to and how do i do it? Please help me out.