Collection Help

Discussion in 'Tally Developer' started by Sohail Khan, Feb 23, 2023.

    
  1. Sohail Khan

    Sohail Khan Member


    Is there a way I can make collection of only those vouchers Specified in $PartyLedgerName=#EiConsignee, because currently I am making collection of all the sales voucher and then filtering it which makes the Data Loading a little slow.

    [Collection:VoucherTypeSales_SRC]
    Type : Vouchers: VoucherType
    Childof : $$VchTypeSales
    BelongsTo : Yes
    Filter : IsNotOptionalOrCancelled

    [Collection: NewMobileTable]
    Source Collection : VoucherTypeSales_SRC
    Title : "List"
    Fetch : ContactDtls, ContactPersonName
    Format : $ContactDtls, 20
    Filter : MobileFilter

    [System:Formula]
    MobileFilter: $ContactPersonName=#ContPersonName And $PartyLedgerName=#EiConsignee
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The answer is in your query itself.

    Make a collection of Ledger and filter it on Voucher type.
     


  3. Sohail Khan

    Sohail Khan Member


    Thank You Sir. Now its fast.
     


  4. Sohail Khan

    Sohail Khan Member


    Hello Sir,
    I cannot get Delivery Note Vouchers when I am Making Collection of Vouchers : Ledger.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    make another collection of delivery notes...... and fetch whatever values you need.
    use this as a SOURCE in your main collection.
     


Share This Page