Filter in Voucher Collection

Discussion in 'Tally.ERP 9' started by silpa dravid, Jan 15, 2021.

    
  1. silpa dravid

    silpa dravid Member


    Dear Experts,

    Please help me to make a formula for filter in Collection.
    I want purchase amount done from Purchase and Journal vouchers. i tried these collection but not working.

    [Collection: PurVoucher]

    Type : Vouchers : VoucherType

    Child of : $$VchTypePurchase
    ;Child of : $$AccountingVch ;$$VchTypeJournal or $$VchTypePurchase
    Belongs to : Yes
    Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount

    if Child of : $$VchTypePurchase is done .purchase done from purchase voucher is only working
    if Child of : $$VchTypeJournal is done .purchase done from Journal voucher is only working
    I WANT BOTH VOUCHER
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Collection: PurVoucher]
    Type : Vouchers
    Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount
    Filter : yourfilter

    [system : formula]
    yourfilter : $$IsPurchase:$VoucherTypeName OR $$IsJournal:$VoucherTypeName
     
    silpa dravid and Jaydeep Shah like this.


  3. silpa dravid

    silpa dravid Member


    thank you amit sir it worked
     


  4. silpa dravid

    silpa dravid Member


    Amit sir
    how to make collection for closing Balance in Dr Cr Format. i am getting the Closing balance but not in Cr Dr format. i tried with code in Field and Collection
    but not coming
    [Field:purClosing1]
    Use :Amount Field ;Short Name Field
    Set as :$ClosingBalance
    ;Set as :If $$IsDr:$_ClosingBalance then $$String:$_ClosingBalance + " Dr" else $$String:$_ClosingBalance + " Cr"
    Type : Amount
    Width : 12
    Align : Right
    ;Format : "No Zero, Symbol," + ##ShowForex
    ;Format : "DRCR"
    ;Color : if $$IsDebit:$ClosingBalance then "Blue" Else "Red"
    Space Left : 2 mms
    Border : Thin Right

    [Collection:purPartyWise1]
    Source Collection : PurVoucher1
    Walk : Inventory Entries
    ;Walk : Ledger Entries
    By : PartyName : $PartyLedgerName
    By : ClosingBalance:$ClosingBalance:Ledger:$PartyLedgerName
    Aggr Compute: TotAmount : Sum : $Amount
    Sort : Default : $PartyName
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field : PurClosing1]
    Use :Amount Field
    Set as :$ClosingBalance
    Width : 12
    Align : Right
    Format : "DRCR"
    Space Left : 2 mms
    Border : Thin Right
     
    silpa dravid likes this.


  6. silpa dravid

    silpa dravid Member


    thank you amit sir for your reply but its not working. i want ledger closing balance of that party whose closing balnce is if in Dr it should show Dr else Cr
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Source Collection : PurVoucher1
    Walk : LedgerEntries, Inventory Entries
    By : PartyName : $PartyLedgerName
    Compute : ClosingBalance : $ClosingBalance:Ledger:$PartyLedgerName
    Aggr Compute: TotAmount : Sum : $Amount
    Sort : Default : $PartyName
     
    silpa dravid likes this.


  8. silpa dravid

    silpa dravid Member


    thank you Amit sir. Now its working. You are SUPERAMAN IN TDL
     


  9. svn

    svn Member




    [#Collection : VCH Stock Item Extract]
    Add : Subtitle : "My CL.QTY as on voucher date "
    Add :Format : $$ToValue:$Date:$Closingbalance:StockItem:$StockItemName,10
    ;;Set As:$$ToValue:$Date:$Closingbalance:StockItem:$StockItemName
    Dear admin sir,

    Please Rectify above problem.

    Advace Thank you.
     
    Last edited: Jun 28, 2021


  10. Marina Colors

    Marina Colors Member


    Dear Amit Sir,

    How to get the sort list by "ClosingBalance" combined with "LedgerName"....in Value Descending order and Name in Alphabetical...

    Please
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Sort : @@Default : - $ClosingBalance, $Name
     


  12. Marina Colors

    Marina Colors Member


    Thank you Amit jee...
     


  13. Marina Colors

    Marina Colors Member


    Dear Amit Sir,

    I tried the following option but not getting the result. I want to sort first by Closingbalance followed by Parent and then followed by Ledger name...that is Highest Balance--->Parent--->LedgerName...

    Please suggest correction

    [Collection : GR SDC Groups]
    Type : Ledger
    ;Childof : $$GroupSundryDebtors:$$GroupSundryCreditors
    Childof : $$GroupSundryDebtors
    Belongs To : Yes
    ;Sort : Default:$ClosingBalance:$Parent, $Name,;$Parent;$Closingbalance
    Sort : @@Default:$ClosingBalance,$Parent,;$Parent;$Closingbalance
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Make Collection of LEDGERS of Sundry Debtors
    Compute -- Closing, parent and ledger name in this collection.

    Make another collection -- Use above collection as SOURCE
    SORT in this collection..........
     


Share This Page