Party Wise Previous Balance

Discussion in 'Free Source Codes' started by Sanjay preethi, Jan 21, 2021.

    

  1. Any One Help Me Sir

    I want Previous Balance Last Sales Bill Before Date ...



    [Field:DisplayClose]
    Use : Amount Field
    Set as : $$CollAmtTotal:partyPrevBalColl:$Amount+($$ToValue:($Date-1):$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)
    Border : Thin Left
    Width : 12
    Format : "DrCr"

    [Collection: PartyPrevBal Coll]
    Parm Var : SVFromDate : Date : $$ReqObject:$Date
    Parm Var : SVToDate : Date : $$ReqObject:$Date
    Parm Var : PBPartyName : String: $$ReqOwner:$PartyLedgerName
    Parm Var : PBMasterID : Number: $$ReqObject:$MasterID

    Type : Vouchers : Ledger
    Child Of : ##PBPartyName
    Fetch : VoucherTypeName, Amount, MasterID
    Filter : PBSalesonly, PBMasterID

    [System: Formulae]

    PBSalesonly : $$IsSales:$VoucherTypeName
    PBMasterID : $MasterID<##PBMasterID
     

    Attached Files:



Share This Page