Remove <Auto> from voucher number

Discussion in 'Requests' started by naijaind, Sep 6, 2020.

    
  1. naijaind

    naijaind Member


    Hello Sir,

    I have done TDL where my payment voucher number is set as cheque number as we do all online transfer and need voucher in instrument number field, and is working fine. I have issue as we use Multi Auto voucher configuration and so I get <Auto> ending with voucher number. Just wanted to remove from instrument number, and hence I wanted to know do TDL have find and replace functions as I couldn't find it and gave try like $string find / replace but all not working. Just want to know if same is possible so that I can work more on it.
    Thanks for your usual support.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You will have to make a FUNCTION.

    Look for a TDL to replace date in Daybook, you can modify as per your use.
     


  3. svn

    svn Member


    SIR,
    CAN YOU GIVE HELP!!!!!!!!
    THIS IS MY CODE
    I WANT CUSTOMER(PARTY NAME/BUYER NAME) BEFORE STOCK ITEM COLUMN
    [Field:MY Guest]
    Use: name Field
    Style: AB
    Set as: $BUYERNAME
    align : center
     

    Attached Files:



  4. naijaind

    naijaind Member


    Amitji, thanks for your suggestions and accordingly I tried to best of my knowledge with various combinations and finally came with attached file which I think is correct but no result. Please more guidance requested.
    Tnx
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Am not much into functions..... Please follow this.......


    Code:
    [#Form: Day Book]
    Add: Button: After : DSPShowGP : InputNewDate
    
    [Button: InputNewDate]
    Title: "Set Date"
    Key: Ctrl+R
    Action List : InputDate, ModifyDate
    
    [Button: InputDate]
    Key: Ctrl+R
    Action: Alter: Rpt InputDate
    
    [Button: ModifyDate]
    Key: Ctrl+R
    Action: Call : FuncEdit
    
    [Function: FuncEdit]
    
    ;; Variable to Save MasterID
    Variable : MSTID : String
    
    ;; Walking Over Current Vouchers of Day Book
    100 : WALK COLLECTION : SELDayVouchers
    
    ;; Set Master ID to a Variable
    120 : SET : MSTID : "ID:"+ $$String:$MasterID
    
    ;; Set Object In Edit Mode
    130 : NEW OBJECT : Voucher : ##MSTID
    
    ;; Set Target to the First Ledger (PartyLedger)
    140 : SET TARGET : LedgerEntries[1]
    
    
    ;;Modifies Value of the Methord
    160 : SET VALUE : Date : #NDate
    
    ;; Back to Ledger Entry Object
    170 : SET TARGET : ..
    
    ;; Back to Voucher Object
    180 : SET TARGET : ..
    
    ;; Saving Object
    190 : ACCEPT ALTER
    
    200 : END WALK
    
    
    
    [Collection: SELDayVouchers]
    
    Data Source : Report : Current
    Fetch : All Ledger Entries
    
    
    [Report: Rpt InputDate]
    Title : "Update Voucher Date"
    Form : Input Date
    Auto : Yes
    
    [Form: Input Date]
    Part : Input Date
    Width: 25% Screen
    Height: 8% Screen
    
    [Part: Input Date]
    Line: New Date
    
    [Line: New Date]
    
    Field : Long Prompt , NewDate
    Local : Field: Long Prompt : Set As: "New Date"
    
    [Field : NewDate]
    Use : Short Date Field
    Modifies : NDate
    Border : Thin Box
    Width : 15
    
    [System : Variable]
    Ndate : " "
    
    
    [Variable : NDate]
    Type : Date
    Persistent : Yes
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is no walk through a collection in your function. Maybe that would be the source of error.
     


  7. naijaind

    naijaind Member


    Dear Amitji,

    I thank you for encouraging for any TDL, I tried for few days and all in vain and finally I succeeded with a simple formula as attached.
    Thank you once again, Amitji.
     

    Attached Files:



Share This Page