FrontAccounting forum

I tried to to change an existing Invoice using the procedure posted in the Wiki and the results created parts of the new Invoice with redundant invoice numbers instead of creating unique new numbers. I could not find out why. This is the first time I've tried to change an invoice with this level of software (2.4.19 Default Theme, Church Chart of Accounts). I'm listing all the changes in the DB when I changed one invoice. If any one can help me or even verify that I should see different results and why, then I'll know I did something wrong. Edit Invoice using posted Wiki Results posted below. 0_audit_trail ('32595', '30', '6472', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32596', '13', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32597', '10', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ********************************************************************************************* ('32595', '30', '6472', '1', '2026-08-15 19:30:10', NULL, '8', '2026-04-26', NULL), (Changed) ('32596', '13', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ('32597', '10', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ********************************************************************************************* ('34130', '13', '6473', '1', '2026-08-15 19:28:04', 'Voided.', '8', '2026-04-26', '0'), (New Addition) ('34131', '10', '6473', '1', '20

I tried to to change an existing Invoice using the procedure posted in the Wiki and the results created parts of the new Invoice with redundant invoice numbers instead of creating unique new numbers. I could not find out why. This is the first time I've tried to change an invoice with this level of software (2.4.19 Default Theme, Church Chart of Accounts). I'm listing all the changes in the DB when I changed one invoice. If any one can help me or even verify that I should see different results and why, then I'll know I did something wrong. Edit Invoice using posted Wiki Results posted below. 0_audit_trail ('32595', '30', '6472', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32596', '13', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32597', '10', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ********************************************************************************************* ('32595', '30', '6472', '1', '2026-08-15 19:30:10', NULL, '8', '2026-04-26', NULL), (Changed) ('32596', '13', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ('32597', '10', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ********************************************************************************************* ('34130', '13', '6473', '1', '2026-08-15 19:28:04', 'Voided.', '8', '2026-04-26', '0'), (New Addition) ('34131', '10', '6473', '1', '20

I tried to to change an existing Invoice using the procedure posted in the Wiki and the results created parts of the new Invoice with redundant invoice numbers instead of creating unique new numbers. I could not find out why. This is the first time I've tried to change an invoice with this level of software (2.4.19 Default Theme, Church Chart of Accounts). I'm listing all the changes in the DB when I changed one invoice. If any one can help me or even verify that I should see different results and why, then I'll know I did something wrong. Edit Invoice using posted Wiki Results posted below. 0_audit_trail ('32595', '30', '6472', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32596', '13', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ('32597', '10', '6473', '1', '2026-05-06 07:17:23', NULL, '8', '2026-04-26', '0'), (Original) ********************************************************************************************* ('32595', '30', '6472', '1', '2026-08-15 19:30:10', NULL, '8', '2026-04-26', NULL), (Changed) ('32596', '13', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ('32597', '10', '6473', '1', '2026-08-15 19:28:04', NULL, '8', '2026-04-26', NULL), (Changed) ********************************************************************************************* ('34130', '13', '6473', '1', '2026-08-15 19:28:04', 'Voided.', '8', '2026-04-26', '0'), (New Addition) ('34131', '10', '6473', '1', '20

I am currently running FA 2.3.19 on Debian 7 (Wheezy) with PHP 5.4. I need to move FA to a new server running Debian 13 (Trixie) and PHP 8.4. From what I have found, the start of the upgrade path should be: FA 2.3.19 -> FA 2.3.26 (old server) FA 2.3.26 -> 2.4.1 (old server, includes database conversions) But what then? I assume at some point FA 2.4.X does not run on PHP 5.4 anymore and the next version 2.4.Y does not run on PHP 8.4 yet. I have not been able to find the PHP requirements for each FA version. I think I need to find 2 versions of FA which - use the same database format - the older version runs on PHP 5.4 - the newer version runs on PHP 8.4 So I would export the database on the older version, followed by an import on the newer version. Does that even exist? Or is there a better way?

I am currently running FA 2.3.19 on Debian 7 (Wheezy) with PHP 5.4. I need to move FA to a new server running Debian 13 (Trixie) and PHP 8.4. From what I have found, the start of the upgrade path should be: FA 2.3.19 -> FA 2.3.26 (old server) FA 2.3.26 -> 2.4.1 (old server, includes database conversions) But what then? I assume at some point FA 2.4.X does not run on PHP 5.4 anymore and the next version 2.4.Y does not run on PHP 8.4 yet. I have not been able to find the PHP requirements for each FA version. I think I need to find 2 versions of FA which - use the same database format - the older version runs on PHP 5.4 - the newer version runs on PHP 8.4 So I would export the database on the older version, followed by an import on the newer version. Does that even exist? Or is there a better way?

I am currently running FA 2.3.19 on Debian 7 (Wheezy) with PHP 5.4. I need to move FA to a new server running Debian 13 (Trixie) and PHP 8.4. From what I have found, the start of the upgrade path should be: FA 2.3.19 -> FA 2.3.26 (old server) FA 2.3.26 -> 2.4.1 (old server, includes database conversions) But what then? I assume at some point FA 2.4.X does not run on PHP 5.4 anymore and the next version 2.4.Y does not run on PHP 8.4 yet. I have not been able to find the PHP requirements for each FA version. I think I need to find 2 versions of FA which - use the same database format - the older version runs on PHP 5.4 - the newer version runs on PHP 8.4 So I would export the database on the older version, followed by an import on the newer version. Does that even exist? Or is there a better way?

I have a scenario involving a purchase return transaction; what are the steps for entering this transaction in FrontAccounting? Note: I use the Direct Goods Receipt Entry (D) method, not the Purchase Order Entry (B) method. Any assistance would be appreciated.

I have a scenario involving a purchase return transaction; what are the steps for entering this transaction in FrontAccounting? Note: I use the Direct Goods Receipt Entry (D) method, not the Purchase Order Entry (B) method. Any assistance would be appreciated.

I have a scenario involving a purchase return transaction; what are the steps for entering this transaction in FrontAccounting? Note: I use the Direct Goods Receipt Entry (D) method, not the Purchase Order Entry (B) method. Any assistance would be appreciated.

Hellosss, I just installed FA on a VPS which also runs a few other websites and databases. I notice that config_db.php - which has access info to MySQL - is located on the root folder of FA. Just to improve the security of this file, I'd like to move to a safer folder on the server - and update FA script(s) which requires config_db.php. Any thoughts?

Hellosss, I just installed FA on a VPS which also runs a few other websites and databases. I notice that config_db.php - which has access info to MySQL - is located on the root folder of FA. Just to improve the security of this file, I'd like to move to a safer folder on the server - and update FA script(s) which requires config_db.php. Any thoughts?

My normal invoice includes tax added and all has been well until I had to add a customer who is tax-exempt. Now when I try to place the invoice I get a full page of errors regarding duplicate entries of all values. Do I need to edit report 107 to leave tax out of the invoice? Then do I change it back again to process a regular invoice?