<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Report Bugs here]]></title>
		<link>https://frontaccounting.com/punbb/index.php</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=13&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent topics at FrontAccounting forum.]]></description>
		<lastBuildDate>Mon, 02 Nov 2026 14:06:43 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Realized FX not posted when a PO prepayment is moved to the invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10747&amp;action=new</link>
			<description><![CDATA[<p>Claude Assisted.</p><p>Version: FrontAccounting 2.4.19 and 2.4.20 (same code in both)</p><p>Summary<br />When an advance payment allocated to a Purchase Order is transferred to the<br />supplier invoice on invoice entry, the exchange difference between the payment<br />rate and the invoice rate is never posted. The supplier sub-ledger shows the<br />invoice fully settled, but GL Accounts Payable keeps the FX difference as a<br />residual balance. Normal allocations (Allocate Supplier Payments) post the FX<br />correctly; only the PO-prepayment path is affected.</p><p>Steps to reproduce (home currency CAD, supplier in USD)<br />1. Purchase Order Entry: USD supplier, date 11/01, 1,000.00 USD.<br />2. Supplier payment dated 11/01, 1,000.00 USD at rate 1.30; allocate it to the PO<br />&nbsp; &nbsp;(the PO is only offered for allocation before it is received).<br />3. Receive the PO on 11/02.<br />4. Enter the supplier invoice for that delivery dated 11/03 at rate 1.40.</p><p>Expected<br />The invoice GL shows an exchange variation pair for the advance:<br />&nbsp; Dr Accounts Payable 100.00 / Cr Exchange Variances 100.00<br />&nbsp; (1,000 x (1.40 - 1.30)), and GL AP for the supplier nets to zero.</p><p>Actual<br />No exchange variation is posted. The invoice is fully allocated in the<br />sub-ledger, but GL AP for the supplier is left at Cr 100.00.</p><p>Cause<br />add_supp_invoice() (purchasing/includes/db/invoice_db.inc) moves the PO<br />allocations with get_po_prepayments() -&gt; reallocate_payments() -&gt;<br />allocate_payment(). allocate_payment() only rewrites supp_allocations and the<br />alloc totals; it never calls exchange_variation(), unlike<br />allocation_cart::write().</p><p>Suggested fix<br />After reallocate_payments() in add_supp_invoice(), for supplier invoices, call<br />exchange_variation() for each allocation now pointing at the new invoice,<br />using the payment&#039;s own date (as allocation_cart::write() does):</p><p>&nbsp; if ($trans_type == ST_SUPPINVOICE &amp;&amp; empty($GLOBALS[&#039;no_exchange_variations&#039;])) {<br />&nbsp; &nbsp; &nbsp; $res = db_query(&quot;SELECT a.trans_type_from, a.trans_no_from, a.amt, t.tran_date<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM &quot;.TB_PREF.&quot;supp_allocations a<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOIN &quot;.TB_PREF.&quot;supp_trans t ON t.type=a.trans_type_from<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND t.trans_no=a.trans_no_from AND t.supplier_id=a.person_id<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE a.trans_type_to=&quot;.ST_SUPPINVOICE.&quot; AND a.trans_no_to=&quot;.db_escape($invoice_id).&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND a.person_id=&quot;.db_escape($supp_trans-&gt;supplier_id));<br />&nbsp; &nbsp; &nbsp; while ($a = db_fetch($res))<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($a[&#039;trans_type_from&#039;] != ST_JOURNAL)<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exchange_variation($a[&#039;trans_type_from&#039;], $a[&#039;trans_no_from&#039;],<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ST_SUPPINVOICE, $invoice_id, sql2date($a[&#039;tran_date&#039;]),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $a[&#039;amt&#039;], PT_SUPPLIER);<br />&nbsp; }</p><p>Note for invoice re-entry (edit): the invoice gets a new number and existing<br />allocations are moved the same way. FX previously booked on the payment side<br />(memo &quot;Supplier Invoice &lt;old no&gt;&quot;) is not removed by void_transaction(), so a<br />complete fix should remove the old pair&#039;s FX before re-posting. Related: the<br />allocation re-save duplicate FX issue below makes this worse.</p>]]></description>
			<author><![CDATA[null@example.com (andijani)]]></author>
			<pubDate>Mon, 02 Nov 2026 14:06:43 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10747&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[re-saving an existing allocation posts its FX difference a second time]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10746&amp;action=new</link>
			<description><![CDATA[<p>Reproduction steps</p><p>Setup. Home currency CAD. Create a test supplier in USD.</p><p>Exchange rates. In Banking and General Ledger → Exchange Rates, set USD to 1.30 on 11/01/2026 and 1.40 on 11/02/2026.<br />Invoice. Enter a supplier invoice dated 11/01/2026 for 1,000.00 USD. This books AP at 1,300 CAD.<br />Payment. Enter a supplier payment dated 11/02/2026 for 1,000.00 USD and allocate the full amount to the invoice on the payment screen. The payment debits AP at 1,400 CAD.<br />Check. Open the payment’s GL view. You should see one FX pair of 100.00 between AP and Foreign Exchange Gain/(Loss), memo “Supplier Invoice N”. That pair is correct.<br />Trigger. Go to Purchases → Allocate Supplier Payments or Credit Notes and tick Show Settled Items. Click Allocate on the payment. It shows 1,000 already allocated. Click Process without changing anything.<br />Result. Open the payment’s GL view again. There are now two identical 100.00 FX pairs, and each extra Process adds another. Supplier Inquiry still shows everything settled, but GL AP for that supplier is now off by 100 for each extra pair.</p><p>Files modified:</p><p>includes/banking.inc — new remove_exchange_variation() helper<br />includes/ui/allocation_cart.inc — write() now removes the previous FX before re-posting</p>]]></description>
			<author><![CDATA[null@example.com (andijani)]]></author>
			<pubDate>Mon, 02 Nov 2026 13:59:41 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10746&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Cross-company session context issue with stale browser tabs]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10740&amp;action=new</link>
			<description><![CDATA[<p>I found a reproducible cross-company session/context problem in FrontAccounting 2.4.20 when browser tabs opened under different company contexts remain open.<br />Steps to reproduce<br />1. Open FrontAccounting in company A and open Banking and General Ledger → Journal Inquiry.<br />2. Company A uses - as the date separator, so the page contains dates such as 2025-01-01 and 2025-12-31.<br />3. Change the active FrontAccounting session to company B in another browser tab. Company B uses / as the date separator.<br />4. Return to the old Journal Inquiry tab which was generated while company A was active.<br />5. Press Search without reloading that page.<br />Actual result<br />The old page is still displayed as belonging to company A, but the request is processed using the preferences of the currently active company B session.<br />The following PHP warnings are produced:<br />Undefined array key 1 in /srv/frontaccounting/includes/date_functions.inc at line 398<br />Undefined array key 2 in /srv/frontaccounting/includes/date_functions.inc at line 398<br />A non-numeric value encountered in /srv/frontaccounting/includes/date_functions.inc at line 405</p><p>The call shown in the error output is, for example:<br />date2sql(&#039;2025-01-01&#039;)</p><p>date2sql() obtains the current separator using:<br />$sep = $SysPrefs-&gt;dateseps[user_date_sep()];</p><p>and for the YYYYMMDD date format eventually executes:<br />list($year, $month, $day) = explode($sep, $date_);</p><p>user_date_sep() in includes/current_user.inc gets the separator from the current session:<br />return isset($_SESSION[&quot;wa_current_user&quot;]-&gt;prefs-&gt;date_sep)<br />&nbsp; &nbsp; ? $_SESSION[&quot;wa_current_user&quot;]-&gt;prefs-&gt;date_sep()<br />&nbsp; &nbsp; : $SysPrefs-&gt;dflt_date_sep;</p><p>Therefore the stale company A page submits 2025-01-01, while the current session expects /. This effectively results in:<br />explode(&#039;/&#039;, &#039;2025-01-01&#039;)</p><p>which explains the warnings.<br />Expected result<br />A page generated in the context of company A should not silently be processed in the context of company B after the active session company has changed.<br />Ideally, each submitted form/request should contain enough information to verify that the company context in which the page was generated still matches the current session company. If it does not match, FrontAccounting should reject the request and ask the user to reload the page.<br />Why I think this is more important than the date parsing warning<br />The different date separators made the problem visible. If both companies had identical date settings, this particular request might apparently succeed and there would be no obvious indication that a page generated under company A was being processed using company B&#039;s current session context.<br />I have reproduced the context mismatch with Journal Inquiry. I have not tested submitting an accounting transaction from such a stale tab because I do not want to risk modifying the wrong company&#039;s data. Therefore I cannot say that cross-company writes are possible, but I think this should be checked because it could represent a data-integrity issue.<br />Version: FrontAccounting 2.4.20<br />I can provide a screenshot showing the complete PHP warnings and the stale Journal Inquiry page if useful.</p>]]></description>
			<author><![CDATA[null@example.com (peacecop kalmer:)]]></author>
			<pubDate>Sat, 26 Sep 2026 22:29:45 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10740&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Installing clean 2.4.20 version gets stuck]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10726&amp;action=new</link>
			<description><![CDATA[<p>Hi </p><p>I was installing the new 2.4.20 version and it could&#039;t finish installation</p><p>I&#039;m using </p><p>MariaDB 10.4.32<br />PHP Version 8.1.25</p><p>The problem I notice is when the system tries to execute the script </p><p> CREATE TABLE `0_bank_accounts` (<br />&nbsp; `account_code` varchar(15) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `account_type` smallint(6) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `bank_account_name` varchar(60) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_account_number` varchar(100) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_name` varchar(60) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `bank_address` tinytext,<br />&nbsp; `bank_curr_code` char(3) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `dflt_curr_act` tinyint(1) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `id` smallint(6) NOT NULL AUTO_INCREMENT,<br />&nbsp; `bank_charge_act` varchar(15) NOT NULL DEFAULT &#039;&#039;,<br />&nbsp; `last_reconciled_date` timestamp NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;,<br />&nbsp; `ending_reconcile_balance` double NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; `inactive` tinyint(1) NOT NULL DEFAULT &#039;0&#039;,<br />&nbsp; PRIMARY KEY (`id`),<br />&nbsp; KEY `bank_account_name` (`bank_account_name`),<br />&nbsp; KEY `bank_account_number` (`bank_account_number`),<br />&nbsp; KEY `account_code` (`account_code`)<br />) ENGINE=InnoDB AUTO_INCREMENT=3 ; </p><p>the failure is because in the newer MariaDB does not allow this line&nbsp; &nbsp;<br />`last_reconciled_date` timestamp NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;, </p><p>so in order to make it work change it to&nbsp; <br />`last_reconciled_date` DATETIME NOT NULL DEFAULT &#039;1900-01-01 00:00:00&#039;,</p><p>After I did it it works, hope I can help someone.</p>]]></description>
			<author><![CDATA[null@example.com (fburbano)]]></author>
			<pubDate>Tue, 12 May 2026 18:30:49 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10726&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[close_transactions() silently overwrites audit_trail.stamp]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10725&amp;action=new</link>
			<description><![CDATA[<p>After closing an old fiscal year, I noticed `0_audit_trail.stamp` had been rewritten to &quot;now&quot; for every row whose `gl_seq` was updated by the close routine. Rows the close didn&#039;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`.</p><p>Two innocent pieces interacting:</p><p>1. `0_audit_trail.stamp` is defined as `TIMESTAMP ... ON UPDATE CURRENT_TIMESTAMP` (FA default, used to track edit time).<br />2.&nbsp; close_transactions() in `includes/db/audit_trail_db.inc` runs `UPDATE 0_audit_trail SET gl_seq=$seq WHERE id=...</p><p>The UPDATE only sets `gl_seq`, but MySQL auto-refreshes `stamp` as a side effect of the `ON UPDATE` clause. The `if ($row[&#039;gl_seq&#039;] != $seq)` guard is why only some rows get hit — exactly the ones being re-sequenced.</p><p>I tried fixing it with the following change</p><p>$sql2 = &quot;UPDATE &quot;.TB_PREF.&quot;audit_trail SET&quot;<br />&nbsp; &nbsp; . &quot; gl_seq=$seq&quot;<br />&nbsp; &nbsp; . &quot; WHERE id=&quot;.$row[&#039;id&#039;];</p><p>to:</p><p>$sql2 = &quot;UPDATE &quot;.TB_PREF.&quot;audit_trail SET&quot;<br />&nbsp; &nbsp; . &quot; gl_seq=$seq,&quot;<br />&nbsp; &nbsp; . &quot; stamp=stamp&quot; // preserve original timestamp<br />&nbsp; &nbsp; . &quot; WHERE id=&quot;.$row[&#039;id&#039;];</p><p>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.</p><p>Has anyone else hit this? Kindly share your experience.</p><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (dz)]]></author>
			<pubDate>Tue, 12 May 2026 15:22:50 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10725&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[DATA INTEGRITY: gl_trans still contains non zero voided items]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10718&amp;action=new</link>
			<description><![CDATA[<p>I discovered today that my gl_trans table had both a Bank Payment and a Bank Deposit that had non zero values but the void_transaction screen showed as non-existent.&nbsp; &nbsp;Discovered while trying to reconcile bank accounts.</p><p>bank_account_reconcile did NOT list the items, so I searched the GL Enquiry for transactions in case they were registered against wrong GLs.</p><p>gl_account_inquiry listed these items with the non zero values (the values I was expecting - but with extra lines)</p><p>gl_trans_view.php opened the items, displayed looking like a Journal Entry rather than the normal Payment/Deposit pop ups.</p><p>gl_journal.php?ModifyGL=yes opened into the Bank Deposit or Bank Payment editored, but all lines were of zero value, and the date was today&#039;s date.&nbsp; Altering and saving resulted in the next screen saying transaction 0 was updated.</p><p>I am currently on 2.4.19 but was on 2.4.1 until a month or so ago, so this data corruption could be from a while ago.</p><p>PROPOSAL:<br />1) A report that cross references the various tables that store this data and reports mis-matches.<br />2) an editor to clean these up - either a &quot;force&quot; for void or similar zero everything.&nbsp; I haven&#039;t worked through this yet as EOY tax reporting is less than a week away.</p>]]></description>
			<author><![CDATA[null@example.com (fraserks)]]></author>
			<pubDate>Wed, 25 Mar 2026 21:04:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10718&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Displaying attachments corrupted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10715&amp;action=new</link>
			<description><![CDATA[<p>When I am in the attachments screen and click on either the download button or the view button, a pop-up opens, but the attachment isn&#039;t displayed.</p><p>trial and error in attachments.php around line 37, replacing the following:</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $type = ($row[&#039;filetype&#039;]) ? $row[&#039;filetype&#039;] : &#039;application/octet-stream&#039;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Content-type: &quot;.$type);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&#039;Content-Length: &#039;.$row[&#039;filesize&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Content-Disposition: inline&quot;);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo file_get_contents(company_path(). &quot;/attachments/&quot;.$row[&#039;unique_name&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit();</p><br /><p>with</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header( &quot;location: &quot; . $_SERVER[&#039;PHP_SELF&#039;] . &quot;/../&quot; . company_path(). &quot;/attachments/&quot;.$row[&#039;unique_name&#039;] );<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit();</p><p>works.&nbsp; I don&#039;t see any security issue by passing a URL instead of a stream?</p>]]></description>
			<author><![CDATA[null@example.com (fraserks)]]></author>
			<pubDate>Mon, 16 Mar 2026 17:09:08 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10715&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Can not go through sales]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10712&amp;action=new</link>
			<description><![CDATA[<p>Can not go through sales from direcet invoice. I have been using it for long time. There was not any problem before but now when i go through direct invoice. I can not chose product code. See the image..</p>]]></description>
			<author><![CDATA[null@example.com (johngovment)]]></author>
			<pubDate>Sat, 21 Feb 2026 07:35:35 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10712&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[exchange-rates.org update]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10708&amp;action=new</link>
			<description><![CDATA[<p>Since the end of January 2026 I have not been able to retrieve exchange rates from exchange-rates.org</p><p>It seems they&#039;ve changed their URL.</p><p>This seems to fix it:</p><p>gl/includes/db/gl_db_rates.inc</p><p>line 168 change:</p><div class="codebox"><pre><code>$filename = &quot;/converter/{$curr_b}/{$curr_a}/1&quot;;</code></pre></div><p>to:</p><div class="codebox"><pre><code>$filename = &quot;/converter/{$curr_b}-{$curr_a}&quot;;</code></pre></div><p>Starting line 166 this section will be:</p><div class="codebox"><pre><code>elseif ($provider == &#039;EXCHANGE-RATES.ORG&#039;)
    {
        //$filename = &quot;/converter/{$curr_b}/{$curr_a}/1&quot;;
        $filename = &quot;/converter/{$curr_b}-{$curr_a}&quot;;
        $site = &quot;exchange-rates.org&quot;;
        $proto = &#039;https://&#039;;
        $contents=file_get_contents($proto.$site.$filename);
    }</code></pre></div>]]></description>
			<author><![CDATA[null@example.com (ckrosco)]]></author>
			<pubDate>Thu, 05 Feb 2026 16:48:59 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10708&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Canot edit Journa Entry! Help Needed]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10700&amp;action=new</link>
			<description><![CDATA[<p>Hello<br />I cannot edit journal entries. When i edit and click save/update the screen do just nothing (like if i didnt hit save button)<br />i tried to upgrade/downgrade from verion 4.2.16-19 nothing worked<br />i tried changing PHP versions from 7.4-8.4 nothing worked<br />i disbaled modsec and litespeed caching nothing worked<br />Environment: cPane Shared Hosting / Litespeed Webserver</p><p>FYI: the user is Admin / Active facial year is same year as the journal entry i want to edit</p><p>Your advice is appreciated</p><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (mohamednour)]]></author>
			<pubDate>Fri, 02 Jan 2026 11:48:02 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10700&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Theme changed to exclusive_db and now nothing is appearing]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10698&amp;action=new</link>
			<description><![CDATA[<p>Hello, i changed the theme from preferences to exclusive_db and now nothing is appearing. i have tons of work to do please help me out. attached is the screenshot for your reference.</p>]]></description>
			<author><![CDATA[null@example.com (Shoaib AKbar)]]></author>
			<pubDate>Tue, 16 Dec 2025 05:12:04 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10698&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[[2.4.x] Systemic 'Red X' for all Extensions & Missing Menu Li]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10697&amp;action=new</link>
			<description><![CDATA[<p>Body:</p><p>Hello FrontAccounting Community,</p><p>I am seeking assistance with a systemic failure where all extensions show a Red X on the &quot;Install/Activate Extensions&quot; page, and more critically, active extensions (like Import Transactions) are completely missing from the main menu.</p><p>This is occurring on both a fresh XAMPP installation and a HostGator installation, pointing toward a core compatibility issue rather than a permissions failure.</p><p>Environment Details</p><p>Component&nbsp; &nbsp; Version/Status<br />FrontAccounting Version&nbsp; &nbsp; 2.4.x (Likely a standard release)<br />PHP Version (XAMPP)&nbsp; &nbsp; 7.1.1 (from the installer name)<br />Problem Status&nbsp; &nbsp; All active extensions fail to load/display.</p><p>Diagnostic Steps Completed (Problem is NOT one of these)<br />We have systematically ruled out the most common causes:</p><p>File Permissions: The required folders (modules, _cache, company/0/attachments) have been confirmed to be writable and have sufficient permissions.</p><p>Extension Activation: The file installed_extensions.php confirms the extensions are correctly marked as active (&#039;active&#039; =&gt; 1).</p><p>Core Compatibility Patch #1 (Magic Quotes): The file includes\db\connect_db.inc does NOT contain the deprecated get_magic_quotes_gpc() function, meaning this common PHP 7.x patch is not needed.</p><p>PHP Config: session.save_path is working, and resource limits (max_execution_time, memory_limit) have been significantly increased.</p><p>Short Tags: short_open_tag = On has been confirmed.</p><p>The Remaining Mystery: Fatal PHP Error<br />Since the extensions are correctly configured to load but are failing to execute (missing menu links), the script is hitting a Fatal Error during the menu-building process. Given the PHP 7.1 version, the next most probable cause is the use of the reference operator (&amp;) in a function declaration.</p><p>Could an experienced user please confirm the location of the core database wrapper file(s) that must be patched for PHP 7.1 compatibility, specifically by removing the &amp; from function definitions like function &amp;db_query(...)?</p><p>I have searched for database.inc and sql_funcs.inc and they do not exist in the expected locations in this specific FA version. If I knew the correct file name, I could apply the patch and resolve this systemic issue on both my installations.</p><p>Thank you in advance for any guidance!</p>]]></description>
			<author><![CDATA[null@example.com (brianrhunt777)]]></author>
			<pubDate>Fri, 12 Dec 2025 00:00:46 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10697&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Error Reporting Not Showing Backtrace in PHP 8.1 +]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10696&amp;action=new</link>
			<description><![CDATA[<p>In PHP 7.4 it gives error like this</p><div class="codebox"><pre><code>DATABASE ERROR : The sales area could not be updated error code : 1054 error message : Unknown column &#039;descriptio&#039; in &#039;field list&#039; sql that failed was : UPDATE 0_areas SET descriptio=&#039;Global&#039; WHERE area_code = &#039;1&#039; /home/sites/39b/7/7d21587bd2/public_html/dev/includes/errors.inc:235: trigger_error(&#039;DATABASE ERROR : The sales area could not be updated error code : 1054 error message : Unknown column &#039;descriptio&#039; in &#039;field list&#039; sql that failed was : UPDATE 0_areas SET descriptio=&#039;Global&#039; WHERE area_code = &#039;1&#039; &#039;,&#039;256&#039;) /home/sites/39b/7/7d21587bd2/public_html/dev/includes/errors.inc:261: display_db_error(&#039;The sales area could not be updated&#039;,&#039;UPDATE 0_areas SET descriptio=&#039;Global&#039; WHERE area_code = &#039;1&#039;&#039;,&#039;&#039;) /home/sites/39b/7/7d21587bd2/public_html/dev/includes/db/connect_db_mysqli.inc:103: check_db_error(&#039;The sales area could not be updated&#039;,&#039;UPDATE 0_areas SET descriptio=&#039;Global&#039; WHERE area_code = &#039;1&#039;&#039;,&#039;1&#039;) /home/sites/39b/7/7d21587bd2/public_html/dev/sales/includes/db/sales_groups_db.inc:71: db_query(&#039;UPDATE 0_areas SET descriptio=&#039;Global&#039; WHERE area_code = &#039;1&#039;&#039;,&#039;The sales area could not be updated&#039;) /home/sites/39b/7/7d21587bd2/public_html/dev/sales/manage/sales_areas.php:38: update_sales_area(&#039;1&#039;,&#039;Global&#039;)</code></pre></div><p>but in php 8.1+ it does not show Backtrace</p><div class="codebox"><pre><code>Unhandled exception [1054]: Unknown column &#039;descriptio&#039; in &#039;field list&#039;. in file: /home/sites/39b/7/7d21587bd2/public_html/dev/includes/db/connect_db_mysqli.inc at line 80 exception_handler((mysqli_sql_exception Object))</code></pre></div><p>How to Fix?</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Sat, 06 Dec 2025 20:08:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10696&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Customer Balances 2.4.17]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10693&amp;action=new</link>
			<description><![CDATA[<p>Good day Team</p><p>When doing a Report/Customer Reports, Customer Balances, and you set the dtae range for the report for example 01/03/2024 to 28/02/2025 and ask for details on the customer balances, it will include allocations made after the 28/02/2025. This creates a huge discrepancy with the aged analysis report and the Debtors Ledger for the same period. </p><p>This renders the Customer Balances useless for any period. </p><p>Please advise how we can fix this since the CA&#039;s want such a report for each customer over the financial year.</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Thu, 13 Nov 2025 12:43:48 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10693&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Error thrown php 8.4.10 compatibility?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=10686&amp;action=new</link>
			<description><![CDATA[<p>When adding a new image to an item, I got this error:</p><p>Creation of dynamic property TCPDF::$padding is deprecated in file: /home/pelham10/public_html/fa/<a href="https://github.com/FrontAccountingERP/FA/blob/master/reporting/includes/tcpdf.php#L1172">reporting/includes/tcpdf.php at line 1172</a><br />/home/pelham10/public_html/fa/reporting/includes/tcpdf.php:185:&nbsp; &nbsp; (TCPDF Object)-&gt;__construct()<br />/home/pelham10/public_html/fa/inventory/manage/items.php:173: check_image_file(&#039;../../company/0/images/Coin_2025_Town_Hall.jpg&#039;)</p>]]></description>
			<author><![CDATA[null@example.com (brucek@pelhamhs.org)]]></author>
			<pubDate>Fri, 03 Oct 2025 16:45:30 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=10686&amp;action=new</guid>
		</item>
	</channel>
</rss>
