1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| SELECT cf.id_commandec
, RIGHT(YEAR(cf.fdate) * 10000 + MONTH(cf.fdate) * 100 + DATEPART(ww, cf.fdate) ,6) AS [Date Facturation]
, co.libelle
, cfl.quantite AS [nombre de lignes]
, SUM(ROUND((cfl.montant / cfl.quantite), 2)) AS ca_ttc
, SUM(ROUND((((cfl.montant / cfl.quantite) / (1 + cfl.montant_tva / 100))), 2)) AS ca_ht
FROM Client_operation co
INNER JOIN
client_facture cf
ON cf.id_commandec = co.id_document
INNER JOIN
client_facture_ligne cfl
ON cfl.id_facturec = cf.id_facturec
INNER JOIN
produit p
ON p.id_produit = cfl.id_produit
WHERE co.type_document = 'c'
AND co.id_type_reglement = 25
AND cf.id_structure = 8
AND p.id_produit > 10000
AND p.id_produit <> 5190962
GROUP BY cf.id_commandec
, RIGHT(YEAR(cf.fdate) * 10000 + MONTH(cf.fdate) * 100 + DATEPART(ww, cf.fdate) ,6) AS [Date Facturation]
, co.libelle
, cfl.quantite AS [nombre de lignes]
ORDER BY cf.fdate
, p.code_reference |
Partager