Buenas tardes.
A ver necesito mostrar por cada factura los tipos de iva que contenga, por lo general solo tienen uno pero existen facturas que llevan unas lineas al 21% y otras al 4% pues lo que necesito mostrar en mi reporte es una agrupación por tipo de iva. El reporte que genere en su día solo me muestra el maximo iva de la factura.
(SELECT
DISTINCT T0."NumAtCard" AS "Factura",
T0."TransId" AS "Asiento",
T0."DocDate" AS "Fecha Asiento",
T0."TaxDate" AS "Fecha Factura",
(SELECT
MAX(IFNULL(T1."ShipDate",
T0."TaxDate"))
FROM PCH1 T1
WHERE T1."DocEntry" = T0."DocEntry") AS "Fecha Operación",
T0."CardCode",
T0."CardName",
T2."LicTradNum" AS "Cif",
ROUND (((T0."DocTotal"+T0."WTSum") - (T0."VatSum") - (T0."TotalExpns")),
2,
ROUND_FLOOR) AS "Base Imponible",
(SELECT
T3."Rate"
FROM OVTG T3
WHERE T3."Code" = (SELECT
MAX(T1."VatGroup")
FROM PCH1 T1
WHERE T1."DocEntry" = T0."DocEntry")) AS "% Iva",
ROUND (T0."VatSum",
2) AS "IVA",
ROUND (T0."DocTotal",
2) AS "Total"
FROM OPCH T0
INNER JOIN OCRD T2 ON T0."CardCode" = T2."CardCode"
WHERE T0."DocNum"='numero de la factura'
GROUP BY T0."DocDate",
T0."DocEntry",
T0."TaxDate",
T0."TransId",
T0."NumAtCard",
T0."CardCode",
T0."CardName",
T2."LicTradNum",
T0."WTSum",
T0."DocTotal",
T0."VatSum",
T0."TotalExpns"
ORDER BY T0."TransId" ASC)