Now it works fine ... thanks a lot for your support.

Thomas

When you install such a chart, before you input any data into the installation, manually (phpmyadmin) correct the fiscal_year table so that the appropriate date ranges are there for each fiscal and they must be in serial order and no id should be missing either.

Australian Fiscal Year

I have changed the insert statement in the chart to be:

INSERT INTO `0_fiscal_year` VALUES (1, '2016-07-01', '2017-06-30', 0);

The additional key for the tax_types table UNIQUE KEY `name` (`name`,`rate`) is essential to avoid duplicate entry of tax types that populate select drop down boxes. Hope the devs will add it upstream. All AUTO_INCREMENT=XXX have been removed. Some comments have been added from later upstream chart updates.

Committed

Download the updated chart here.

I have done a re-installation. The problems with the default data I originally had have disappeared.

However, I am still unable to book in a previous year. Active year is set to the previous one and it is not closed. Booking in the current year works now (a thing which did not work previously either).

Does it maybe have anything to do with the way I had to set up the financial years to accommodate the Australian fiscal year (July to June)? I had to do the following:

- Year 01/01/2016 to 31/12/2016 was already there
- Added short year 01/01/2017 to 30/06/2017
- Added normal year 01/07/2017 to 30/06/2018 and set as active year
- Closed and deleted year 01/01/2016 to 31/12/2016
- Closed and deleted year 01/01/2017 to 30/06/2017
- Added normal year 01/07/2016 to 30/06/2017

The last one is the one I want to create bookings in. I set that to active for that purpose.

Thanks for your help. There is a new comparison report on https://accounting.perscare.com.au/files/textfile_diff_result_20171122.html

jegenco_fracct is again my current installation and jegenco_sandbox the en_US-new.sql one.

Thanks

Then you can choose the Chart to use for creating your new company.

@itronics: please refresh the pkg repo with this new file from my repo linked herein.

I am happy to start from scratch again ... I did not do too much setup yet and I messed around quite a bit with the financial years.

When I re-install will it download the new version of the AU general chart of accounts  automatically or do I have to do something?

Thanks

@itronics: can re-create the pkg for it.

I did generate the dumps for comparison without data, so the file does not show any data only structure. I have uploaded the file here: https://accounting.perscare.com.au/files/textfile_diff_result.html

jegenco_fracct is my accounting (created with the AU general chart of account). jegenco_sandbox is the en_US-new.sql.

Thanks

You can upload anywhere (delete all insert statements especially for the users table) - just your schema and the differences with en_US-new.sql and paste the link here.

Finally I got around to do that difference, there are quite a few differences, particularly columns in en_US-new.sql which do not exist in my database.

I have a html file with the report of that comparison. Can I upload this somewhere here?

Thanks.

Alternatively, load both original schemas without their data into two separate databases and do a schema compare possibly in SQLyog / phpMyAdmin or any other online tool that compares schemas - some listed in this forum as well.

The easiest way forward is to use the sql/en_US-new.sql Chart and then alter what you want to suit AU requirements.

I am using the general AU Chart of Accounts.

I did a backup and tried to compare using text compare. However, there are plenty of differences, mainly in character set and collations.

What kind of differences are you looking for? What is the best way to compare?

I also cleared my cache before re-login, no change.

It feels like there is a bug somewhere. I don't know if it has something to do with the chart of accounts I am using. I initialised it with an Australian one. But I also realised that some of the configured accounts in system setup (Retained Earnings and Profit/Loss Year) were not exiting, so I had to create them.

Any Ideas?