Ledger Collection in sales voucher

Discussion in 'Requests' started by vinayprasad.Dubai, Sep 4, 2021.

    

  1. Dear Team,

    Please help me to include $$Group:CurrentAsset in the party ledger Collection in the sales invoice
     


  2. Himanshu-2002

    Himanshu-2002 Active Member


    $TBalClosing:Group:"Current Asset"


    You can fetch data like this from group
     



  3. Code:
    [#Field: EI Consignee]
        Option : Cust_EIConsignee : @@IsSales OR @@IsSalesOrder OR @@IsPurchase or @@IsPurcOrder
       
    [#Field : Cust_EIConsignee]
        Delete : Table
        Add : Table : Invoice Ledgers Extract2
    
    [Collection: Invoice Ledgers Extract2]
        Use : ExtractAlias Collection
        Source Collection : LedgersVch Src
        Title : $$LocaleString:"Vinay Collection Accounts"
    
        Parm Var : GroupCash : String : $$GroupCash
        ;parm Var : GroupBank : String : $$GroupBank
        Parm Var : GroupBankOD : String : $$GroupBankOD
        Parm Var : GroupSundryDebtors : String : $$GroupSundryDebtors
        Parm Var : GroupSundryCreditors : String : $$GroupSundryCreditors
        Parm Var : GroupBranches : String : $$GroupBranches
        Parm Var : Groupcurrentassets : String: $$GroupCurrentAssets
    
        Fetch : Name, Parent, ReserveName, InactiveLed
        ;Filter : ClassFilter, InactiveLedFilter,IsCurrentAssestLedgerVchRE
        Keep Source : ().
        Client Only : Yes
        Compute : LedInactive : $InactiveLed:Ledger:$Name
    
    [System : Formula]
        InactiveLedFilter : NOT $LedInactive
        InactiveItemFilter : NOT $ItemInactive
    
    [System : Formula]
        IsPartyAccountVchRE1        = @@IsCashBankAccountVchRE OR $ReserveName = ##GroupSundryDebtors OR $ReserveName = ##GroupSundryCreditors OR $ReserveName = ##GroupBranches
    
    

    I tried it my self for so many hours and finally i did this......

    nothing is impossible only we need is to put your efforts and patience.
     


  4. Johar

    Johar Member


    Collection is wrong try this

    [#Collection: Party Ledgers]
     


Share This Page