1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to get Ledger Name and Parents in ODBC

Discussion in 'Free Source Codes' started by bhavin, Jul 6, 2023.

    
Tags:
  1. bhavin

    bhavin New Member


    Please help me to get Ledger Name and Parents in billow code to fetch data in Excel via ODBC

    [Collection: BillWiseOutstanding]
    Type : Bills
    Is ODBC Table : YEs
     
    bhavin, Jul 6, 2023
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Fetch : Name, Parent
     
    Amit Kamdar, Jul 6, 2023
    #2


  3. Sai Vineeth

    Sai Vineeth Active Member


    Bill's parent is Ledger Name,
    So, if you want Ledger Name and group of Ledger from Bill
    compute in below way
    Compute : LedgerName:$Parent
    Compute : GroupName:$Parent:Ledger:$Parent
     
    Sai Vineeth, Jul 6, 2023
    #3
    Sanjeev S likes this.


  4. bhavin

    bhavin New Member


    Thanks a lot it's working fine
     
    bhavin, Jul 6, 2023
    #4
    Sai Vineeth likes this.


Share This Page