Expend information in ledger table

Discussion in 'Free Source Codes' started by sashvat, May 5, 2018.

    
  1. sashvat

    sashvat New Member


    ;;Expend information in ledger table
    [#Collection: List of ledgers]
    Use : Alias Collection
    Title : $$LocaleString:"List of ledgers"
    Type : ledger
    Fetch : Name
    Report : ledger
    Variable : Sledger
    Trigger : Sledger
    IsODBCTable : Yes
    Delete : Format
    Add : Format : $Name,100.5
    Add : SubTitle : $$LocaleString:"Ledger Name","DOC","Area","Group","Telephone","Mobile","O Bal","CL Bal"
    Add :Format :$CreationDate
    Fetch :CreationDate

    Add :Format :$areawise
    Fetch :areawise
    Add :Format :$Parent
    Fetch :parent

    Add :Format :$Ledgerphone
    Fetch :Ledgerphone
    Add :Format :$LedgerMobile
    Fetch :LedgerMobil
    Add :Format :$salerate
    Fetch :salerate
    Add :Format :$ClosingBalance
    Fetch :ClosingBalance



    ===================================================================================================================
     
    psr likes this.


  2. birender

    birender New Member


    Dear sir, if possible please provide me to columnar day book with cost centre or category with amount,& narration also,


    Thanks with regard
     


  3. admin

    admin Administrator Staff Member


    Nice :)
     


  4. Umashankar

    Umashankar Member


    Dear Sashvatji, Please include for alias names also. Thanks in advance.
     


  5. Umashankar

    Umashankar Member


    Dear Sashvatji, Please include for alias names also.Search Alias is not working. Thanks in advance.
     


  6. sashvat

    sashvat New Member


    ;;Expend information in ledger table
    [#Collection : List of ledgers]
    Use : Alias Collection
    Title : $$LocaleString:"List of ledgers"
    Type : ledger
    Fetch : Name
    Report : ledger
    Variable : Sledger
    Trigger : Sledger
    IsODBCTable : Yes
    Delete : Format
    Add : Format : $Name,100.5
    Add : SubTitle : $$LocaleString:"Ledger Name","GSTN","Alias","Area","OP Bal","Group","Mobile","Telephone","DOC","CL Bal"


    Add :Format :$PARTYGSTIN
    Fetch :pARTYGSTIN
    Add :Format :$onlyalias
    Fetch :eek:nlyalias

    Add :Format :$areawise
    Fetch :areawise

    Add :Format :$OpBalance
    Fetch :OpBalance

    Add :Format :$Parent
    Fetch :parent

    Add :Format :$LedgerMobile
    Fetch :LedgerMobil
    Add :Format :$Ledgerphone
    Fetch :Ledgerphone
    Add :Format :$CreationDate
    Fetch :CreationDate

    Add :Format :$ClosingBalance
    Fetch :ClosingBalance
     


  7. Umashankar

    Umashankar Member


    Dear Sashvatji, Thanks for your reply. If we type the alias name, by default, it will alone popup and open. That is the way I want in expanded mode. Thank you once again in advance.
     


  8. nasir

    nasir Member


    DEAR HOW CAN I SHOW LEDGER CLOSING BALANCE IN RECEIPT VOUCHER PRINTING SUPPOSE Previous Bal 50000 Rcved 40000 Net Balance 10000
     


  9. YOONUS A V

    YOONUS A V New Member


    CAN U PLEASE PROVIDE ME TDL FILE FOR DISABLING 'UNUSED LEDGER ACCOUNTS'
     


Share This Page