From bank reconciliations and accounts payable to BAS preparation, payroll, and Xero support, their team helps keep your finances accurate and organised.

Get transparent pricing and responsive support tailored to your business needs. Contact AffordBooksTax at (03) 7071 1180, 0416 339 239, or 0402 124 067.

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', '2026-08-15 19:28:04', 'Voided.\nedit', '8', '2026-08-15', '0'),        (New Addition)
('34132', '30', '6472', '1', '2026-08-15 19:30:10', 'Updated.', '8', '2026-04-26', '0'),            (New Addition)
('34133', '13', '6772', '1', '2026-08-15 19:31:27', NULL, '8', '2026-04-26', '0'),                    (New Addition)
('34134', '10', '6771', '1', '2026-08-15 19:32:22', NULL, '8', '2026-04-26', '0'),                    (New Addition)
('34135', '12', '6769', '1', '2026-08-15 19:32:22', NULL, '8', '2026-04-26', '0');                    (New Addition)

0_bank_trans
('12920', '12', '6473', '4', 'CP260325', '2026-04-26', '165', '0', '0', '2', '217', NULL),        (Original)
**************************************************************************************
('13543', '12', '6769', '4', 'CP260621', '2026-04-26', '165', '0', '0', '2', '217', NULL);        (New Addition)

0_comments
('13', '6473', '2026-04-26', '260426 PayPal $4.93'),                    (Original)
('10', '6473', '2026-04-26', '260426 PayPal $4.93'),                    (Original)
('12', '6473', '2026-04-26', 'POS_VBC #6473'),                            (Original)
**************************************************************************************
('13', '6772', '2026-04-26', '260426 PayPal $4.93'),                    (New Addition)
('10', '6771', '2026-04-26', '260426 PayPal $4.93'),                    (New Addition)
('12', '6769', '2026-04-26', 'POS_VBC #6771');                            (New Addition)

0_cust_allocations
('6485', '217', '165', '2026-04-26', '6473', '12', '6473', '10'),        (Deleted)
**************************************************************************************
('6781', '217', '165', '2026-04-26', '6769', '12', '6771', '10');        (New Addition)

0_debtor_trans
('6473', '10', '0', '217', '214', '2026-04-26', '2026-04-26', 'Dn260325', '3', '6472', '165', '0', '0', '0', '0', '165', '0', '1', '1', '7', '0', '4', '0'), (Original)
***************************************************************************************
('6473', '10', '2', '217', '214', '2026-04-26', '2026-04-26', 'Dn260325', '3', '6472', '0', '0', '0', '0', '0', '0', '0', '1', '1', '7', '0', '4', '0'),     (Changed)
***************************************************************************************
('6771', '10', '0', '217', '214', '2026-04-26', '2026-04-26', 'Dn260623', '3', '6472', '165', '0', '0', '0', '0', '165', '0', '1', '1', '7', '0', '4', '0'), (New Addition)
***************************************************************************************
('6769', '12', '0', '217', '214', '2026-04-26', '0000-00-00', 'CP260621', '0', '0', '165', '0', '0', '0', '0', '165', '0', '1', '0', '0', '0', NULL, '0'),     (New Addition)
***************************************************************************************
('6772', '13', '1', '217', '214', '2026-04-26', '2026-04-26', 'DN260001', '3', '6472', '165', '0', '0', '0', '0', '0', '0', '1', '1', '7', '0', '4', '0');     (New Addition)

0_debtor_trans_details
('16227', '6473', '13', '101', 'Donation - Tithe', '165', '0', '1', '0', '0', '1', '8112'),        (Original)
('16228', '6473', '10', '101', 'Donation - Tithe', '165', '0', '1', '0', '0', '0', '16227'),
***************************************************************************************
('16227', '6473', '13', '101', 'Donation - Tithe', '0', '0', '0', '0', '0', '1', '0'),            (Changed)
('16228', '6473', '10', '101', 'Donation - Tithe', '0', '0', '0', '0', '0', '0', '0'),
***************************************************************************************
('17075', '6772', '13', '101', 'Donation - Tithe', '140', '0', '1', '0', '0', '1', '8112'),        (New Addition)
('17076', '6772', '13', '104', 'Donation - Building', '25', '0', '1', '0', '0', '1', '8536'),
('17077', '6771', '10', '101', 'Donation - Tithe', '140', '0', '1', '0', '0', '0', '17075'),
('17078', '6771', '10', '104', 'Donation - Building', '25', '0', '1', '0', '0', '0', '17076');

