Just checked. This has been the default since the very beginning over 15 years ago.
26 07/03/2025 05:49:34 pm
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
27 07/02/2025 04:05:44 pm
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
Duplication of posts causes deletion to avoid having to look into multiple posts.
Please take assistance of php programmers to inspect variables in the code at the point of failure where the error comes out. There is one of the forums in this board where such professional programmers exist.
I used an existing test install on Debian 6 to check out if and when the closing GL greyed out issue occurred since several code changes have been effected over time. It is not my recommendation to use Debian 6 in public facing installs.
The project admins are in Poland (@itronics Janusz) and Sweden (@joe Hunt) who are closer to your time zone and possibly have access to several platform versions to assist.
I only have as much time to assist on various issues in FA as I participate in the project only as a hobby and for teaching accounting.
I am sorry I have been of little use to solve your issue. Good luck with others helping you.
Generally when ever any issues arise with later versions of PHP/MySQL we generally regress to a known state / platform and then probe our way to a solution.
28 07/02/2025 01:28:09 am
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
Tested with Debian 6 and MySQL 5.1 and PHP 5.3.3 and all worked well.
If adding a user was a real problem practically all major users of FA would have complained by now.
Single stepping and watch points and debug_status are the way forward.
29 06/30/2025 11:17:59 am
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
You will have to do an investigation into it in the code given earlier by putting it watch points and logging the variables.
30 06/28/2025 09:19:44 pm
Re: GL account cannot be inactivated (2 replies, posted in Banking and General Ledger)
Which version of PHP/MySQL are you using?
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.
This error is effected in line 87 (in current FA version) of gl/manage/gl_accounts.php.
Lines 89-94:
elseif (update_gl_account($_POST['account_code'], $_POST['account_name'],
$_POST['account_type'], $_POST['account_code2'])) {
update_record_status($_POST['account_code'], $_POST['inactive'],
'chart_master', 'account_code');
update_tag_associations(TAG_ACCOUNT, $_POST['account_code'],
$_POST['account_tags']);need to succeed.
Furthermore, the table 0_bank_accounts 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 gl/includes/db/gl_db_accounts.inc.
Hence the specific version of MySQL when queried may be returning a NULL instead of 0 for the inactive field or the get_post() part of the html response may not be of the type expected in the browser / PHP version used.
@joe: Any checks in the code that is preventing it?
31 06/28/2025 09:14:47 pm
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
Check the Trial Balances for any discrepancy and whether Credit and Debit balances tally.
32 06/28/2025 06:19:08 am
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
You will have to make the 2024 year as the active year and then close the 2023 year.
33 06/27/2025 04:16:33 pm
Re: Unable to add user in FA latest version (4 replies, posted in Setup)
Check for a field with no autocomplete attribute and fill it in.
@joe: will this need to be fixed for the entire codebase or is there an autocomplete default setting or ignore that will suffice??
34 06/27/2025 04:07:06 pm
Re: "Closing GL Transactions" grayed out (16 replies, posted in Banking and General Ledger)
Closing the dummy year will forward the closing balances to the new years' opening balances.
Please note that all partial transactions will be abridged into the opening balances unless the dummy year had details of individual transactions that were to be finished in the new year.
35 06/23/2025 01:58:49 pm
Re: GL Inquiry can't show one year of data (11 replies, posted in Banking and General Ledger)
Restart webserver if php.ini settings were changed.
Optimise your database and introduce some indexes for certain fields used in the report query.
export out your database and recreate it by importing it into a new structure.
36 06/21/2025 05:01:59 am
Re: Manage Customer Debit Notes (1 replies, posted in Accounts Receivable)
Check if negative values are allowed in the settings.
37 06/21/2025 05:01:02 am
Re: Unable to add user in FA latest version (4 replies, posted in Setup)
Check the MySQL and PHP and Apache error logs.
38 06/21/2025 04:59:56 am
Re: GL Inquiry can't show one year of data (11 replies, posted in Banking and General Ledger)
Increase the number of max_input_vars in the php.ini apart from max memory size.
39 06/14/2025 06:17:17 pm
Re: Edit Inventory Adjustment & Stock list with Cost Prices (3 replies, posted in Items and Inventory)
Perplexity.ai and Duck.ai are frontends for the AI chat engine. Just type in your question briefly and you will get the answers.
40 06/14/2025 06:15:02 pm
Re: Looking for FrontAccounting Development Services (1 replies, posted in Jobs wanted/offered, non-free offers)
Check your PM where I answered your queries.
41 06/14/2025 06:12:58 pm
Re: Is FrontAccounting PHP 8.3 Ready? (10 replies, posted in Setup)
Google search:
https://stackoverflow.com/questions/54126343/how-to-fix-unchecked-runtime-lasterror-the-message-port-closed-before-a-respon
Generally a problem with some browser extension.
42 06/14/2025 06:10:18 pm
Re: Automate Customer Credit Status (5 replies, posted in Accounts Receivable)
Search for the code where the amount comes in as red and prevent it from making an invoice there.
The Credit Limit is set in the table #_debtors_master.credit_limit and the credit_status field therein shows the ID of the record where #_credit_status.disallow_invoices field has the binary switch.
There is a similar field as #_suppliers.credit_limit too.
43 06/08/2025 08:57:26 am
Re: Automate Customer Credit Status (5 replies, posted in Accounts Receivable)
This is more of a soft cap for credit limit that you can exceed at will. The first time it did not show as the previous balance was under 10K you had set. This is more a server side validation for prompting (red) of the exceeded state.
44 06/07/2025 10:58:27 am
Re: Automate Customer Credit Status (5 replies, posted in Accounts Receivable)
Check if you find something in red in such an invoice when the amount is reached.
45 06/01/2025 09:18:41 pm
Re: Help on configuring FrontAccounting (3 replies, posted in Installation)
Ask in the Job offers board.
46 05/31/2025 03:13:13 pm
Re: Help on configuring FrontAccounting (3 replies, posted in Installation)
Check out the tutorials from IIT Mumbai - Spoken-Tutorial
Use the Indian CoA and place the file in the FA Webroot/sql folder and create your company with it from the derfault company.
47 05/16/2025 01:51:12 am
Re: Modify the Invoice Table Content (5 replies, posted in Reporting)
only reporting/rep107.php lines 86-90:
//-------------code-Descr-Qty--uom--tax--prc--Disc-Tot--//
$cols = array(4, 60, 225, 300, 325, 385, 450, 515);
// $headers in doctext.inc
$aligns = array('left', 'left', 'right', 'center', 'right', 'right', 'right');lines 192-199
if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !$SysPrefs->no_zero_lines_amount())
{
$rep->TextCol($c++, $c, $DisplayQty, -2);
$rep->TextCol($c++, $c, $myrow2['units'], -2);
$rep->TextCol($c++, $c, $DisplayPrice, -2);
$rep->TextCol($c++, $c, $DisplayDiscount, -2);
$rep->TextCol($c++, $c, $DisplayNet, -2);
}48 05/15/2025 01:25:34 pm
Re: Modify the Invoice Table Content (5 replies, posted in Reporting)
You will find an array of column widths and heading names and variables from some sql that you can comment out or delete.
49 05/14/2025 05:06:32 pm
Re: Modify the Invoice Table Content (5 replies, posted in Reporting)
Just blank the headings and displays in the rep107.php file.
50 05/13/2025 02:49:08 pm
Re: PHP 8.4 trigger_error($msg, E_USER_ERROR) obsolete (4 replies, posted in Report Bugs here)
Looks like the extensions too must have the function trigger_error replaced by fa_trigger_error too.
osc_orders/osCommerce.php
$result = mysqli_query($osc, $sql) or trigger_error("Query Failed! SQL: $sql - Error: ".mysqli_error($osc), E_USER_ERROR);api24/sales.inc
if ($can_process['passed'] == false) {
trigger_error(var_export($can_process, true));
api_error(412, $can_process['message']);
return;
}The commit at: https://github.com/FrontAccountingERP/FA/commit/7092ac6864fd902b61d2c01ba694c4b5dba703fb
solves this issue for the core.
Additionally, the original function trigger_error() could have been retained for those using older extensions with older PHP versions and code.
