Cheque Number In Reports

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

    
  1. Bindeshwar Kumar

    Bindeshwar Kumar New Member



  2. chintamani

    chintamani New Member


    Thank you for your inputs.
    Is it possible to add a button in the DayBook or ledger screen to turn on or turn off the cheque number column display ?
     


  3. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Yes it is possible.
     


  4. Bindeshwar Kumar

    Bindeshwar Kumar New Member


    Dear Jay Kumar
    My request is pending since long time,please send file to bindeshwar72@gmail.com
     


  5. chintamani

    chintamani New Member


    I am trying to learn TDL. There is code to add custom cheque number field in some other topics on this forum. Based on the code posted there as well as the code posted in this topic, UDF value is appearing in the day book report. However, in Ledger Vouchers report it is not appearing. Credit to the original creators of the various codes on the basis of which this file is created. Please suggest where it is getting wrong.
     

    Attached Files:



  6. mukeshbaranwal3

    mukeshbaranwal3 New Member


    Dear Mr. Jay Kumar,

    Can u plz provide the final code for Display Chq number in ledger and Daybook of Payment,Receipt & Contra entry.

    Thanks,
     


  7. Bindeshwar Kumar

    Bindeshwar Kumar New Member


    I have request many times still waiting for his response
     


  8. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Some peoples are selling codes which are collected from forum.

    So I deleted the most of codes which is posted earlier.

    As Seniors say.
    Currently only snippets.
     
    sandeep76out likes this.


  9. Bindeshwar Kumar

    Bindeshwar Kumar New Member


    But atleast you can send in respective email id of those person who are requesting you,
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Is that method any different.........??? What is the guarantee you would not sell or market or pass on to others who does so ??

    If you really like something, kindly take positive steps to start making it so......... I personally know many members including JAYKUMAR TAILOR, who has migrated from asking to making TDL softwares.

    And there is no reason whatsoever that a CODER will give away free his toil of labour..............

    If you really like it then buy it......if not affordable then make it.............

    You can ask 100 or 1000 questions....if stuck in coding, experts will help you.
     
    Last edited: Dec 5, 2018


  11. Bindeshwar Kumar

    Bindeshwar Kumar New Member


    ok i made a mistake for requesting ,thanks
     


  12. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    No sir
    Not a mistake
    Before now
    I And many other do This earlier.

    But Now I Try to Make/Change Things Always.

    Ask for Queries Always.


    Please Give A little Effort to this.
    And got amazing Result.

    Try to change
    [Collection]
     


  13. vakul

    vakul Member


    any tdl to show invoice number as new column in reports like above cheque number shown as new column
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes there is. Search in this forum......
     


  15. V Shankar

    V Shankar New Member


    hi
    Can we have the same cheque details in Outstanding report
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes you can..........but only in the exploded part.........because the receipt/payment details will be only available when you explode it.
     


  17. V Shankar

    V Shankar New Member


    can i have some sample codes
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have not made any such codes......
     


  19. Asgar Alam

    Asgar Alam New Member



    Dear Sir, Final Code share please
     


  20. chintamani

    chintamani New Member


    Dear All

    Cheque No. is displayed properly in Daybook report. But when Only Payment Vouchers are selected using F4, the cheque No. Field does not show any data

    Following code is used

    Code:
    ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara
    ;; Om Muruga : Om Shridi Sai Baba
    
    ;; Cheque No Field in Contra, receipt and payment
    
    /* - This code adds a new field cheque number in the narration line
    ---- It will also add a column in day book and ledger view to display the cheque number
    ---- also in group vouchers report cheque number column will be shown
    --------  */
    
    [#Part: DBL LineNarration]
    
    Add: Option: PK RcptPymtContra: (@@IsReceipt or @@IsContra or @@IsPayment)
    
    [!Part: PK RcptPymtContra]
    
    Add: Line: Before: VCH NarrPrompt: PK RcptPymtContra
    
    [Line: PK RcptPymtContra]
    
    Field: Medium Prompt, PK ChNo
    
    Local: Field: Medium Prompt: Setas: "Cheque No.:"
    Local : Field : Medium Propmpt : Inactive : @@HasMyBankEntry  and @@PKRcptnotContra
    [Field: PK ChNo]
    
    Use: Name Field
    Storage: PKChNo
    Inactive : @@HasMyBankEntry   and @@PKRcptnotContra
    
    
    [System: UDF]
    
    PKChNo: String: 101
    
    
    ;;--------------------- adds chno to narration
    [#Field: VCH Narration]
    
        Use                 : Voucher Narration Field
        Lines               : 4
        Storage             : Narration
        ;;Set as            : If $$InCreateMode or $$InAlterMode Then $$LocaleString:"Ch.No.: "+$$String:$PKChNo Else $Narration
        Set as            : If @@IsReceipt or @@IsContra or @@IsPayment Then $$LocaleString:"Ch.No.: "+$$String:$PKChNo Else $$LocaleString:""
        Width               : 50% Screen
        Key                 : PrevVchNarration, PrevLedNarration
        Set Always          : Yes
    
    ;;----------------------------------------------------------------
    
    
    
    
    
    
    ;; Table to Filter in DayBook
    [#Form: DayBook]
    
    Add: Button: PK DB FilButton
    
    [#Report: DayBook]
    
    Add: Set: PKChNoVar: $$SysName:NotApplicable
    
    [Button: PK DB FilButton]
    
    Title: "Cheque No."
    Key:Alt+9
    Action: Alter: PK DB Form
    
    [Report: PK DB Form]
    
    Form: PK DB Form
    
    [Form: PK DB Form]
    
    Part: PK DB Form
    NoConfirm: Yes
    
    [Part: PK DB Form]
    
    Line: PK DB Form
    
    [Line: PK DB Form]
    
    Field: Medium Prompt, PK DB Field
    
    Local: Field: Medium Prompt: Setas: "Select Ch. No:"
    
    [Field: PK DB Field]
    
    Use: Name Field
    Modifies: PKChNoVar
    Table: PKChqNoTable, NotApplicable
    ShowTable: Always
    
    [Variable: PKChNoVar]
    
    Type: String
    Persistent : No
    
    [System: Variable]
    
    PKChNoVar: ""
    
    
    [Collection: PKChqNoTable]
    
    Type: Voucher
    Filter: PKRcptPayContra
    Fetch: PKChNo
    Format: $PKChNo, 20
    Title: "List of Cheque No"
    
    [System: Formula]
    
    PKRcptPayContra: ($$IsReceipt:$VoucherTypeName or $$IsPayment:$VoucherTypeName or $$IsContra:$VoucherTypeName)
    PKRcptnotContra: ($$IsReceipt:$VoucherTypeName or $$IsPayment:$VoucherTypeName)
    PKChqNoFilter: If ##PKChNoVar = $$SysName:NotApplicable then True else $PKChNo = ##PKChNoVar
    HasMyBankEntry : $$FilterCount:AllLedgerEntries:HasBankEntry = 0
    
    [#Collection : vouchers of Group]
    Add: Fetch: PKChNo
    Add: Filter: PKChqNoFilter
    
    
    [#Collection : vouchers of ledger]
    Add: Fetch: PKChNo
    Add: Filter: PKChqNoFilter
    
    [#Collection: Daybook Vouchers of Company]
    
    Add: Fetch: PKChNo
    Add: Filter: PKChqNoFilter
    
    [#Line: DSP VchDetail]
    Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld
    
    [#Line: DSP VchAccTitles]
    Add : Right Fields : Before : DSP VchTypeTitle : TEPLChequeNoTitle
    
    [#Line: DB Title1]                            ;  required for daybook
    Add : Right Fields : Before : DSP VchTypeTitle : TEPLChequeNoTitle
    
    [Field : TEPLChequeNoTitle]
    Set as : "Cheque No."
    Skip : Yes
    Width : 8
    
    [#Line: DSP VchDetail]
    Add : Right Fields : Before : DSP Vchtype : TEPLChequeNoFld
    
    [Field : TEPLChequeNoFld]
    Use : Name Field
    Set as : $PKChNo
    Skip : Yes
    Align : Left
    Width : 6
    
    
    [Field : TEPLChequeNoFld1]
    Use : Name Field
    Set as : $VchRef
    Skip : Yes
    Align : Left
    Width : 6
    
    
    [#Form: DayBook]
    
    Add: Button: PK DB2 FilButton
    
    [Button: PK DB2 FilButton]
    
    Title: "Display Cheque No."
    Key:Alt+8
    Action: Alter: PK DB Form
    

    The screen shots are as follows

    [​IMG] [​IMG]
     


  21. chintamani

    chintamani New Member


    Screen shots are attached
     

    Attached Files:



  22. chintamani

    chintamani New Member


    Kindly Help
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Just like Collection -- vouchers of ledger and Daybook Vouchers of Company .............

    Find the appropriate Collection for Filtered Vouchers in Daybook... Fetch and Compute the same and you will get it.
     


  24. rajiv jaiswal

    rajiv jaiswal Member


    amit sir
    i am getting cheque no in CONTRA, JOURNAL, RECEIPT AND PAYMENT( Double ENTRY) By using this
    Set as : If $$IsPayment:$VoucherTypeName then $AllLedgerEntries[-2].BankAllocations.INSTRUMENTNUMBER else $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER
    BUT if payment is done in single entry then not showing. please guide
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your Field .......... you should have multiple values........

    Val1 : If this then that else this.... and so on (as per Vouchertype)
    Val2: If this then that else this.... and so on (as per Entry mode)

    then......in

    Set As : If $$IsEmpty:mad:Val1 then @Val2 Else @Val1 ..........

    You need to work out the formulas to obtain the value in case of Single Entry mode...........
     
    rajiv jaiswal likes this.


Share This Page