• From: Indonesia
  • Registered: 12/27/2011
  • Posts: 18

Topic: Disable (gray color) / inactive some feature

Hello,

I use Xampp-win32-1.7.4-VC6, when I successful installed frontaccounting any item / features in FA disable (show gray color) as follow:

a. Tax groups
b. Contact Categories
c.  Revenue / cost accrual
d. Amortization posting
e. asset type entries
f. asset entries

how I can activated these items.?

Many thanks

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

Re: Disable (gray color) / inactive some feature

Go as admin into Setup tab, Access Level Setup and select the role you want and mark the various items.

/Joe

  • From: Indonesia
  • Registered: 12/27/2011
  • Posts: 18

Re: Disable (gray color) / inactive some feature

Thanks Joe,

When I click Asset Types Entries show error message as follow "DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'ptsk.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive"

and also when I click Assets Entries show error message as follow "DATABASE ERROR : could not get all assets
error code : 1146
error message : Table 'ptsk.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"

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

Re: Disable (gray color) / inactive some feature

I am not familiar with the module Asset Type Entries.
But it seems that you must run an SQL script first. Look inside the /module and look for the asset type module. There may be an SQL script here.
With phpMyAdmin, try to import this script. Then I guess and hope you should be up and running.

/Joe

  • From: Indonesia
  • Registered: 12/27/2011
  • Posts: 18

Re: Disable (gray color) / inactive some feature

Hi Jo,

Which field I should use for change sql script bellow for assets type


function get_all_asset_types($all=false)
{
    $sql =