When switching on debug I get the following error:
Unhandled exception [1054]: Unknown column 'account_code2' in 'INSERT INTO'. in file: /companydirectory/includes/db/connect_db_mysqli.inc at line 68
However line 68 refers to a deadlock situation.
I added account_code2 to my COA.sql but no joy.
1 Yesterday 11:01:59 am
Re: Add credit card as bank account (5 replies, posted in Banking and General Ledger)
2 04/01/2025 07:59:35 am
Re: Add credit card as bank account (5 replies, posted in Banking and General Ledger)
My issue is when I go to Banking and General Ledger,
Create a new Liability Account... enter number, name, etc.
Click Add New button.
There is a very quick flash of the circling arrow at the top of the page, then nothing.
I would expect a message saying New Account Added but nothing happens other than that little flash.
When I check Chart of Accounts there is is no change.
3 03/28/2025 03:29:20 pm
Topic: Add credit card as bank account (5 replies, posted in Banking and General Ledger)
Hello,
Is there a step by step process to add a credit card as bank account and liability account.
I understand the theory of paying a supplier with a credit card and then transferring funds to pay the credit card as described in the wiki and forum posts but when I try to add a new account in FA I just get a flicker on the screen and then nothing changes.
I enter a new unused account number so previous transactions are not an issue.
Do I have to make these changes in my COA.sql file or is there a way to do it from the FA interface?
I am using FA 2.4.18.
4 03/05/2025 01:54:23 pm
Re: Direct Invoice not processing (2 replies, posted in Setup)
@apmuthu Thanks for the response.
The issue was when I copied the new FA files to overwrite my older version they were not in fact overwritten.
The older version files were still being accessed which of course brought about the errors.
So I copied the new files again using rsync,restored my backed up database, and then followed the instructions in the system diagnosis tab.
Logged out and back in.
Everything works again.
Once again, Thanks for all the work you guys put into this project.
5 03/04/2025 01:22:33 pm
Topic: Direct Invoice not processing (2 replies, posted in Setup)
Recently upgraded my OS which included PHP 8.2.26 and now when I try to place invoice I get an error
"strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in file: /var/www/html/companyname/includes/ui/ui_lists.inc at line 305".
After searching I upgraded FA from 2.4.10 to 2.4.18 which seems to have been succesfull. It shows the correct version number when I log in but my problem with invoicing remains. Nothing happens until I click a second time on the place invoice button, then where I used to get a menu to view or print invoice I get sales order menu with same options but view order is blank.
When running debug mode using parameter "2", I get 5 errors as soon as I click Direct Invoice --- all beginning with the same line 305 error as above.
I have only ever used Direct Invoice method.
Any help is appreciated.