1

(154 replies, posted in Modules Add-on's)

hi trying to import transaction but get the following error

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