• Registered: 10/26/2014
  • Posts: 6

Topic: Purchase of an asset and depreciation

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

Pls assist.
Thx

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Purchase of an asset and depreciation

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

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Purchase of an asset and depreciation

Make sure your db user has triggers and other privileges.

apmuthu's Website

  • Registered: 10/26/2014
  • Posts: 6

Re: Purchase of an asset and depreciation

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

sad

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Purchase of an asset and depreciation

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.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • Registered: 10/26/2014
  • Posts: 6

Re: Purchase of an asset and depreciation

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

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Purchase of an asset and depreciation

no, dont create it yourself.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Purchase of an asset and depreciation

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.

apmuthu's Website

  • Registered: 10/26/2014
  • Posts: 6

Re: Purchase of an asset and depreciation

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

  • Registered: 10/26/2014
  • Posts: 6

Re: Purchase of an asset and depreciation

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

  • Registered: 10/26/2014
  • Posts: 6

Re: Purchase of an asset and depreciation

up

  • Registered: 12/13/2014
  • Posts: 1

Re: Purchase of an asset and depreciation

same problem here