Good evening,

About a week ago I upgraded from 2.3 to 2.4.4. The upgrade went without any problems.

However today I realised a problem with the automatic generation of references in bank deposits and payments. The reference generated already exists and causes an error message on saving.

If I manually increase the reference to the next free one, saving works. However the next generated reference is the same one as before which of course is still a duplicate.

Any ideas how to fix this?

Thanks.

Thomas

Hello

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

Thomas

Hi apmuthu,

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

Hello,

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

I had it directly created with this chart of accounts (The AU general).

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

Hello,

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.

Thanks apmuthu for your reply.

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?

As already mentioned in my original post the previous financial year is not closed and I set it as active in the company setup.

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?

Hello everybody,

I just installed FrontAccounting 2.4.3 and wanted to do some bookings in the previous financial year (As usual in Australia this would be from 01/07/2016 to 30/06/2017).

The previous year is not closed and I set it to the active year in my company setup.

However I still get the error message "The entered date is out of fiscal year or is closed for further data entry".

I also tried setting the permission flag to allow booking in non-closed financial years, no change.

I might have to add that I have to play around quite a bit until I got the Australian Financial years set up correctly and now have them set up until 30/06/2021.

Anything I miss here?

Thanks for your help.

Cheers,

Thomas