<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — GL account cannot be inactivated]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=10607</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10607&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in GL account cannot be inactivated.]]></description>
		<lastBuildDate>Sat, 28 Jun 2025 21:19:44 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: GL account cannot be inactivated]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43703#p43703</link>
			<description><![CDATA[<p>Which version of PHP/MySQL are you using?</p><p>Looks like the de-activation of the linked bank account is not being updated in the database presumably if there are transactions dependent on it.</p><p>This error is effected in line 87 (in current FA version) of <strong>gl/manage/gl_accounts.php</strong>.<br />Lines 89-94:<br /></p><div class="codebox"><pre><code>            elseif (update_gl_account($_POST[&#039;account_code&#039;], $_POST[&#039;account_name&#039;], 
                $_POST[&#039;account_type&#039;], $_POST[&#039;account_code2&#039;])) {
                update_record_status($_POST[&#039;account_code&#039;], $_POST[&#039;inactive&#039;],
                    &#039;chart_master&#039;, &#039;account_code&#039;);
                update_tag_associations(TAG_ACCOUNT, $_POST[&#039;account_code&#039;], 
                    $_POST[&#039;account_tags&#039;]);</code></pre></div><p>need to succeed.</p><p>Furthermore, the table <strong>0_bank_accounts</strong> too needs to have the inactive field set as needed and refreshed for the session variables to be updated. From line 282, the function is_bank_account($account_code) has been defined in <strong>gl/includes/db/gl_db_accounts.inc</strong>.</p><p>Hence the specific version of MySQL when queried may be returning a NULL instead of 0 for the <strong>inactive</strong> field or the get_post() part of the html response may not be of the type expected in the browser / PHP version used.</p><p>@joe: Any checks in the code that is preventing it?</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 28 Jun 2025 21:19:44 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43703#p43703</guid>
		</item>
		<item>
			<title><![CDATA[Re: GL account cannot be inactivated]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43701#p43701</link>
			<description><![CDATA[<p>I did it directly in the MySQL-Database:</p><br /><p>USE your_fa_database;</p><p>UPDATE `0_chart_master` SET `inactive` = &#039;1&#039; WHERE `0_chart_master`.`account_code` = &#039;&nbsp; &nbsp;&quot;your_bank_account&quot;&nbsp; &nbsp;&#039;;</p><br /><p>-&gt; replace your_fa_database with the name of your database<br />-&gt; replace &quot;your_bank_account&quot; with the concerned bank account number, eg. 1010</p>]]></description>
			<author><![CDATA[null@example.com (Rafy)]]></author>
			<pubDate>Sat, 28 Jun 2025 12:35:26 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43701#p43701</guid>
		</item>
		<item>
			<title><![CDATA[GL account cannot be inactivated]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43405#p43405</link>
			<description><![CDATA[<p>Hi</p><p>It is not possible to declare a general ledger account as inactive, while a bank account is linked to this GL account. Even if the bank account itself is declared as inactive in &quot;Bank Accounts&quot; (tick box).<br />In the above described case the following message is shown when trying to set the GL account as inactive: &quot;The account belongs to a bank account and cannot be inactivated.&quot;</p><p>Is there a work around how to set a general ledger account linked to a bank account as inactive?</p><p>Version used: 2.4.16</p><p>Thanks and regards<br />Rafy</p>]]></description>
			<author><![CDATA[null@example.com (Rafy)]]></author>
			<pubDate>Fri, 11 Oct 2024 12:14:47 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43405#p43405</guid>
		</item>
	</channel>
</rss>
