AcumaticaSQLQueriesAndFunctions/UnAllocatedReleasedExpenses.sql

IF OBJECT_ID ('dbo.UnAllocatedReleasedExpenses','V') IS NOT NULL DROP VIEW dbo.UnAllocatedReleasedExpenses
GO 
CREATE VIEW dbo.UnAllocatedReleasedExpenses
AS
SELECT 
    ROW_NUMBER() OVER (
        ORDER BY 
            p.CompanyID, 
            p.ProjectID
    ) AS RowKey,
 p.CompanyID as CompanyID, p.ProjectID, SUM(p.Amount) as amount
 from PMTran p 
 join PMAccountGroup pg on pg.CompanyID = p.CompanyID and p.AccountGroupID = pg.GroupID 
 where pg.IsExpense = 1
 and p.Released =1
 and p.Allocated =0
 group by p.CompanyID,
          p.ProjectID