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.
You will have to make a FUNCTION. Look for a TDL to replace date in Daybook, you can modify as per your use.
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
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
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
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.