1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT DISTINCT 'Facture' "Type de doc",T0."DocNum",T0."DocDate", T0."CardCode", T0."CardName", T2."SlpName",T6."ItmsGrpCod", T8."ItmsGrpNam",T0."DocTotal" - T0."VatSum" "CA HT"
FROM OINV T0
INNER JOIN OSLP T2 ON T2."SlpCode" = T0."SlpCode"
INNER JOIN INV1 T4 ON T4."DocEntry"=T0."DocEntry"
INNER JOIN OITM T6 ON T6."ItemCode"=T4."ItemCode"
INNER JOIN OITB T8 ON T8."ItmsGrpCod"=T6."ItmsGrpCod"
WHERE T0."CANCELED" = 'N' and T0."DocDate" >= '01.01.2019' and T0."DocDate" <= '31.01.2019'
GROUP BY T0."DocNum",T0."DocDate", T0."CardCode", T0."CardName", T2."SlpName",T6."ItmsGrpCod",T8."ItmsGrpNam",T0."DocTotal" - T0."VatSum"
UNION
SELECT DISTINCT 'Avoir' "Type de doc", T1."DocNum", T1."DocDate", T1."CardCode", T1."CardName",T3."SlpName",T7."ItmsGrpCod",T9."ItmsGrpNam",-T1."DocTotal" - T1."VatSum" "CA HT"
FROM ORIN T1
INNER JOIN OSLP T3 ON T3."SlpCode"=T1."SlpCode"
INNER JOIN RIN1 T5 ON T5."DocEntry"=T1."DocEntry"
INNER JOIN OITM T7 ON T7."ItemCode"=T5."ItemCode"
INNER JOIN OITB T9 ON T9."ItmsGrpCod"=T7."ItmsGrpCod"
WHERE T1."CANCELED" = 'N' and T1."DocDate" >= '01.01.2019' and T1."DocDate" <= '31.01.2019'
GROUP BY T1."DocNum", T1."DocDate", T1."CardCode", T1."CardName",T3."SlpName",T7."ItmsGrpCod",T9."ItmsGrpNam",-T1."DocTotal" - T1."VatSum"
ORDER BY T0."DocDate" |
Partager