Bonsoir Gaëtan,
ci après l’extrait du log dolibarr juste avant le rollback :
2020-03-11 20:09:01 DEBUG 146.0.189.0 sql=INSERT INTO llx_accounting_bookkeeping (doc_date, date_lim_reglement, doc_type, doc_ref, fk_doc, fk_docdet, thirdparty_code, subledger_account, subledger_label, numero_compte, label_compte, label_operation, debit, credit, montant, sens, fk_user_author, date_creation, code_journal, journal_label, piece_num, entity) VALUES (‹ 2019-09-01 00:00:00 ›, NULL,‹ expense_report ›,‹ ER1909-0011 ›,36,971,’’,’’,’’,‹ 6256 ›,‹ Missions ›,‹ Missions ›,36.2,0,36.2,‹ D ›,‹ 1 ›,‹ 2020-03-11 20:09:01 ›,‹ ER ›,‹ Expense report journal ›,1061, 1)
2020-03-11 20:09:01 DEBUG 146.0.189.0 AccountingAccount::fetch sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM llx_accounting_account as a LEFT JOIN llx_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = ‹ 625 › AND a.entity = 1 AND a.fk_pcg_version IN (SELECT pcg_version FROM llx_accounting_system WHERE rowid=6)
2020-03-11 20:09:01 DEBUG 146.0.189.0 sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM llx_accounting_account as a LEFT JOIN llx_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = ‹ 625 › AND a.entity = 1 AND a.fk_pcg_version IN (SELECT pcg_version FROM llx_accounting_system WHERE rowid=6)
2020-03-11 20:09:01 DEBUG 146.0.189.0 BookKeeping::create
2020-03-11 20:09:01 DEBUG 146.0.189.0 sql=SELECT count(*) as nb FROM llx_accounting_bookkeeping WHERE doc_type = ‹ expense_report › AND fk_doc = 36 AND numero_compte = ‹ 625 › AND label_operation = ‹ Déplacements , missions et réceptions › AND entity IN (1)
2020-03-11 20:09:01 DEBUG 146.0.189.0 BookKeeping:: create sqlnum=SELECT piece_num FROM llx_accounting_bookkeeping WHERE doc_type = ‹ expense_report › AND fk_docdet = 971 AND doc_ref = ‹ ER1909-0011 › AND entity IN (1)
2020-03-11 20:09:01 DEBUG 146.0.189.0 sql=SELECT piece_num FROM llx_accounting_bookkeeping WHERE doc_type = ‹ expense_report › AND fk_docdet = 971 AND doc_ref = ‹ ER1909-0011 › AND entity IN (1)
2020-03-11 20:09:01 DEBUG 146.0.189.0 BookKeeping:: create this->piece_num=1061
2020-03-11 20:09:01 DEBUG 146.0.189.0 BookKeeping:: create this->piece_num=1061
2020-03-11 20:09:01 DEBUG 146.0.189.0 BookKeeping:: create sql=INSERT INTO llx_accounting_bookkeeping (doc_date, date_lim_reglement, doc_type, doc_ref, fk_doc, fk_docdet, thirdparty_code, subledger_account, subledger_label, numero_compte, label_compte, label_operation, debit, credit, montant, sens, fk_user_author, date_creation, code_journal, journal_label, piece_num, entity) VALUES (‹ 2019-09-01 00:00:00 ›, NULL,‹ expense_report ›,‹ ER1909-0011 ›,36,971,’’,’’,’’,‹ 625 ›,‹ Déplacements , missions et réceptions ›,‹ Déplacements , missions et réceptions ›,0,-15.61,-15.61,‹ C ›,‹ 1 ›,‹ 2020-03-11 20:09:01 ›,‹ ER ›,‹ Expense report journal ›,1061, 1)
2020-03-11 20:09:01 DEBUG 146.0.189.0 sql=INSERT INTO llx_accounting_bookkeeping (doc_date, date_lim_reglement, doc_type, doc_ref, fk_doc, fk_docdet, thirdparty_code, subledger_account, subledger_label, numero_compte, label_compte, label_operation, debit, credit, montant, sens, fk_user_author, date_creation, code_journal, journal_label, piece_num, entity) VALUES (‹ 2019-09-01 00:00:00 ›, NULL,‹ expense_report ›,‹ ER1909-0011 ›,36,971,’’,’’,’’,‹ 625 ›,‹ Déplacements , missions et réceptions ›,‹ Déplacements , missions et réceptions ›,0,-15.61,-15.61,‹ C ›,‹ 1 ›,‹ 2020-03-11 20:09:01 ›,‹ ER ›,‹ Expense report journal ›,1061, 1)
**2020-03-11 20:09:01 DEBUG 146.0.189.0 **
ROLLBACK Transaction
De ce que je comprend, l’inscription d’un negatif au credit du compte pose pb…