How to Add Column in Account Books Ledger Screen for Cheque Number

Discussion in 'Tally.ERP 9' started by Jitendra Velani, Feb 28, 2014.

         
  1. Jitendra Velani

    Jitendra Velani New Member


    dear sir/madam,

    in tally display menu -> Accounts Books -> Ledger Screen

    How to Add Column for Cheque Number

    CHEQUE NUMBER NOT DISPLAYING
    please help?

    ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara

    [#Line: DSP VchAccTitles]
    Add : Fields : AFter : DSP VchAcctTitle : TEPLChequeNoTitle

    [Field : TEPLChequeNoTitle]
    Set as : "Cheque No."
    Skip : Yes

    [#Line: DSP VchDetail]
    Add : Right Fields : Before : DSP VchType : TEPLChequeNoFld

    [Field : TEPLChequeNoFld]
    Use : Short Name Field
    Set as : $InstrumentNumber
    Skip : Yes
    Align : Right

    [#Collection: Vouchers of Ledger]
    Fetch : Reference
    Fetch : InstrumentNumber
    ;;Fetch : AllLedgerEntries.BankAllocations.InstrumentNumber




    Jitendra Velani
    jvgears@gmail.com
     

    Attached Files:



  2. HVPatel

    HVPatel Active Member


    Hi experts,
    Can anyone focus a little on above, i have also same issue.
    Thanks & Regards
     



  3. ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara

    [#Line: DSP VchAccTitles]
    Add : Fields : AFter : DSP VchAcctTitle : TEPLChequeNoTitle

    [Field : TEPLChequeNoTitle]
    Set as : "Cheque No."
    Skip : Yes

    [#Line: DSP VchDetail]
    Add : Right Fields : Before : DSP VchType : TEPLChequeNoFld

    [Field : TEPLChequeNoFld]
    Use : Short Name Field
    Set as : $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER
    Skip : Yes
    Align : Right

    [#Collection: Vouchers of Ledger]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
     
    Hitu_M and salipunathil like this.


  4. HVPatel

    HVPatel Active Member


    Thanks Mr. Bidyut, for above,
    I have little different requirement, and it is solved.
     


  5. Rajsrisrimal

    Rajsrisrimal Member

    Bidyut Banerjee likes this.


  6. mpal2311

    mpal2311 Active Member



  7. sakthivel

    sakthivel New Member


    ; I want to display the Mobile number of party and cheque number in receipt voucher in receipt voucher.
    ; Mobile number works properly but cheque no is not pick up from bank allocation screen.

    [#Form: VCH ReceiptDetails]
    Local : Part : VCH Narration : Add : Line : Before : VCH NarrPrompt : VCH ReceiptMobile
    Local : Part : VCH Narration : Add : Line : Before : VCH NarrPrompt : VCH ChNo

    [Line:VCH ReceiptMobile]

    Fields : Short Prompt, VCH ReceiptMobile
    Local : Field : Short Prompt : Info : $$LocaleString:"Payer Mobile No :"
    Local : Field : Short Prompt : Width : 15

    [Field: VCH ReceiptMobile]
    Type : String: Forced
    Fixed : Yes
    Skip : Yes
    Width : @@LongWidth
    Max : @@MaxNarrWidth
    Storage : VCHMobileNo
    Set as : $LedgerMobile:Ledger:$BasicVoucherChequeName

    [Line:VCH ChNo]

    Fields : Short Prompt, VCH ChNo
    Local : Field : Short Prompt : Info : $$LocaleString:"Cheque No :"
    Local : Field : Short Prompt : Width : 15

    [Field: VCH ChNo]
    Type : String: Forced
    Fixed : Yes
    Skip : Yes
    Width : @@LongWidth
    Max : @@MaxNarrWidth
    Storage : VCHchno
    Set as : $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER ;its not working

    [System: UDF]
    VCHMobileNo : String: 1001
    VCHChNo : String: 1002

    upload_2016-10-24_11-7-33.png
     


  8. vyadav

    vyadav Member


    how is work
     


  9. vyadav

    vyadav Member



    Dear Sir,, It's not working
     


  10. Rameshkumar

    Rameshkumar New Member


    th
     


  11. Rameshkumar

    Rameshkumar New Member


    thank u Bidujii , but could u modify it , there are no vertical line between cheque No & Voucher Type, could u allot 20cm width space for instrument Number
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: VCH ReceiptMobile]
    [Field: VCH ChNo]

    Border : Thin Left

    add above line in both the fields.
     


  13. Hitu_M

    Hitu_M New Member



    Thank you Mr. Bidyut
     


Share This Page