public virtual IEnumerable paymentTrans() { ExternalTransactionFilter filter = this.Filter.Current; if (filter != null) { PXSelectBase <ExternalTransactionExt> select = new PXSelectJoin <ExternalTransactionExt, LeftJoin <Customer, On <Customer.bAccountID, Equal <ExternalTransactionExt.bAccountID> > >, Where <ExternalTransactionExt.active, Equal <True>, And <ExternalTransactionExt.refNbr, IsNotNull, And <ExternalTransactionExt.docType, In <Required <ExternalTransactionExt.docType> >, And <ExternalTransactionExt.cCProcessingStatus, In <Required <ExternalTransactionExt.cCProcessingStatus> > > > > >, OrderBy <Desc <ExternalTransactionExt.refNbr> > >(this); if (!string.IsNullOrEmpty(filter.ProcessingCenterID)) { select.WhereAnd <Where <ExternalTransactionExt.cCProcessingCenterID, Equal <Current <ExternalTransactionFilter.processingCenterID> > > >(); } string[] docTypes = new string[] { ARDocType.CashSale, ARDocType.Payment, ARDocType.Prepayment }; string[] statuses = new string[] { ExtTransactionProcStatusCode.AuthorizeHeldForReview, ExtTransactionProcStatusCode.CaptureHeldForReview }; foreach (PXResult <ExternalTransactionExt, Customer> it in select.SelectWithViewContext(new object[] { docTypes, statuses })) { yield return(it); } } yield break; }