CREATE VIEW DBO.AYGRUPCARICIROTOPLAM AS (
SELECT 
COMPANYID,
  CPERIODID,
   AYSIRA,
   YIL,
  sum(FATURA) FATURA,
  SUM(IFATURA) IFATURA,
  sum(NETTOP) AS NETTOPLAM,
  ACTNO,
  ACTNAME,
  CURRCODE,
  ACTID
FROM
(SELECT 
  VE_INVOICE.COMPANYID,
  VE_INVOICE.CPERIODID,
  DATEPART(month, VE_INVOICE.TRANSDATE) AS AYSIRA,
  DATEPART(year, VE_INVOICE.TRANSDATE) AS YIL,
  sum(VE_INVOICE.CURRTOTAL) AS NETTOP,
  sum(VE_INVOICE.CURRTOTAL) FATURA,
  0 IFATURA,
  VE_INVOICE.ACTNO,
  VE_INVOICE.ACTNAME,
  VE_INVOICE.CURRCODE,
  VE_INVOICE.ACTID
FROM
  VE_INVOICE
WHERE
  VE_INVOICE.TRANSTYPE = 101
GROUP BY
  VE_INVOICE.COMPANYID,
  VE_INVOICE.CPERIODID,
  DATEPART(month, VE_INVOICE.TRANSDATE),
  DATEPART(year, VE_INVOICE.TRANSDATE),
  VE_INVOICE.ACTNO,
  VE_INVOICE.ACTNAME,
  VE_INVOICE.CURRCODE,
  VE_INVOICE.TRANSDATE,
  VE_INVOICE.ACTID


UNION 


SELECT 
  VE_INVOICE.COMPANYID,
  VE_INVOICE.CPERIODID,
  DATEPART(month, VE_INVOICE.TRANSDATE) AS AYSIRA,
  DATEPART(year, VE_INVOICE.TRANSDATE) AS YIL,
  sum(VE_INVOICE.CURRTOTAL)*-1 AS NETTOP,
  0 FATURA,
  sum(VE_INVOICE.CURRTOTAL) IFATURA,
  VE_INVOICE.ACTNO,
  VE_INVOICE.ACTNAME,
  VE_INVOICE.CURRCODE,

  VE_INVOICE.ACTID
FROM
  VE_INVOICE
WHERE
  VE_INVOICE.TRANSTYPE = 104
GROUP BY
  VE_INVOICE.COMPANYID,
  VE_INVOICE.CPERIODID,
  DATEPART(month, VE_INVOICE.TRANSDATE),
  DATEPART(year, VE_INVOICE.TRANSDATE),
  VE_INVOICE.ACTNO,
  VE_INVOICE.ACTNAME,
  VE_INVOICE.CURRCODE,
  VE_INVOICE.TRANSDATE,
  VE_INVOICE.ACTID

) Y
GROUP BY 
COMPANYID,
  CPERIODID,
   AYSIRA,
   YIL,
  ACTNO,
  ACTNAME,
  CURRCODE,
  ACTID)