Collection

Discussion in 'Tally Developer' started by MithunN, Jun 28, 2019.

    
  1. MithunN

    MithunN Member


    i have some doubts in My collection can any one tell how to clear that doubt.
    i have written one collection like this,in my sales voucher it contains sales ledger,duties & Tax Ledgers and Inventory as well. by using one collection i have to get all the data is this possible.please reply as soon as possible.

    [Collection : SalesVchTypeColl]

    Type : Vouchers:VoucherType
    Child Of : $$VchTypeSales
    Belongs To : Yes
    Fetch : Date,VoucherNumber,VoucherType

    [Collection : SalesInvColl]

    Source Collection : SalesVchTypeColl
    Walk : AllInventory Entries, AccountingAllocations
    Fetch : PartyLedgerName,StockItemName,LedgerName,VoucherNumber,BilledQty,Rate,Amount,Date,Reference,Narration
    Compute : PartyName :$PartyLedgerName
    By : VchrNum :$VoucherNumber
    By : StkItmName :$StockItemName
    Compute : AccLedgr :$LedgerName
    Aggr Compute : StkQty :Sum:$BilledQty
    Aggr Compute : StkRate :Sum:$Rate
    Aggr Compute : StkAmnt :Sum:$Amount
    Compute : StkUom :$$LocaleString:$Rate
    Compute : SalsNartion :$Narration
     


  2. balajimg

    balajimg Active Member


    depends on which all data you want to display in report
     


  3. MithunN

    MithunN Member


    Inventory Details i.e StockItemName , Rate,Qty,Amount,Sales Ledger used for Stock Item and Duties & Tax Ledgers used in SalesVoucher
     


  4. balajimg

    balajimg Active Member


    voucher -wise ???
     


  5. MithunN

    MithunN Member


    yes sir
     


  6. balajimg

    balajimg Active Member


    [Collection : SalesInvColl]

    Source Collection : SalesVchTypeColl
    Walk : AllInventory Entries, AccountingAllocations
    ;;Fetch : PartyLedgerName,StockItemName,LedgerName,VoucherNumber,BilledQty,Rate,Amount,Date,Reference,Narration
    By : VchrNum :$VoucherNumber
    By : StkItmName :$StockItemName
    Compute : PartyName : $$Owner:$$Owner:$PartyLedgerName
    Compute : AccLedgr :$LedgerName
    Aggr Compute : StkQty :Sum:$$owner:$BilledQty
    Aggr Compute : StkRate :Sum:$$Owner:$Rate
    Aggr Compute : StkAmnt :Sum:$$Owner:$Amount
    Compute : StkUom :$$LocaleString:$BaseUnits:StockItem:$$Owner:$StockItemName
    Compute : SalsNartion :$$Owner:$$Owner:$Narration
     


  7. MithunN

    MithunN Member


    In This collection we won't get the Tax Ledgers (Duties & Taxes).
    i need tax ledgers also in the report sir how can i get that one
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also....
    Walk : All Ledger Entries
    By : LedName : $LedgerName

    then conditionally ...Aggr Compute if ledger belongs to Duties.............
     


Share This Page