Debit Amount

Discussion in 'Tally Developer' started by kosi, Dec 21, 2018.

    
  1. kosi

    kosi Member


    experts please help me fetch only debits amount on an account or ledger
    whats the formula to retrieve the total debit amount on a particular Ledger
    Thanks
    Regards
    Philip
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $DebitTotals
     


  3. kosi

    kosi Member


    Have created ledger name call pankj
    Plz help me fetch total debit balance of pankaj
    Guide with formula
    $DebitTotal is not working
    PLC help me with full formula
    Thanks
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $DebitTotals:Ledger:##LedgerName
     


  5. kosi

    kosi Member


    Thanks boss
    Can u trow more light on
    ##LedgerName
    I don't understand especially ##
    Regards
    Philip
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    ## refers to Variable.............. here the variable name is LedgerName.........so to call it you use ##LedgerName

    While coding keep refering to TDE and sample codes files............you will learn better and faster.
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In TDE....understand the use of .......... @, @@, #, ##, $, $$, ! etc
     


  8. kosi

    kosi Member


    Thanks
    Have read reference manual on variable and need your help
    Supposing the ledger name is pankaj
    Please help me with full code to fetch pankaj.
    Please include declaration and definition of variable for better understanding of variable
    Thanks
    Regards
    Philip
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This is a learning site......you have to make the code on your own.

    If stuck, others will help.
     


  10. kosi

    kosi Member


    OK boss
    Will returne with sample code
    Thanks
    Regards
    Philip
     


  11. kosi

    kosi Member


    boss still having issues with fetching Ledger or Group debits total balance
    please check the code and correct me
    i want to retrieve the Group Cash In Hand debits total from tally report
    thanks


    [#Menu: Gateway of tally]
    Add:Item:TLOANS:Display:TLOANSREPORT

    [Report:TLOANSREPORT]
    Form:TLOANSREPORT

    [Form:TLOANSREPORT]
    Part:TLOANSREPORT
    Height:30
    Width:50

    [Part:TLOANSREPORT]
    Line:TLOANSREPORT
    [Line:TLOANSREPORT]
    Field:Long Prompt
    Local:Field:Long Prompt:Set as:$DebitsTotal:Group:##CashInHand
    Local:Field:Long Prompt:Use:Amount Field

    [System:Variables]
    Cash In Hand:""
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    in Report..........
    define............ Variable : CashinHand

    AS i suggested earlier...to refer to the TDE.... you have not done your homework properly..........

    Homework.........read and learn about variables.
     


  13. kosi

    kosi Member


    Hmmmmmm
    Every long journey begins with one step
    Hope I will get there one day
    I did defined it in report and its not fetching
    Any push so I get there
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    A Doctor cannot diagnose without examining the patient all the time, same as one cannot satisfy the hunger by smelling the aromas.
     


Share This Page