0_gl_trans
('40813', '10', '6473', '2026-04-26', '4011', '', '-165', '7', '1', NULL, NULL),        (Original)
('40814', '10', '6473', '2026-04-26', '1200', '', '165', '7', '0', '2', '217'),
***************************************************************************************
('40813', '10', '6473', '2026-04-26', '4011', '', '0', '7', '1', NULL, NULL),            (Changed)
('40814', '10', '6473', '2026-04-26', '1200', '', '0', '7', '0', '2', '217'),
***************************************************************************************
('42822', '10', '6771', '2026-04-26', '4011', '', '-140', '7', '1', NULL, NULL),        (New Addition)
('42823', '10', '6771', '2026-04-26', '4011', '', '-25', '7', '4', NULL, NULL),
('42824', '10', '6771', '2026-04-26', '1200', '', '165', '7', '0', '2', '217'),
('42825', '12', '6769', '2026-04-26', '1003', '', '165', '7', '0', NULL, NULL),
('42826', '12', '6769', '2026-04-26', '1200', '', '-165', '7', '0', '2', '217');

0_refs
('6771', '10', 'Dn260623'),
**************************************************************************************
('6768', '12', 'CP260620'),            (Original)
('6769', '12', 'CP260621'),            (New Addition)
('6772', '13', 'DN260001'),            (New Addition)
('1', '20', 'SI19001'),                (Original)
**************************************************************************************
('6402', '30', 'SO260002'),            (Original)
('6472', '30', 'SO260003'),            (New Addition)
('6530', '30', 'SO260003'),            (Original)
('18', '40', '101'),                (Original)

0_sales_order_details
('8112', '6472', '30', '101', 'Donation - Tithe', '1', '165', '1', '0', '0'),    (Original)
**************************************************************************************
('8112', '6472', '30', '101', 'Donation - Tithe', '1', '140', '1', '0', '0'),    (Changed)
**************************************************************************************
('8536', '6472', '30', '104', 'Donation - Building', '1', '25', '1', '0', '0');        (New Addition)

0_sales_orders
('6472', '30', '1', '0', '217', '214', 'auto', '', '260426 PayPal $4.93', '2026-04-26', '3', '1', '1313 Garbage Can Lane\r\nBoredom, XZ 12345', '', NULL, 'John Doe', '0', 'DEF', '2026-04-26', '4', '165', '0', '0'),    (Original)
***************************************************************************************
('6472', '30', '3', '0', '217', '214', 'SO260003', '', '260426 PayPal $4.93', '2026-04-26', '3', '1', '3520 Leith Street\r\nBoredom, XZ 12345', '', NULL, 'John Doe', '0', 'DEF', '2026-04-26', '4', '165', '0', '0'),    (Changed)

0_stock_moves
('8112', '6473', '101', '13', 'DEF', '2026-04-26', '165', 'auto', '-1', '0'),        (Deleted)
***************************************************************************************
('8536', '6772', '101', '13', 'DEF', '2026-04-26', '140', 'DN260001', '-1', '0'),    (New Addition)
('8537', '6772', '104', '13', 'DEF', '2026-04-26', '25', 'DN260001', '-1', '0');    (New Addition)

