public IEnumerable detailsView() { List <object> result = new List <object>(); var currentSearchPeriod = ((LumINItemCostFilter)this.Caches[typeof(LumINItemCostFilter)].Current)?.FinPeriodID; if (currentSearchPeriod != null) { var pars = new List <PXSPParameter>(); PXSPParameter period = new PXSPInParameter("@period", PXDbType.Int, currentSearchPeriod); PXSPParameter companyID = new PXSPInParameter("@companyID", PXDbType.Int, PX.Data.Update.PXInstanceHelper.CurrentCompany); pars.Add(period); pars.Add(companyID); using (new PXConnectionScope()) { using (PXTransactionScope ts = new PXTransactionScope()) { PXDatabase.Execute("SP_GenerateLumINItemCostHist", pars.ToArray()); ts.Complete(); } } PXView select = new PXView(this, true, DetailsView.View.BqlSelect); int totalrow = 0; int startrow = PXView.StartRow; result = select.Select(PXView.Currents, PXView.Parameters, PXView.Searches, PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startrow, PXView.MaximumRows, ref totalrow); PXView.StartRow = 0; return(result); } return(result); }