I want Party Last Receipt Date

Discussion in 'Free Source Codes' started by Sanjay preethi, Aug 8, 2021.

    

  1. Dear Developers,
    I want last Party's Last received Date in Payment Entry

    any help me...

    ;;;;;my Code Bello;;;;;




    [#Line: ACLSInfo]

    Left Fields : ACLSDeemedPos, VCHDirectBills, ACLSLed, VCH FBT Category Name, VCHDirectTaxBills
    Right Fields: EIAdvRcptTotal, EI AdvRcptSBCTotal, EI AdvRcptKKCTotal, EISTLedTotal, EISTSBCLedTotal, EISTKKCLedTotal, ACLSAmt
    Add:Right Field:Before:ACLSAmt:party Last Pymt Date


    [Field: Party Last Pymt Date]

    Use : Uni Date Field
    Set as : $$CollectionField:$Date:1:partyLastPayment
    Set Always : Yes
    Width : @@ShortDateWidth + 3
    Style : Normal Bold
    Align : Left

    [Collection : Party Last Payment]

    Parm VAR : SVCurrentDate : Date : ##SVCurrentDate
    Parm Var : svFromDate : Date : @@CMPStartDate
    Parm Var : svToDate : Date : @@FinYrEnding
    Parm Var : pConsignee : String: #LedgerName

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

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


    [System:Formulae]
    Receipt : $$IsReceipt:$VoucherTypeName
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Collection : Party Last Payment]
    Type : Vouchers : Ledger
    Child Of : #ACLSLed
    Walk : All Ledger Entries
    Filter : Receipt
    Sort : @@Default : -$Date
    Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date
     



  3. thank U sir
    its working;;;;;
     

    Attached Files:



Share This Page