Bonjour,
Ma version de Dolibar 10.0.2.
Lors d’un export vres comptabilite, journal des ventes, j’ai l’erreur suivante :
2019-10-14 13:23:11 ERR 109.79.29.239 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column ‹ f.facnumber › in ‹ field list ›
2019-10-14 13:23:11 ERR 109.79.29.239 GPCsolutions\AccountingExport\AccountingExport SQL error: Unknown column ‹ f.facnumber › in ‹ field list ›
Sur la requete :
sql=SELECT DATE_FORMAT(f.datef, ‹ %d/%m/%Y ›) as date, f.facnumber, f.datef as sortdate, s.code_compta, p.accountancy_code_sell, fd.product_type, s.nom, fd.description, fd.total_ht, fd.total_tva as tva, fd.tva_tx, f.total_ttc as total_fact, p.label FROM llx_facturedet AS fd LEFT JOIN llx_product p ON p.rowid = fd.fk_product JOIN llx_facture f ON f.rowid = fd.fk_facture JOIN llx_societe s ON s.rowid = f.fk_soc WHERE f.fk_statut > ‹ 0 › AND f.entity = ‹ 1 › AND f.datef >= ‹ 2019-09-01 00:00:00 › AND f.datef <= ‹ 2019-09-30 23:59:59 › AND fd.special_code = 0 ORDER BY sortdate
Quel est le problème?
Merci
Bien à vous
Didier