Hii I am new to the tdl I have created a menu in tally in which i am saving name remark & date. I am able to export the data,but I am not able to export the username can any one help me.....thanks in advance
Dear Shruti, If you want to fetch login user name then you can try $$CmpUserName. If you want to fetch entry user name then you can try $EnteredBy
thanx sir.. But as i am new i am not able to customize I dont want to enter the details manually..when i export it should automatically give entered by name...My code is as below [#Menu: Gateway of Tally] Add : Key Item : "Aggregate UDF2" : V : Alter : Company Audit [Report: Company Audit] Form : Company Audit Object : Company ;;Export the Report Export : Yes [Form: Company Audit] ;;Displays the Export button ;;Use Alt+E to Export the Report. Button: ExportButton Parts : Company Audit Title, Company Audit Background : Light Lily Yellow [Part: Company Audit Title] Lines : Company Audit Title Border : Column Titles [Line: Company Audit Title] Use : Company Audit Local : Field : Default : Style : Small Bold Local : Field : Default : Skip : Yes Local : Field : Default : Type : String Local : Field : Default : Delete: Storage Local : Field : Default : Lines : 2 Local : Field : CMP VBrand : Set as: "Name" Local : Field : CMP VAudit On date : Set as: "Audit on" Local : Field : CMP VCurrently in Service : Set as: "In Service?" Local : Field : Default : Delete: Inactive [Part: Company Audit] Line : Company Audit Repeat : Company Audit : Company Audit Scroll : Vertical CommonBorder: Yes BreakOn : $$IsEmpty:$VBrand [Line: Company Audit] Field : CMP VBrand Right Field : CMP VCurrently in Service Right Field : CMP VAudit On date Local : Field : Default : Style : Small Bold [Field: CMP VBrand] Use : Short Name Field Storage : VBrand Border : Thin Left [Field: CMP VCurrently in Service] Use : Logical Field Storage : VCurrentlyInService Border : Thin Left Inactive: $$IsEmpty:$VBrand Width : 7 [Field: CMP VAudit On date] Use : Short Date Field Storage : VAuditOnDate Border : Thin Left ;;InActive: $VCurrentlyInService or $$IsEmpty:$VBrand [System: UDF] ;;Repeated UDF Company Audit : Aggregate : 9000 VBrand : String : 9002 VCurrently in Service : Logical : 9001 VAudit On date : Date : 9001 $EnteredBy : String :9004 [Collection: CMP Audit] Type : Company Audit : Company Childof : ##SVCurrentCompany ;;Format : $VVehicleNumber, 20 Format : $VBrand, 10 Filter : InServiceFormula Title : "Company Audit" [System: Formula] InServiceFormula : $VCurrentlyinService [#Part: EI DelNoteInfo] Add : Option : Aud EI DelNoteInfo : @@IsSales [!Part: Aud EI DelNoteInfo] Add : Line : EI Audit Det Height : 4 [Line: EI Audit Det] Field : Medium Prompt, EI Audit Det Local : Field : Medium Prompt : Set as : "Audit : " [Field: EI Audit Det] Use : Short Name Field Table : CMP Audit, Not Applicable Show Table : Always Storage : VCHAudit [System: UDF] VCHAudit : String : 9010 ;; End-of-File