0_trans_tax_details
('12950', '13', '6473', '2026-04-26', '0', '0', '1', '0', '165', '0', 'auto', NULL),        (Original)
('12951', '10', '6473', '2026-04-26', '0', '0', '1', '0', '165', '0', 'Dn260325', '0'),        (Original)
***************************************************************************************
('12950', '13', '6473', '2026-04-26', '0', '0', '1', '0', '0', '0', 'auto', NULL),            (Changed)
('12951', '10', '6473', '2026-04-26', '0', '0', '1', '0', '0', '0', 'Dn260325', '0'),        (Changed)
***************************************************************************************
('13542', '13', '6772', '2026-04-26', '0', '0', '1', '0', '165', '0', 'DN260001', NULL),    (New Addition)
('13543', '10', '6771', '2026-04-26', '0', '0', '1', '0', '165', '0', 'Dn260623', '0');        (New Addition)

0_voided
('10', '6473', '2026-08-15', 'edit'),    (New Addition)
**************************************************************************************
('13', '6473', '2026-04-26', ''),        (New Addition)

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?

Note: I use the Direct Goods Receipt Entry (D) method, not the Purchase Order Entry (B) method.

Any assistance would be appreciated.

Any thoughts?

I need help with the above issue. The VAT was mistakenly enabled which is not supposed to be. Just discovered it and we are trying to revert it cos the invoices already issued with the VAT are very very many about 7month duration. Some of the invoices have GRN on them.
Please how do I revert these VAT to Sales without having to modify them individually cos this will take several months to do. Invoice number is over One thousand.

Please help.

Thanks.

Popsicles12

Is that module is not update or something other reason.?

I am also downgrading the PHP version same issue.

I wanted to start a discussion around Xyli, a keyword that is gaining attention in different online communities and digital platforms. As industries continue to evolve rapidly, new terms like Xyli often represent tools, services, or concepts that improve user experience, efficiency, or accessibility in various fields.

Many users are curious about how Xyli (ไซไล) can be applied in real-world scenarios, especially in areas like online networking, digital services, and modern web-based platforms. With the rise of advanced technologies, such keywords often become part of larger ecosystems that focus on user convenience and better interaction.

One interesting aspect of Xyli is how it can potentially be integrated into platforms that focus on user discovery, communication, or service-based environments. Whether it is used for branding, system functionality, or digital identity, the adaptability of Xyli makes it a topic worth exploring.
Read more: fiwfan.app

I was installing the new 2.4.20 version and it could't finish installation

I'm using

MariaDB 10.4.32
PHP Version 8.1.25

The problem I notice is when the system tries to execute the script

