Transactions "Debit and Credit" is not working

Discussion in 'Requests' started by Amit1256, Jul 31, 2017.

    
  1. Amit1256

    Amit1256 New Member


    Dear Experts,
    I am unable to report the transactions "debit and credit" amount in amount field. Could I get the code to fetch the debit and credit balance of a group or a ledger in my report. My TDL is attached below please help me out.
     

    Attached Files:



  2. anish

    anish Member


    Check Your Collection type ! for Debit/Credit Balances you need collection type should be voucher.
     
    Amit1256 likes this.


  3. Amit1256

    Amit1256 New Member


    Sir I am very new to the world of TDL so please can you explain me in detail.@ Anish Sir
     


  4. anish

    anish Member


    This Collection will bring Debit/Credit Balance now you have to manage to Make one combined collection which bring both Ledger/Voucher details

    [Collection : TransactionsBookColl2]
    Type :Ledger:vouchers
    Belongs To : Yes
    Child Of : ##SunDebtors
    Sort : @@Default : $Name
    Fetch : Name, Address, LedgerContact, LedgerMobile, Email, IncomeTaxNumber, VATTINNumber, STXNumber, CurrentTurnover, ClosingBalance, StateName, PinCode, LedDrClosingBalance, LedCrClosingBalance,TotLedDrAmt,TotLedCrAmt
    Fetch : AllLedgerEntries
    Fetch : Date, VoucherTypeName, VoucherNumber, Narration
    Fetch : AllLedgerEntries.LedgerName, AllLedgerEntries.Amount
    Search Key : $Name
    Compute : TotLedDrAmt : $$OrigVchLedDrTotal:$LedgerName
    Compute : TotLedCrAmt : $$OrigVchLedCrTotal:$LedgerName
     


  5. Amit1256

    Amit1256 New Member



    Thank you Anish Sir
     


  6. anish

    anish Member


    Please share your final code for other members also now !
     


Share This Page