FrontAccounting forum

Looking for a Reliable Bookkeeper in Melbourne?

2026-09-23T08:15:21Z

Has anyone else been looking for a reliable bookkeeper in Melbourne for their small business? I came across AffordBooksTax, which offers bookkeeping and accounting support including bank reconciliation, BAS preparation, payroll, financial reporting and Xero services.

They seem to focus on practical support and transparent pricing, which can be helpful for small businesses trying to stay organised with their accounts and tax obligations.

If anyone is interested, you can contact AffordBooksTax on (03) 7071 1180, 0416 339 239, or 0402 124 067.

Looking for a Reliable Bookkeeper in Melbourne?

2026-09-23T08:10:56Z

They seem to focus on practical support and transparent pricing, which can be helpful for small businesses trying to stay organised with their accounts and tax obligations.

If anyone is interested, you can contact AffordBooksTax on (03) 7071 1180, 0416 339 239, or 0402 124 067.

Problem with Transaction References not looking at prefix...

2026-09-13T15:08:36Z

it appears that the Transaction References do not look at the prefix when determining uniqueness.

I have 2 Supplier Transaction References set up. 1 with no prefix (generic payments) and 1 with a prefix (checking account and check number as a reference)

When entering a Supplier Payment, only the reference number is check for uniqueness, preventing references with the same number but different prefixes from being accepted.

It seems that the Supplier Payment form will return the Reference List (ref_list) index but not the prefix value.

Is there an easy way to allow duplicate reference numbers with different prefixes?
Thanks

Edit Invoice using posted Wiki

2026-08-16T00:30:37Z

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', '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)

Upgrade path for huge leap 2.3.19 -> 2.4.20

2026-08-13T14:20:54Z

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?

Purchase Return Transaction

2026-08-09T10:42:49Z

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.

Can I move config_db file to a safer folder?

2026-07-17T21:29:54Z

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?

tax-exempt breaks invoice

2026-07-17T14:44:48Z

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?

Edit posted invoice

2026-07-17T10:34:47Z

I have submitted an invoice to a customer as taxed but later found out they are tax-exempt.
Can I edit this invoice and change the sales type to non-taxed or do I need to delete the whole sequence and submit new?
Thanks.

Convert wrongly deducted VAT back to Sales

2026-07-13T17:41:43Z

Hello All,

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

Why Batch Import Sale Module is Not working

2026-06-24T13:13:15Z

Hello, I am currently trying to shift from another software. Problem is I am using import of sales invoices but when I upload a CVS file, in the top the green loading line is showing and afterwards there is nothing.
No response.

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

I am also downgrading the PHP version same issue.

Exploring the Benefits and Uses of Xyli in Modern Digital Platforms

2026-05-20T11:50:10Z

Hello everyone,

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

Installing clean 2.4.20 version gets stuck

2026-05-12T18:30:49Z

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.

close_transactions() silently overwrites audit_trail.stamp

2026-05-12T15:22:50Z

After closing an old fiscal year, I noticed `0_audit_trail.stamp` had been rewritten to "now" for every row whose `gl_seq` was updated by the close routine. Rows the close didn't touch kept their original stamps. This destroys the historical creation timestamp for every GL transaction in the closing year, and breaks any report that relies on `audit_trail.stamp`.

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

Release 2.4.20

2026-04-28T13:11:55Z

Announcement

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.