1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Cheque Number In Reports

Discussion in 'Free Source Codes' started by Jay kumar tailor, Sep 10, 2018.

    
Page 1 of 4
  1. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Dear Experts


    It Is working fine in ledger voucher detail.
    but not Showing values in Daybook .
     
    Jay kumar tailor, Sep 10, 2018
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Because there is no field defined for Daybook........ define a field to display cheque no. in daybook. Only column heading defined in daybook.
     
    Amit Kamdar, Sep 10, 2018
    #2


  3. Devaki

    Devaki Member


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

    [#Line: DB Title1]
    Add : Fields : AFter : Dsp VchAcctTitle : TEPLChequeNoTitle

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

    [#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
    Width : 6

    [#Collection: Vouchers of Ledger]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER

    [#Collection: Daybook Vouchers of Company]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
     
    Devaki, Sep 10, 2018
    #3


  4. Devaki

    Devaki Member


    Sir , is it right
     
    Devaki, Sep 10, 2018
    #4


  5. Devaki

    Devaki Member


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

    [#Line: DB Title1]
    Add : Fields : AFter : Dsp VchAcctTitle : TEPLChequeNoTitle

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

    [#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
    Width : 6

    [#Collection: Vouchers of Ledger]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER

    [#Collection: Daybook Vouchers of Company]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
     
    Devaki, Sep 10, 2018
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I do not have necessary data to check the above TDL..

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

    Is the above Line and Field common in DayBook also?? If not, then you need to find the required and add field "TEPLChequeNoFld" in Daybook also.
     
    Amit Kamdar, Sep 10, 2018
    #6


  7. Devaki

    Devaki Member


    sir it is working in Day book also. i already checked . if any any error please guide me
     
    Devaki, Sep 10, 2018
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    good work ....
     
    Amit Kamdar, Sep 10, 2018
    #8


  9. Devaki

    Devaki Member


    upload_2018-9-10_15-3-27.png

    Please check
     
    Devaki, Sep 10, 2018
    #9


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Perfect......also check if it works for receipt voucher as well...........in this case the party's cheque #

    Also to enhance this report....in case Bank name is not apparent from Vocuher #, you can introduce a short name field for Bank name+Chq i.e. BOB-1234567
     
    Amit Kamdar, Sep 10, 2018
    #10


  11. Devaki

    Devaki Member


    Sir i am 2 month infant for TDL. but will try
     
    Devaki, Sep 10, 2018
    #11
    auruem, yacob and Amit Kamdar like this.


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not a problem....you must try on.... if stuck let me know..............
     
    Amit Kamdar, Sep 10, 2018
    #12


  13. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Well done :)

    It Is Working Very Smoothly.


    Thank you so much Devaki .
     
    Jay kumar tailor, Sep 10, 2018
    #13


  14. mpal2311

    mpal2311 Active Member



    Good work, keep it up.
     
    mpal2311, Sep 10, 2018
    #14


  15. Bindeshwar Kumar

    Bindeshwar Kumar New Member


    Contra Voucher Cheque Number not showing
     
    Bindeshwar Kumar, Sep 12, 2018
    #15


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Can you try on your own...........

    Hint : If $$IsPayment:$VoucherTypeName then <so n so> else if If $$IsContra:$VoucherTypeName then <so n so>

    Try your level best.................. Don't be afraid of experimentation.........

    Capture.PNG
     
    Amit Kamdar, Sep 12, 2018
    #16


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Ms. Devaki...... A challenge your way....

    If a payment voucher is passed as under:
    ABC & Co. Dr Rs.75000/-
    Cr. Bank A/c Rs.60000/-
    Cr Discount recd Rs.10000/-
    Cr. adjustments Rs.5000/-

    Then it will not show.... coz Bank is 2nd line and not last line............. So solve this.
     
    Amit Kamdar, Sep 12, 2018
    #17
    Jaydeep Shah likes this.


  18. Devaki

    Devaki Member


    Any hints sir...
     
    Devaki, Sep 12, 2018
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    use like this......... $AllLedgerEntries[1, @@IsBankLdgr].BankAllocations[1].InstrumentNumber

    [System : Formula]
    IsBankLedgr : $$IsLedOfGrp:$LedgerName:$$GroupBank OR $$IsLedOfGrp:$LedgerName:$$GroupBankOD


    Above is just an example..........
     
    Amit Kamdar, Sep 12, 2018
    #19
    Jaydeep Shah likes this.


  20. Devaki

    Devaki Member


     
    Devaki, Sep 13, 2018
    #20
    yacob likes this.


  21. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    I Added 2 Field & see

    It looks Likes This.

    :D
     

    Attached Files:

    Jay kumar tailor, Sep 13, 2018
    #21


  22. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    I also added



    [#Collection: Vouchers of Group]
    Fetch : AllLedgerEntries.BankAllocations.INSTRUMENTNUMBER
     
    Jay kumar tailor, Sep 13, 2018
    #22


  23. Devaki

    Devaki Member


    If a payment voucher is passed as under:
    ABC & Co. Dr Rs.75000/-
    Cr. Bank A/c Rs.60000/-
    Cr Discount recd Rs.15000/-
     
    Devaki, Sep 17, 2018
    #23


  24. Devaki

    Devaki Member


    just change

    [Field : TEPLChequeNoFld]
    Use : Short Name Field
    Set as : $AllLedgerEntries[-2].BankAllocations.INSTRUMENTNUMBER
    Skip : Yes
    Align : Right
    Width : 6
     
    Devaki, Sep 17, 2018
    #24


  25. Jay kumar tailor

    Jay kumar tailor Well-Known Member



    Already done for second field.

    & toggle button also attached
     
    Jay kumar tailor, Sep 17, 2018
    #25


Page 1 of 4

Share This Page