Customer bank Details register

Discussion in 'Tally Developer' started by Murali.R, Jun 29, 2016.

    
  1. Murali.R

    Murali.R Member


    Please what mistek my collection ,

    [#Menu: Gateway of Tally]
    Item: Mura Report : Menu : Mura Sub Menu

    [Menu: Mura Sub Menu]
    Item : Payment Register : Display : Payment Register : NOT $$IsEmpty:$$SelectedCmps


    [Report : Payment Register]
    ;Use : Dsp Template
    Variables : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod, SVBudget, SVVariance
    Set : SV Sort Method : "Default"
    Set : Is Day Book : No
    Form : RecReg

    [Form : RecReg]
    Use : Dsp Template
    Height : 100 % Page
    Width : 100 % Page
    Part : DSP AccTitles, RecBody


    [Part : RecBody]
    Lines : Rchqlineh, Rchqline
    Repeat : RChqline : RM Bank Allocations;Rctvchs
    Scroll : Vertical
    Common border : Yes

    [Line : RChqLineh]
    Fields : MRIFld4,MRIFld5,MRIFld6,MRIFld7,MRIFld8,MRIFld9,MRIFld10,MRIFld11,MRIFld12,MRIFld13
    Local : Field : Default : Type : String
    Local : Field : MRIFld4 : Set as : "Bene.Name"
    Local : Field : MRIFld5 : Set as : "Bene A/c No"
    Local : Field : MRIFld6 : Set as : "Bene E-Mail"
    Local : Field : MRIFld7 : Set as : "E-Mail Body"
    Local : Field : MRIFld8 : Set as : "Debit A/c No"
    Local : Field : MRIFld9 : Set as : "CRN"
    Local : Field : MRIFld10 : Set as : "Rece.IFSC"
    Local : Field : MRIFld11 : Set as : "Rece A/c Type"
    Local : Field : MRIFld12 : Set as : "Remarks"
    Local : Field : MRIFld13 : Set as : "Mobile No"
    Border : thin Top Bottom



    [Line : RChqLine]
    Fields : MRIFld4,MRIFld5,MRIFld6,MRIFld7,MRIFld8,MRIFld9,MRIFld10,MRIFld11,MRIFld12,MRIFld13


    [Field : MRIFld4]
    Use : Name Field
    Set as : $Name;;$VoucherChequename
    Width : 40
    Line : 0

    [Field : MRIFld5]
    Use : Name Field
    Width : 12
    Align : Center
    Border : Thin left
    Set as : $AccountNumber


    [Field : MRIFld6]
    Use : Name Field
    Set as : $EMailCC
    Width : 12

    Align : Center
    Border : Thin left

    [Field : MRIFld7]
    Use : Name Field
    Set as : $Narration
    Width : 12
    Align : Center
    Border : Thin left

    [Field : MRIFld8]
    Use : Name Field
    Set as : $BankDetails
    Width : 12
    Align : Center
    Border : Thin left

    [Field : MRIFld9]
    Use : Name Field
    Set as : ""
    Width : 12
    Align : Center
    Border : Thin left

    [Field : MRIFld10]
    Use : Name Field
    Width : 12
    Set as : $IFSCode
    Align : Center
    Border : Thin left
    Case : Upper Case


    [Field : MRIFld11]
    Use : Name Field
    Set as : $BankBSRCode
    Width : 12
    Align : Center
    Border : Thin left

    [Field : MRIFld12]
    Use : Name Field
    Set as : ""
    Width : 12
    Align : Center
    Border : Thin left

    [Field : MRIFld13]
    Use : Name Field
    Set as : $LedgerMobile
    Width : 12
    Align : Center
    Border : Thin left


    [Collection: RM Bank Allocations]
    Type : Ledger
    Fetch : LedgerName,Name,Parent,Address,LedgerContact,LedgerPhone,LedgerMobile,StateName,Pincode,Email,OpeningBalance,ClosingBalance,*.*
    Filter : ABFDCrDrOnly
    Belongs To : Yes


    [System : formula]
    Rctvchs : $$IsPayment:$VoucherTypeName ;;and
    ;ChBkEntries : Not $LedgerName AND NOT $$IsDr:$Amount
    ABFDCrDrOnly : $$IsBelongsTo:$$GroupSundryDebtors OR $$IsBelongsTo:$$GroupSundryCreditors
     


  2. siddharth kumar

    siddharth kumar New Member


    WHERE THIS EFFECT PLEASE SEND ME SOME PHOTOS FOR INFORMATION
     


Share This Page