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.
1 06/23/2025 01:58:49 pm
Re: GL Inquiry can't show one year of data (4 replies, posted in Banking and General Ledger)
2 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.
3 06/21/2025 05:01:02 am
Re: Unable to add user in FA latest version (3 replies, posted in Setup)
Check the MySQL and PHP and Apache error logs.
4 06/21/2025 04:59:56 am
Re: GL Inquiry can't show one year of data (4 replies, posted in Banking and General Ledger)
Increase the number of max_input_vars in the php.ini apart from max memory size.
5 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.
6 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.
7 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.
8 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.
9 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.
10 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.
11 06/01/2025 09:18:41 pm
Re: Help on configuring FrontAccounting (3 replies, posted in Installation)
Ask in the Job offers board.
12 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.
13 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);
}
14 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.
15 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.
16 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.
17 05/13/2025 02:44:46 pm
Re: Struggling to find quality resources for open-source accounting (1 replies, posted in Jobs wanted/offered, non-free offers)
Refer the wiki
18 05/09/2025 11:25:51 am
Re: PHP 8.4 trigger_error($msg, E_USER_ERROR) obsolete (4 replies, posted in Report Bugs here)
is E_USER_NOTICE available in older PHP versions say 5.x ?
Any best practice for safe degradation?
19 05/09/2025 11:21:15 am
Re: Backup / Restore data to a new database (1 replies, posted in Installation)
Just take a backup of your web installation folder of FA for the remote host. I trust you will be doing a windows based local hosting on your desktop. If not suitably modify accordingly.
Match the PHP / MySQL and the respective ini file values to your local environment.
Unpack the web remote web folder backup into your local web setup.
Take a full FA MySQL backup from within the FA remote installation (if data is limited) or a phpmyadmin backup if otherwise.
Then restore them to the local web server re-creating the MySQL databases along with their collation and content.
Make any changes to your FA config.php file in your local install as appropriate.
You should be good to go.
20 05/03/2025 11:30:02 pm
Re: Sorting of Expense Accounts Alphabetically (3 replies, posted in Banking and General Ledger)
That will be in reporting/rep707.php.
The relevant code is:
function print_profit_and_loss_statement()
The loop is in line 288 within which the elements will need to be alphabetically arranged:
while ($accounttype=db_fetch($typeresult))
Line 273:
$classresult = get_account_classes(false, 0);
too could be checked out.
The lines 40-41 in function display_type
$result = get_gl_accounts(null, null, $type);
while ($account=db_fetch($result))
may need to be sorted for your needs.
A modified version of the rep707.php could be made into an extension to serve your needs. Anyone game?
21 05/02/2025 09:59:58 pm
Re: Direct Purchase Invoice Entry - cannot process (2 replies, posted in Accounts Payable)
Change this in php.ini file
; max_input_vars = 1000
To this (removing the semicolon which is commented out)
max_input_vars = 4000
Will need to restart the webserver thereafter.
22 05/02/2025 09:55:03 pm
Re: Sorting of Expense Accounts Alphabetically (3 replies, posted in Banking and General Ledger)
Where? In the report? Which report?
Will this sort affect groups' child entries?
23 05/02/2025 09:53:30 pm
Re: Before GRN Clearing Account can be changed all GRNs have to be invoice (1 replies, posted in Report Bugs here)
Will NULL solve the issue especially if it is to be the field's default?
24 04/27/2025 08:48:47 am
Re: Edit Inventory Adjustment & Stock list with Cost Prices (3 replies, posted in Items and Inventory)
25 04/27/2025 08:45:56 am
Re: Import Transactions (7 replies, posted in Banking and General Ledger)
Compile and install PHP 5.6.40 from scratch. What is the linux version on your old and new computer? As MySQL versions too would have changed, check out the differences between the installs.