Last Receipt Amount and Date for ledgers

Discussion in 'Free Source Codes' started by VISHNU RATHI, May 1, 2019.

    
  1. VISHNU RATHI

    VISHNU RATHI Member


    hello,

    how to get the last receipt date and amount of ledgers through ledger entries in my tdl report.
    $$LastVoucherDate:ledger:$Name
    brings the last entry whichever is made. like sales, purchase, journal etc.
    but i need to find only last receipt entry amount and date.

    Help.
     


  2. ABDUL AZIZ

    ABDUL AZIZ Member


    Hi Vishnu,

    Although I am not an expert but i tried this collection code for myself and it worked.......

    ;;;;RECEIPT COLL;;;;;;;;;;
    [Collection:AllRcptVchrs]
    Type : Vouchers
    Sort : -$Date
    Filter : MyRcptEntries
    Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date, VoucherTypeName, AllLedgerEntries.VoucherTypeName


    [System: Formulae]

    MyRcptEntries : $LedgerName = #DisplayGrpItem AND $$IsReceipt:$VoucherTypeName


    #DisplayGrpItem <<<<<<<<<<< this is a Group
     


  3. VISHNU RATHI

    VISHNU RATHI Member


    thankyou sir,
    i will check and inform you.
    can you share the whole code with me .
     


  4. sumamehtra

    sumamehtra Member


    IS IT POSSIBLE
    LAST RECEIPT ENTRY FETCH WITH BANK IN VOUCHER ENTRY NARRATION FIELD?
     


  5. balajimg

    balajimg Active Member


    its possible
     


  6. sumamehtra

    sumamehtra Member


    please share code
     


  7. balajimg

    balajimg Active Member


    sorry i haven't done any project on the same.
    and
    do try your own code instead of depending on others' codes.
    If concept is clear, then code is just the replica of the algorithm
     


Share This Page