~~NOCACHE~~
====== Vérification des affectations des écritures sur caisse association ======

<sql>
SELECT 
CONCAT("<b><a href='https://gestioncafe.reseauanais.fr/compta/bank/ligne.php?rowid=",trans.rowid,"' target='_tab' >",trans.rowid,"</a></b>") as 'Id',
 trans.datev as 'Date Valeur' ,
 (SELECT cat.label FROM llx89_bank_categ as cat WHERE class.fk_categ = cat.rowid) as'Catégorie',
 trans.label as Motif,
 FORMAT(trans.amount,2,"fr_FR") as Montant
  
FROM `llx89_bank` as trans 
LEFT JOIN `llx89_bank_class` as class on lineid = trans.rowid

WHERE fk_account = 4

</sql>


----




[[.:|Retour à la comptabilite]]