Last Year Closing Balance for the Brand ( Stock ) Value

  //Last year CLosing Balance
        select _BrandWiseStockValues
            where _BrandWiseStockValues.StockDate == LastYearClosing && _BrandWiseStockValues.BrandName == brandMasterTable.Brand;

        if(_BrandWiseStockValues)
        {
            globalTable.LastYrDate              = LastYearClosing;
            globalTable.LastYearClosingBalance  = _BrandWiseStockValues.StockAmount;
        }
        else
        {
             select crossCompany InventTable
                GROUP BY InventTable.ItemType, EcoResStorageDimensionGroupItem.StorageDimensionGroup, InventTable.OGSBrand
                where inventTable.ItemType != ItemType::Service && inventTable.OGSBrand == brandMasterTable.Brand
            OUTER JOIN EcoResStorageDimensionGroupItem
                where InventTable.ItemId == EcoResStorageDimensionGroupItem.ItemId && InventTable.dataAreaId == EcoResStorageDimensionGroupItem.ItemDataAreaId
            JOIN SUM(Qty), SUM(Amount) FROM InventValueReportView
                where InventTable.ItemId == InventValueReportView.ItemId && InventValueReportView.InventTransPostingType == InventTransPostingType::Financial
                && InventValueReportView.TransDate > LastYearClosing && InventValueReportView.TransDate <= _todate
            JOIN InventDim
                where InventValueReportView.InventDimId == InventDim.inventDimId;
            {
                globalTable.LastYearClosingBalance        += InventValueReportView.Amount * -1;
                globalTable.LastYrDate                      = LastYearClosing;
            }

            if(globalTable.LastYearClosingBalance)
            {
                BrandWiseStockValues.clear();
                BrandWiseStockValues.BrandName = brandMasterTable.Brand;
                BrandWiseStockValues.StockDate = LastYearClosing;
                BrandWiseStockValues.StockAmount = globalTable.LastYearClosingBalance;
                BrandWiseStockValues.insert();
            }
        }