1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Last Receipt amount with date show in sundry debtors report ?

Discussion in 'Free Source Codes' started by M. Sajid Razzaq, Aug 14, 2022.

    
  1. M. Sajid Razzaq

    M. Sajid Razzaq Member


    Please Help me, any one know, how to generate sundry debtors report with last receipt amount with date.
     
    M. Sajid Razzaq, Aug 14, 2022
    #1


  2. M. Sajid Razzaq

    M. Sajid Razzaq Member


    I need like this printout of sundry debtors group with last payment date and amount
     

    Attached Files:

    M. Sajid Razzaq, Aug 16, 2022
    #2


  3. S P Tandale

    S P Tandale Member


    Try This


    [Line: VCH Party Last Payment]
    Invisible : Not $Printstatement:VoucherType:$VoucherTypeName
    Border : Thin Bottom
    Field : Simple Prompt, Party Last Pymt, Medium Prompt, Party Last Pymt Date
    Local : Field : Simple Prompt : Set as : $$LocaleString:"Last Received Payment :"
    Local : Field : Simple Prompt : Width : 20
    Local : Field : Simple Prompt : Style : Normal Italic
    Local : Field : Medium Prompt : Set as : $$LocaleString:"Dt. :"
    Local : Field : Medium Prompt : Width : 3
    Local : Field : Medium Prompt : Style : Normal Italic
    Local : Field : Medium Prompt : Inactive: $$IsEmpty:#PartyLastPymt

    [Field: Party Last Pymt]

    Use : Amount Field
    Type : Amount : Forced
    Set as : $$CollectionField:$Amount:1:partyLastPayment ;else $$FilterValue:$Amount:partyLastPayment:1:DummyFormula
    Set Always : Yes
    ;Storage : Party Last Pymt
    ;Width : @@AmountWidth
    Style : Normal Bold
    Format : "No Zero, Symbol," + ##ShowForex
    Align : Left

    [Field: Party Last Pymt Date]

    Use : Uni Date Field
    ;Type : Date : Forced
    Set as : $$CollectionField:$Date:1:partyLastPayment ;else $$FilterValue:$Date:partyLastPayment:1:DummyFormula
    Set Always : Yes
    ;Storage : Party Last Pymt Date
    Width : @@ShortDateWidth + 3
    Style : Normal Bold
    Align : Left
    Inactive: $$IsEmpty:#PartyLastPymt

    [Collection : Party Last Payment]

    Parm VAR : SVCurrentDate : Date : ##SVCurrentDate
    Parm Var : svFromDate : Date : @@CMPStartDate
    Parm Var : svToDate : Date : @@FinYrEnding
    ;Parm Var : svCurrentDate : Date : ##SVCurrentDate
    Parm Var : pConsignee : String: #EXPINVPartyLedName

    Type : Vouchers : Ledger
    Child Of : ##pConsignee ;#EIConsignee;
    Walk : All Ledger Entries

    Filter : Receipt;, SameLedger
    Sort : @@Default : -$Date
    Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date


    [System:Formulae]
    Receipt : $$IsReceipt:$VoucherTypeName
     
    S P Tandale, Sep 7, 2022
    #3
    M. Sajid Razzaq likes this.


  4. M. Sajid Razzaq

    M. Sajid Razzaq Member


    Not Working in Tally 9
     
    M. Sajid Razzaq, Jan 31, 2023
    #4


Share This Page