"By", "Compute", Aggr Compute" Attributes are not working in Group Company Collection

Discussion in 'Tally Developer' started by Arun Prasath, Jan 7, 2021.

    
  1. Arun Prasath

    Arun Prasath Member


    In the group company collection by, compute, Aggr compute attributes are not working. is there any workaround to achieve the same in the company collection?

    Experts pls see the below collection and help me to resolve this issue.

    [Collection: MULTICOMP TotalSales ]

    Collection : MultiCmpDBSalesColl : Company Collection

    [Collection: Company Collection]

    Type : Company
    Fetch : Name


    [Collection: MultiCmpDBSalesColl]

    Type : Voucher
    Filter : ABSSalesInvoice
    Fetch : Date, Vouchernumber, VoucherTypeName, Amount, MasterID, PartyLedgerName, AMount

    Compute : Owner Company : $$LoopCollObj:$Name
    By : IName: $PartyLedgerName
    Aggr Compute: LedAmt : $Amount

    [System: Formula]


    ABSSalesInvoice : $$IsSales:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Where is the WALK ???

    Walk : LedgerEntries

    Also for Aggr Compute........ you forgot the action ---- SUM ........
     


  3. Arun Prasath

    Arun Prasath Member


    Sir,

    I tried with walk also. But still, it is not working.

    [Collection: MultiCmpDBSalesColl]

    Type : Voucher
    Filter : ABSSalesInvoice
    Fetch : Date, Vouchernumber, VoucherTypeName, Amount, MasterID, PartyLedgerName, AMount, LedgerEntries.*

    Compute : Owner Company : $$LoopCollObj:$Name
    Walk : LedgerEntries
    By : IName: $PartyLedgerName
    Aggr Compute: LAmt : Sum : $Amount



    If i use
    Set as : $Partyledgername it works
    if i use

    Set As : $IName it is not working
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is because you have not computed the INAME.......

    Compute INAME in your collection............ remove By ..........
     
    Jaydeep Shah likes this.


  5. Himanshu-2002

    Himanshu-2002 Active Member


    Bro Write a summary Collection instead of Computing in Same Collection

    Example:
    [Collection: VchTypeSales]
    Type: Vouchers: VoucherType
    Child of: $$VchTypeSales
    Belong to: Yes

    [Collection: Vch Type Summary Coll]
    Source Collection: VchTypeSales
    Walk: LedgerEntries
    Compute: IName: $PartyLedgerName
     
    Jaydeep Shah likes this.


Share This Page