1 2 3 4 5
| SELECT '70' AS Journal, TRESOR.TRESOR_TYPE, (iif(extract(day from TRESOR.TRESOR_DATE)<10,'0'||(extract(day from TRESOR.TRESOR_DATE)),(extract(day from TRESOR.TRESOR_DATE)))||
iif(extract(month from TRESOR.TRESOR_DATE)<10,'0'||(extract(month from TRESOR.TRESOR_DATE)),(extract(month from TRESOR.TRESOR_DATE)))
||right((extract(year from TRESOR.TRESOR_DATE)),2)) AS date_, TRESOR.TRESOR_PIECE AS IdFacture, (select CLIENT.CL_NOM AS Client FROM Client RIGHT OUTER JOIN TRESOR ON Client.CL_REF = TRESOR.CL_REF),
Sum(TRESOR.TRESOR_CREDIT) AS Debit, (select Sum(FACTURE.FA_HT) FROM FACTURE RIGHT OUTER JOIN TRESOR ON TRESOR.TRESOR_PIECE = FACTURE.FA_REF)
FROM TRESOR WHERE TRESOR.TRESOR_PIECE is not null GROUP BY TRESOR.TRESOR_DATE, TRESOR.TRESOR_TYPE |
Partager