• alex
  • New member
  • Offline
  • Registered: 01/24/2008
  • Posts: 4

Topic: Can't switch fiscal year in Company setup - FA 2.0

- I added a new fiscal year: Setup >> Company setup >> Fiscal Years: 01/01/2008 - 12/31/2008
- I wanted to setup this year as the current one: Setup >> Company setup >> Company setup >> Fiscal Year >> 01/01/2008-12/31/2008 (Active
- Then I receive the following error:

DATABASE ERROR : The company setup could not be updated
error code : 1054
error message : Unknown column 'no_item_list' in 'field list'
sql that failed was : UPDATE 0_company SET coy_name='Training Inc.', coy_no = '123123123', gst_no='987654321', tax_prd=1, tax_last=1, postal_address ='N/A', phone='202-122320', fax='202-18889123', email='delta@delta.com', coy_logo='logo_frontaccounting.jpg', domicile='DownTown', use_dimension=1, no_item_list=0, no_customer_list=0, no_supplier_list=0, custom1_name='', custom2_name='', custom3_name='', custom1_value='', custom2_value='', custom3_value='', curr_default='USD', f_year=6 WHERE coy_code=1

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Can't switch fiscal year in Company setup - FA 2.0

In FA 1.16 release the sql files where not updated after latest db structure changes, I'm afraid.

You can fix this via phpmyadmin by executing those 3 commands:

ALTER TABLE `0_company` ADD `no_item_list` TINYINT(1) NOT NULL DEFAULT '0' AFTER `f_year`;
ALTER TABLE `0_company` ADD `no_customer_list` TINYINT(1) NOT NULL DEFAULT '0' AFTER `no_item_list`;
ALTER TABLE `0_company` ADD `no_supplier_list` TINYINT(1) NOT NULL DEFAULT '0' AFTER `no_customer_list`;


Shame on us.  Stable CVS updated.
Thanks for pointing out.

  • Registered: 02/29/2008
  • Posts: 16

Re: Can't switch fiscal year in Company setup - FA 2.0

Sir,

I run the above three commands but when I again tried to run alter.sql the following errors shown

#1054 - Unknown column 'tax_included' in '0_sales_types'

regards
sushil dikshit

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

Re: Can't switch fiscal year in Company setup - FA 2.0

Hello sushil,
There seems to have been some interruptions when updating your companies.
There are two alter sql files, alter.sql and alter2.sql. The problems with the update_db.php is, when running it again it will bail out on a company where something has been altered before.
Therefore the latest changes are at the top.
Try to do all the sql statements one by one from the alter sql files on your client. Start at the bottom and go upwards. In case it bails out, this statement has already been executed before. No harm is done.

Hopefully you are up and running soon.

/Joe

5 Reply by cheeks (edited by cheeks 08/23/2008 07:06:30 am)

  • From: South Africa, Natal
  • Registered: 07/19/2008
  • Posts: 46

Re: Can't switch fiscal year in Company setup - FA 2.0

Hi Joe

Thanks for the NEW FA2 Ver 21.08.2008 (Using Linux Setup)

I cannot seem to change my Fiscal Year (Used New Company Script) or add my Fiscal Year being: 01/03/2008 to 28/02/2009

It says - " Invalid BEGIN date in fiscal year "

Please Help

  • Registered: 12/25/2007
  • Posts: 2,446

Re: Can't switch fiscal year in Company setup - FA 2.0

You have this error when you enter incorrect date, or when new fiscal year overlaps any previously defined year.