FrontAccounting forum — Can't switch fiscal year in Company setup - FA 2.0

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

2008-08-23T08:41:00Z

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

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

2008-08-23T07:05:59Z

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

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

2008-06-16T10:00:58Z

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

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

2008-06-15T20:39:38Z

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

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

2008-03-21T09:55:13Z

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.

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

2008-03-20T22:08:17Z

- 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