Retrieve 2nd or third value from collection

Discussion in 'Tally Integration' started by Dhananjay Padalkar, Aug 14, 2018.

    

  1. Dear Sir,

    i am having 2 collections,
    one for master, 2nd for explode

    in explode collection if two records of item fond it doesn't walk to second record or third record & its purchase quantity

    attaching collection, can some one help me

    [Collection : VcSalesVouchersSrc]
    Type : Vouchers : VoucherType
    Child Of : $$VchTypeSales
    Belongs To : Yes
    Filter : ChkParty


    [Collection : VcSalesDetailsColl]

    Source Collection : VcSalesVouchersSrc
    Walk : Inventory Entries
    By : VoucherNumber : $VoucherNumber
    By : PartyLedgerName : $PartyLedgerName
    By : StockItemName : $StockItemName
    Fetch : StockItemName, BilledQty, Rate, Amount
    Fetch : VoucherNumber, Date, PartyLedgerName, OrderNo;, OrderDueDate
    Filter : CheckItem
    Filter : CheckOrder


    [System : Formulae]
    ChkParty : #VcPartyName = $PartyLedgerName
    CheckItem : #VcItemName = $StockItemName
    CheckOrder : #VcOrdNo = $OrderNo



    ;; Sales Order Details Collection
    [Collection : VcOrderDetailsColl]
    Source Collection : VcOrderColl
    Fetch : BilledQty, Amount, StockItemName, PartyLedgerName
    Compute : Date : $date
    Walk : InventoryEntries
    By : VoucherNumber : $VoucherNumber
    By : PartyLedgerName : $PartyLedgerName
    By : StockItemName : $StockItemName
    Sort : @@Default : $Date, $VoucherNumber, $PartyLedgerName

    ;; Sales Order Master Collection
    [Collection: VcOrderColl]
    Type : Voucher
    Fetch : PartyLedgerName, Date, VoucherNumber, Amount
    Filter : VcIsSalesOrder
    Sort : Default : $Date, $PartyLedgerName


    [System: Formula]
    VcIsSalesOrder : $$IsSalesOrder:$VoucherTypeName
    VcInvoiceFilter : $$IsSales:$VoucherTypeName
     


  2. sivam

    sivam Active Member


    Dear Dhananjay Padalkar,

    What you need to explode. Please send Part Level code. Ill guide u...
     


Share This Page