View attachment 4543 [Collection: Jenny Voucher] Type : Vouchers ;: VoucherType ;Child of : $$VchTypePayment Belongs to : Yes Fetch : date,VoucherTypeName,PartyLedgerName,Amount,PAYHEADNAME,Allledger Entries,Voucher Number,VoucherNumber,Reference,ledgername,amount,allledger Entries Filter : NOTIsOptionalVoucher,WEXPFilter [Collection:jennyPartyWise] Source Collection : Jenny Voucher Walk : ledger Entries By : PartyNameHarryExpWEXP : $LedgerName Aggr Compute : QtyAprWEXP : Sum :If @@WEXPmonthFilterapr Then $Amount Else 0 Aggr Compute : QtyMayWEXP : Sum :If @@WEXPmonthFiltermay Then $Amount Else 0 Aggr Compute : QtyJunWEXP : Sum :If @@WEXPmonthFilterjun Then $Amount Else 0 Aggr Compute : QtyJulWEXP : Sum :If @@WEXPmonthFilterjul Then $Amount Else 0 Aggr Compute : QtyAugWEXP : Sum :If @@WEXPmonthFilteraug Then $Amount Else 0 Aggr Compute : QtySepWEXP : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFiltersep Then $Amount Else 0 Aggr Compute : WEXPOctQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFilteroct Then $Amount Else 0 Aggr Compute : WEXPnovQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFilternov Then $Amount Else 0 Aggr Compute : WEXPdecQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFilterdec Then $Amount Else 0 Aggr Compute : WEXPjanQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFilterjan Then $Amount Else 0 Aggr Compute : WEXPfebQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFilterfeb Then $Amount Else 0 Aggr Compute : WEXPmarQty : Sum :If @@VoucherFilterExpWEXP and @@WEXPmonthFiltermar Then $Amount Else 0 Aggr Compute : TotAmount : Sum :If @@VoucherFilterExpWEXP Then $Amount Else 0 Sort : Default : $PartyNameHarryExpWEXP [System : Formula] iexpWEXP : $$IsLedOfGrp:$PartyNameHarryExpWEXP:$$GroupDuties or $$IsLedOfGrp:$PartyNameHarryExpWEXP:$$GroupDeposits iexpWEXPl : $$IsLedOfGrp:$name:$$GroupDuties or $$IsLedOfGrp:$name:$$GroupDuties VoucherFilterExpWEXP : $$IsJournal:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName ;$$IsPayment:$VoucherTypeName or $$IsJournal:$VoucherTypeName or $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName WEXPmonthFilterapr : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4 WEXPmonthFiltermay : $$MonthOfDate:$Date>=5 and $$MonthOfDate:$Date<=5 WEXPmonthFilterjun : $$MonthOfDate:$Date>=6 and $$MonthOfDate:$Date<=6 WEXPmonthFilterjul : $$MonthOfDate:$Date>=7 and $$MonthOfDate:$Date<=7 WEXPmonthFilteraug : $$MonthOfDate:$Date>=8 and $$MonthOfDate:$Date<=8 WEXPmonthFiltersep : $$MonthOfDate:$Date>=9 and $$MonthOfDate:$Date<=9 WEXPmonthFilteroct : $$MonthOfDate:$Date>=10 and $$MonthOfDate:$Date<=10 WEXPmonthFilternov : $$MonthOfDate:$Date>=11 and $$MonthOfDate:$Date<=11 WEXPmonthFilterdec : $$MonthOfDate:$Date>=12 and $$MonthOfDate:$Date<=12 WEXPmonthFilterjan : $$MonthOfDate:$Date>=1 and $$MonthOfDate:$Date<=1 WEXPmonthFilterfeb : $$MonthOfDate:$Date>=2 and $$MonthOfDate:$Date<=2 WEXPmonthFiltermar : $$MonthOfDate:$Date>=3 and $$MonthOfDate:$Date<=3
try this instead $$FromValue:##SVFromDate:$$ToValue:##SVToDate:$BSDebits:Ledger:$Name and $$FromValue:##SVFromDate:$$ToValue:##SVToDate:$BSCredits:Ledger:$Name