CREATE TABLE `0_bank_accounts` (
  `account_code` varchar(15) NOT NULL DEFAULT '',
  `account_type` smallint(6) NOT NULL DEFAULT '0',
  `bank_account_name` varchar(60) NOT NULL DEFAULT '',
  `bank_account_number` varchar(100) NOT NULL DEFAULT '',
  `bank_name` varchar(60) NOT NULL DEFAULT '',
  `bank_address` tinytext,
  `bank_curr_code` char(3) NOT NULL DEFAULT '',
  `dflt_curr_act` tinyint(1) NOT NULL DEFAULT '0',
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `bank_charge_act` varchar(15) NOT NULL DEFAULT '',
  `last_reconciled_date` timestamp NOT NULL DEFAULT '1900-01-01 00:00:00',
  `ending_reconcile_balance` double NOT NULL DEFAULT '0',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `bank_account_name` (`bank_account_name`),
  KEY `bank_account_number` (`bank_account_number`),
  KEY `account_code` (`account_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 ;

the failure is because in the newer MariaDB does not allow this line   
`last_reconciled_date` timestamp NOT NULL DEFAULT '1900-01-01 00:00:00',

so in order to make it work change it to 
`last_reconciled_date` DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00',

After I did it it works, hope I can help someone.

Two innocent pieces interacting:

1. `0_audit_trail.stamp` is defined as `TIMESTAMP ... ON UPDATE CURRENT_TIMESTAMP` (FA default, used to track edit time).
2.  close_transactions() in `includes/db/audit_trail_db.inc` runs `UPDATE 0_audit_trail SET gl_seq=$seq WHERE id=...

The UPDATE only sets `gl_seq`, but MySQL auto-refreshes `stamp` as a side effect of the `ON UPDATE` clause. The `if ($row['gl_seq'] != $seq)` guard is why only some rows get hit — exactly the ones being re-sequenced.

I tried fixing it with the following change

$sql2 = "UPDATE ".TB_PREF."audit_trail SET"
    . " gl_seq=$seq"
    . " WHERE id=".$row['id'];

to:

$sql2 = "UPDATE ".TB_PREF."audit_trail SET"
    . " gl_seq=$seq,"
    . " stamp=stamp" // preserve original timestamp
    . " WHERE id=".$row['id'];

Explicitly listing `stamp` in the SET clause suppresses the `ON UPDATE CURRENT_TIMESTAMP` auto-refresh in MySQL. No schema change needed, and normal `add_audit_trail()` edits are unaffected since they already set `stamp` explicitly.

Has anyone else hit this? Kindly share your experience.

Thanks

This is a 2.4.20 stable release with improved PHP 8 compatibility and a couple of usability and security bugfixes.
Therefore please consider urgent upgrade of your installation to this version, to keep your FA instances safe.
This is especially important in not fully trusted environments like publicly accessible installations (demos or other installations accessibly by not fully trusted users).

This release fixes some problems on php versions 8.2 to 8.4. The following versions has been tested: 8.0.0, 8.0.7, 8.0.12, 8.1.6, 8.2.0, 8.3.2, 8.4.13 and 8.5.5.

Please report any bugs/problems found via our Mantis Bugtracker at http://mantis.frontaccounting.com.
Download instructions

In Sourceforge FrontAccounting (http://sourceforge.net/projects/frontaccounting), select
Files -] FrontAccounting 2.4 -]2.4.20.

For Windows users select the zip file. For all other users select the tar.gz file.
Security

FrontAccounting should NOT be used via unsecure http protocol. If you really need this - change SECURE_ONLY constant in /includes/session.inc to false (comment in the file added). Unfortunately this option cannot be added in sysprefs/config.php because the settings are not available before session is started.
Common

● Multiply cleanups/security fixes in attachments editor.
● Database procedures in reports fixed to be compliant with codebase rules.
● Bug [0005737] Attachment editors: fixed input field width to underlying db field size.
● Attachments should be deleted when related document/entity is deleted. Fixes [0005757].
● Bug [0005750] Fixed hangs in barcode generation.
● Feature [0005712] Added fast date input edition with keyboard shortcuts (CtrlAlt-Arrows).
● Install/Activate Extensions: fixed deprecation warning on php ]=8.2.

Sales

● Feature [0005738] Customer/Supplier Allocation Inquiry: changed default sort order to ascending by Due Date.
● Feature [0005752] Customer Statements Report: added customer reference column.
● Feature [0005751] Customer Payments, Supplier Payments: added contractor reference for easier allocations.

Purchases

● $trans_no was missing in purch_order definition class. Fixed.
● Feature [0005738] Customer/Supplier Allocation Inquiry: changed default sort order to ascending by Due Date.
● Feature [0005751] Customer Payments, Supplier Payments: added contractor reference for easier allocations.

Bank and General Ledger

● Added two XRPL Payment Links. By Leslie Proud.
● Changed Bank Account Reconcile to sort descending.
● New exchange-rates organisation update. Can also fetch historical rated.
● Fixed safety issues in bank and audit reports.

I have progressed to the point where no errors are reported and the FA interface feeds back a line highlighted in green of the data that was processed.  However, when I check to see if a new SO record was created I don't find one.

I would expect that the feed back resulting from a successful upload would be more than the green highlighted information.

Also, the menu option to IMPORT TRANSACTIONS is perpetually greyed out, forcing me to go through the steps to save the access rights for the Administrator (me) each time I want to try to import.  Not sure if this is somehow related but even if it isn't it's very frustrating!

You guys are doing a great Job here. Thank you all.

I discovered that the Stock check sheet reports and the Inventory Item movement report end total are different. What can be the cause of it? Both figure are supposed to be same. KIndly help out.

Secondly, I want the name of the person who raised an Invoice to appear on each Invoice. How can I achieve that?

Thanks

Popsicles12