Help me in a collection

Discussion in 'Tally Developer' started by Jenny, Feb 19, 2019.

    
  1. Jenny

    Jenny Active Member


    Untitled.jpg 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
     
    Last edited: Feb 19, 2019


  2. balajimg

    balajimg Active Member


    try this instead
    $$FromValue:##SVFromDate:$$ToValue:##SVToDate:$BSDebits:Ledger:$Name
    and
    $$FromValue:##SVFromDate:$$ToValue:##SVToDate:$BSCredits:Ledger:$Name
     


Share This Page