If mass-answering is your issue, then many satisfied users would not have been benefited here. It is not very often that anyone answers posts in the forum lately after the start of the Ukraine war. I am doing my best to keep the project alive. Checking for code updates and code commits will reveal that clearly.

Thanks to this post, I have added this solution to the wiki at the end of:
https://frontaccounting.com/fawiki/index.php?n=Main.OpeningBalances

In case my suggestions have sent you on tangents please note that all this is part of checking the possibilities as I thought might expose issues with PHP versions. The Job offers section is there for professional assistance in case the general community does not elicit a solution.

Adding a new user post was meant for another post.

I do not know of what changes PHP 8.x will have on these extensions. Also, if there is no Banking Transactions in the said list and the Journal Transactions did not suffice, the error logs with debug on should provide some pointers. If you consider my suggestions as a tangent then please seek professional assistance in the Job Offers board. Using the audit trail is another method of viewing the various SQL queries that get traversed through during it's execution.

I maintain the unofficial extensions repo as it has some third party extensions also, not officially vetted as yet to serve as a self help resource. Also I make sure that the white space in the changed code is synched with those in the core and official code base to make for ease of troubleshooting and development.

My requests on the board and its archives have not elicited any response from the original developers of the extensions till date. Nor have any users listed the way they have solved the issues at hand in the forum and in the wiki as far as I know.

Count the number of data elements and the number of headers - they appear correct herein but if there are any tabs and / or other delimiters or blank values some issues may occur based on PHP version.
This extension last worked in FA v2.4.6.
Some corrections have been made in the unofficial extensions repo for this extension.

To download this extension visit:
https://download-directory.github.io/
and paste in the github folder:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/import_transactions
and press Enter and you will get the zip file of the extension.

Use a folder compare utility like ExamDiffPro or WinDiff or WinMerge to check on the files in your official extension at FAwebroot/modules folder with that in the zip file and upload the changes in the files as listed therein.

Just checked. This has been the default since the very beginning over 15 years ago.

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.

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.

You will have to do an investigation into it in the code given earlier by putting it watch points and logging the variables.

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?

Check the Trial Balances for any discrepancy and whether Credit and Debit balances tally.

You will have to make the 2024 year as the active year and then close the 2023 year.

11

(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??

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.

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.

Check if negative values are allowed in the settings.

15

(4 replies, posted in Setup)

Check the MySQL and PHP and Apache error logs.

Increase the number of max_input_vars in the php.ini apart from max memory size.

Perplexity.ai and Duck.ai are frontends for the AI chat engine. Just type in your question briefly and you will get the answers.

Check your PM where I answered your queries.

19

(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.

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.

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.

Check if you find something in red in such an invoice when the amount is reached.

Ask in the Job offers board.

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.

25

(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);
                }