Dear Developers, Please help me, i want below collection code to load fast, please guide me if there is any other workaround to get those values, thanks in advance [Collection : GSTPaidCollection] Type : Vouchers : Voucher Type Child Of : $$VchTypePayment Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date, StatPaymentType, CGSTLiability Fetch : MasterID, IsOptional, IsCancelled, IsDeleted, GSTAdvLiabPlaceOfSupply,PlaceOfSupply,TaxAdjustment,LedStateName, + Date, VoucherTypeName, VoucherNumber, PartyLedgerName, Amount, Narration, TaxPayPeriodFromDate, TaxPayPeriodToDate, GSTAdditionalDetails, + AdjFromDate, AdjToDate, GSTITCDocumentType, LedgerType, GSTPymtModeofDeposit, GSTCPINNumber, GSTBankName Filter : GSTPaymentReport, GSTPayPeriod, TaxPeriodFilter Filter : NOTIsOptionalVoucher ;Keep Source : (). Compute : IGSTPaid : $$FilterAmtTotal:AllLedgerEntries:IGSTPayableFilter:$Amount Compute : CGSTPaid : $$FilterAmtTotal:AllLedgerEntries:CGSTPayableFilter:$Amount Compute : SGSTPaid : $$FilterAmtTotal:AllLedgerEntries:SGSTPayableFilter:$Amount Compute : GSTPaid : $IGSTPaid + $CGSTPaid + $SGSTPaid Compute : IGSTCash : $$FilterAmtTotal:AllLedgerEntries:IGSTCashFilter:$Amount Compute : CGSTCash : $$FilterAmtTotal:AllLedgerEntries:CGSTCashFilter:$Amount Compute : SGSTCash : $$FilterAmtTotal:AllLedgerEntries:SGSTCashFilter:$Amount Compute : GSTCash : $IGSTCash + $CGSTCash + $SGSTCash Compute : LCGSTPaid : $$FilterAmtTotal:AllLedgerEntries:LateFeePaidFilter:$Amount / 2 Compute : LSGSTPaid : $$FilterAmtTotal:AllLedgerEntries:LateFeePaidFilter:$Amount / 2 Compute : LGSTPaid : $LCGSTPaid + $LSGSTPaid Compute : GSTIPaid : $$FilterAmtTotal:AllLedgerEntries:InterestPaidFilter:$Amount Compute : LCGSTCash : $$FilterAmtTotal:AllLedgerEntries:LateFeeCashFilter:$Amount / 2 Compute : LSGSTCash : $$FilterAmtTotal:AllLedgerEntries:LateFeeCashFilter:$Amount / 2 Compute : LGSTCash : $LCGSTCash + $LSGSTCash Compute : LateFeeDate : $$FilterValue:$Date:AllLedgerEntries:1:LateFeePaidFilter Compute : CashLedgerDate : $$FilterValue:$Date:AllLedgerEntries:1:GSTPaidFilter
The more and more FILTERAmT or FILTERVALUE you use the slower it will become ..... The trick is to break down all values in their respective COLLECTION and then call for it in the main collection.