If I create a new fiscal year (which we're now in), the problem goes away.
Thanks very much for your help and continuing to maintain such a brilliant piece of software.
1 08/13/2021 02:07:56 pm
Re: Unable to void a Sales Invoice (10 replies, posted in Report Bugs here)
2 08/13/2021 02:01:06 pm
Re: Unable to void a Sales Invoice (10 replies, posted in Report Bugs here)
Looks like I've got a fiscal year problem.
[13-Aug-2021 15:06:47 Europe/Berlin] <b>DATABASE ERROR :</b> Cannot update audit gl_seq<br>error code : 1048<br>error message : Column 'fiscal_year' cannot be null<br>sql that failed was : UPDATE 2_audit_trail audit LEFT JOIN 2_fiscal_year year ON year.begin<='2021-08-13' AND year.end>='2021-08-13'
The invoices to be voided are in the last fiscal year that ended 2021-06-30. I have not yet created a new fiscal year.
3 08/13/2021 01:06:55 pm
Re: Unable to void a Sales Invoice (10 replies, posted in Report Bugs here)
kvvaradha wrote:
Looks like the timeout happens. We don't know howmuch records you have and server space given to work.
Probably Php time and our js time out also trouble you. Checkout the other forum which fixed the timeout issue.
https://frontaccounting.com/punbb/viewtopic.php?pid=39832#p39832
Thanks for the reply. It's definitely not hitting a 10s timeout. The spinning icon appears for less than a second.
4 08/13/2021 08:29:00 am
Topic: Unable to void a Sales Invoice (10 replies, posted in Report Bugs here)
I'm not sure if this is a bug or not. I've been a very happy use for some years now. Currently using version 2.4.8. Browser is Chromium under Ubuntu and have seen the same behaviour on Firefox on the same machine.
When I go to void a Sales Invoice, I can select the invoice, enter a memo and click Void all as normal. The 'Are you sure ...' page comes up as normal but clicking the Proceed button doesn't work. I briefly see the progress icon spinning but it never leaves the page and never voids the invoice.
Any tips would be greatly appreciated!
5 05/24/2015 09:05:13 am
Re: "Before GRN clearing Account" message (4 replies, posted in Setup)
I'm trying to change my invoice legal text but am hitting this issue due to a small number of un-invoiced POs that appeared for reasons I don't fully understand (almost certainly me doing something wrong) at the end of last fiscal year - which is now closed.
The POs in question are repeats of valid (auto generated during direct invoice) invoiced POs. They don't have any GL transactions associated with them and they only occurred for the first few transactions I entered so clearly, I've stopped doing the thing that I was doing wrong! Whatever that was.
I don't want to "invoice" them in case that generates more GL entries.
I tried setting sys_prefs: grn_clearing_act='' and was then able to Update "System and General GL Setup" but only once.
Afterwards, grn_clearing_act is set to '0' again.
Is this expected?
I can change it back to '' on each occasion I need to update System and General GL Setup but this does seem a bit of a hack.
6 07/20/2013 06:17:14 pm
Re: Database connection issue (4 replies, posted in Installation)
Having rummaged around in the code, I found that the problem stemmed from the php function mysql_connect.
The solution was here: http://stackoverflow.com/questions/6366192/specifying-protocol-in-mysql-connect-php
If you specify your server and port as localhost:12345 the php will use a socket.
The fudgearound is to specify it as 127.0.0.1:12345 then php will use TCP/IP.
Excellent. FA's now up and running on my new server!
7 07/20/2013 05:33:50 pm
Topic: Database connection issue (4 replies, posted in Installation)
I'm a new user so firstly I'd like to say what an excellent piece of software FrontAccounting is - Thanks to all contributors!
I've just moved to a new server and am struggling to get a connection to the mysql database. I've checked that the user and password are correct.
I can access the database from the command line but have to specify port and protocol so I use:
mysql -P 12345 -u user_name -p --protocol=tcp (where 12345 is the port number)
Is there any place I can specify the port number and protocol in the FA setup?