Bonjour à tous
je cherchais à imprimer la liste de mes écitures banques… j’ai vu la posibilité avec outils/export…
et la une erreur
Expression #1 of ORDER BY clause is not in SELECT list, references column ‹ db336314_dolibarr.b.datev › which is not in SELECT list; this is incompatible with DISTINCT - sql=SELECT DISTINCT ba.label as ba_label, b.dateo as b_dateo, b.label as b_label, b.num_chq as b_num_chq, b.fk_bordereau as b_fk_bordereau, -b.amount as _b_amount, b.amount as b_amount FROM (llx_bank_account as ba, llx_bank as b) LEFT JOIN llx_bank_url as bu ON (bu.fk_bank = b.rowid AND bu.type = ‹ company ›) LEFT JOIN llx_societe as s ON bu.url_id = s.rowid WHERE ba.rowid = b.fk_account AND ba.entity IN (1) ORDER BY b.datev, b.num_releve
Quelqu’un a-t- il une idée ??? je suis hébergé chez online.net ( pour le reste pas de souci)
Merci pour vos idées
Emmanuel
