`prep_amount` double NOT NULL DEFAULT '0',

The default for double type field may not be accepted as 0 in your MySQL version or needs to be 0.0. and / or the initialisation to be:

$this->prep_amount = 0.0;

I am not familiar with this code, but it appears that the extension's read function fails to call update_payments function, unlike the base code.  So prep_amount is never set.  This is a problem with the code.

If you don't care about the prep_amount feature, you could initialize it to zero in the constructor (__construct function in /var/www/nts/modules/import_transactions/includes/import_sales_cart_class.inc):

$this->prep_amount = 0;

[12-Jan-2022 03:01:40 Europe/Berlin] <b>DATABASE ERROR :</b> <br>At file /var/www/nts/modules/import_transactions/includes/import_sales_cart_class.inc:321:<br>order Cannot be Added<br>error code : 1366<br>error message : Incorrect double value: '' for column `TECH360Live`.`0_sales_orders`.`prep_amount` at row 1<br>sql that failed was :

INSERT INTO 0_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
        order_type, ship_via, deliver_to, delivery_address, contact_phone,
        freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount)
        VALUES ('3','0','1', '30','1', '113/2021','auto','','2021-10-05', '1', '1','Tropical Garments','', '', '0', '1', '2021-10-05','4','61.5','')

<br><br><br>

any help would be of great assistance.

This is often easier than trying to repair the damage.  Afterwards, you would then recreate the transactions correctly.

I didn't use Journal Entries as I should have done (I was being lazy and thinking that it would save having to duplicate every line in the original file without considering that it would not create the bank account entries.) I think it is expected behaviour.

There are no missing entries in gl_trans - all correct. But there are only bank account entries in bank_trans for one of the two bank accounts.

So I am trying to figure out what I need to do to correct my error, rather than report or fix a bug.

I don't use FA on a regular basis, so every year I have to remember/re-learn all my previous errors, some aspects are as intuitive as I expect (I am not an accountant)

Can you post the the input file, or at least the relevant part, that caused the missing g/l entries?  If you do, and I can confirm the bug, I may be able to fix it.

I also recommend commenting out:
// error_reporting(E_ALL);

Oddly enough, errors and notices are not shown otherwise.

My bank transactions include transfers between bank accounts.  Is there any way to make this work with Import Transactions?

I just made the stupid mistake of trying to do the above with import transactions...

So now I have a situation where the gl_trans entries are correct for both bank accounts, but the entries in only one of the bank accounts are correct (gl and bank entries match) but for the other account the gl entries are missing from the bank account....

Any suggestions how I can manually recover, e.g. could I just add the required entries into the bank_trans table?

Quick Entries is an integral part of FA and not an external module.

000001/99,03/28/1998,"Bank Account 1:Funds Transfer",-500.00,3300,,,,,,
000001/99,03/28/1998,"Bank Account 2:Funds Transfer",500.00,1060,,,,,,