FrontAccounting forum — Purchase of an asset and depreciation

Re: Purchase of an asset and depreciation

null@example.com (citi2014) — Sat, 13 Dec 2014 15:27:36 +0000

same problem here

Re: Purchase of an asset and depreciation

null@example.com (Silverspoon) — Sat, 06 Dec 2014 14:51:24 +0000

Re: Purchase of an asset and depreciation

null@example.com (Silverspoon) — Sat, 29 Nov 2014 14:26:39 +0000

Another question: how to record purchase of an equipment and depreciation of this equipment with the help from this package? Thx

Re: Purchase of an asset and depreciation

null@example.com (Silverspoon) — Tue, 28 Oct 2014 08:24:12 +0000

ive solved it by re-installing the package a few times. Thx for your help, guys.

Re: Purchase of an asset and depreciation

null@example.com (apmuthu) — Mon, 27 Oct 2014 19:19:18 +0000

Do a binary compare with all installed files in your modules/asset_register folder with those in my GitHub Repo.
The files in sql/update.sql in the module must match yours. It can be appropriately searched and replaced for 0_ to be the same as your company number and then executed on your database.

Re: Purchase of an asset and depreciation

null@example.com (kvvaradha) — Mon, 27 Oct 2014 04:06:14 +0000

no, dont create it yourself.

Re: Purchase of an asset and depreciation

null@example.com (Silverspoon) — Sun, 26 Oct 2014 13:36:10 +0000

I dont even see any 0_asset_types table created in my db. Shall i manually create one?

Re: Purchase of an asset and depreciation

null@example.com (kvvaradha) — Sun, 26 Oct 2014 11:37:14 +0000

the error occurs, when you change table prefix.

check the sql returns 0_asset_types , but your table is xxx0_asste_types , so there is a problem in table prefix. check it.

Re: Purchase of an asset and depreciation

null@example.com (Silverspoon) — Sun, 26 Oct 2014 09:36:22 +0000

Ive installed the asset package and my db user is granted with all privileges. Having this error
DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'xxx0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive

Re: Purchase of an asset and depreciation

null@example.com (apmuthu) — Sun, 26 Oct 2014 07:57:24 +0000

Make sure your db user has triggers and other privileges.

Re: Purchase of an asset and depreciation

null@example.com (joe) — Sun, 26 Oct 2014 05:33:27 +0000

I guess there is an extension that can handle that. Look under Setup tab, Install / Activate Extensions.

Joe

Purchase of an asset and depreciation

null@example.com (Silverspoon) — Sun, 26 Oct 2014 03:15:56 +0000

hi,
How to record a purchase of asset that will be depreciated through a number of years?
E.g. Office equipment

Pls assist.
Thx