FrontAccounting forum — Purchase of an asset and depreciation

Re: Purchase of an asset and depreciation

2014-12-13T15:27:36Z

same problem here

Re: Purchase of an asset and depreciation

2014-12-06T14:51:24Z

Re: Purchase of an asset and depreciation

2014-11-29T14:26:39Z

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

2014-10-28T08:24:12Z

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

Re: Purchase of an asset and depreciation

2014-10-27T19:19:18Z

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

2014-10-27T04:06:14Z

no, dont create it yourself.

Re: Purchase of an asset and depreciation

2014-10-26T13:36:10Z

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

2014-10-26T11:37:14Z

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

2014-10-26T09:36:22Z

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

2014-10-26T07:57:24Z

Make sure your db user has triggers and other privileges.

Re: Purchase of an asset and depreciation

2014-10-26T05:33:27Z

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

Joe

Purchase of an asset and depreciation

2014-10-26T03:15:56Z

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

Pls assist.
Thx