FrontAccounting forum — How to input fixed assets workings?

Re: How to input fixed assets workings?

2011-10-28T09:56:47Z

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?

2011-10-28T09:56:40Z

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?

2011-10-16T06:53:52Z

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?

2011-08-23T07:07:32Z

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?

2011-08-21T09:26:52Z

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?

2011-08-21T09:12:23Z

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?

2011-08-19T09:04:08Z

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

Re: How to input fixed assets workings?

2011-08-11T14:23:17Z

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?

2011-08-11T10:21:38Z

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.