Godown Security - Free TDL Source Code Code: ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [#Collection: Godown] Add : Filter : IsUserGodown [#Collection: Godown for Parent] Add : Filter : IsUserGodown [#Collection: Multi Godown] Add : Filter : IsUserGodown [#Collection: Godown Under MGodown] Add : Filter : IsUserGodown [#Collection: Stockable Godown] Add : Filter : IsUserGodown [#Collection : Godown Summary] Add : Filter : IsUserGodown [#Collection : GodownChildOfGodownName] Add : Filter : IsUserGodown [#Collection : Primary Godowns] Add : Filter : IsUserGodown [#Collection: Stockable Godown VchExtract] Add : Filter : IsUserGodown [#Collection: Godown VchSrc] Add : Filter : IsUserGodown [System : Formula] JLGlobalPassFilter : ($$Name=$$CmpUserName) ReqGodName : $$FilterCount:JLGodownName:ForThisGodown > 0 ForThisGodown : $JLGodown = $$ReqObject:$Name IsUserGodown : If $$IsCmpOwner Then 1=1 else $$AsReqObj:$$FilterValue:@@ReqGodName:JLGLUserList:First:JLGlobalPassFilter [#Collection: Inv Reports] [#Collection: Godown Summary] Delete : Collection Collection : Primary : $$IsCmpOwner [Collection : JL GL User List] Type : User List : Company Childof : ##SVCurrentCompany [#Line: CUTitle] Add : Fields : At End : ABN CU Valid Date Title [Field : ABN CU Valid Date Title] Use : Short Name Field Set as : "Godown" ;[#Line: Company Users] ; Add : Fields : At End : ABN CU Valid Date [#Part: Company Users] Local : Line : Company Users : Add : Field : At End : ABN CU Valid Date [Field : ABN CU Valid Date] Use : Logical Field Set as : If $$IsEmpty:#CMPUserName Then "" Else "No" Skip : $$IsEmpty:#CMPUserName SubForm : JLGodownForm : $$Value [Report: JLGodownForm] Form : JLGodownForm [Form: JLGodownForm] Part : JLGodownForm Height : 50% Screen Width : 25% Screen [Part: JLGodownForm] Line : JLGodownFormTitle, JLGodownForm Repeat : JLGodownForm : JLGodownName Scroll : Vertical Break on : $$IsSysName:$JLGodown [Line: JLGodownFormTitle] Field : Name Field Border : Thin Top Bottom Local : Field : Name Field : Set as : "Godown Name" Local : Field : Name Field : Full Width: Yes Local : Field : Name Field : Align : Center Local : Field : Name Field : Skip : Yes [Line: JLGodownForm] Field: JLGodownForm [Field: JLGodownForm] Use : Name Field Set as : $JLGodown Storage : JLGodown Table : Godown : $$Line = 1 Table : Godown, EndofList : $$Line > 1 Show Table : Always Full Width : Yes [System : UDF] JLGodownName : Aggregate : 1 JLGodown : String : 101 ;; JLGroupIsCalculable : String : 5001 ;; Eof
Mr. Admin I Need all vouchers need date and time pls help me. This is only for Sales Voucher. [#Part : VCHNarration] Option : SalesUser : @@Issales [!Part : SalesUser] Add : Line : SKUser,SKDate,SKTime, [Line : Skuser] Field : Name Field,Shortname Field Local : Field : Name Field : Info : "User Name " Local : Field : Short name Field : Set as : If $$InCreatemode Then ##Svusername Else $SkUser Local : Field : Shortname field : Storage : SKUser Local : Field : Shortname field : Skip : Yes [Line : SKDate] Field : Name Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineDate Else $SkDate Local : Field : Name Field : Storage : SkDate Local : Field : Name Field : Skip : yes [Line : SKTime] Field : Name Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineTime Else $SkTime Local : Field : Name Field : Storage : SkTime Local : Field : Name Field : Skip : yes [System : Udf] Skuser : String : 2111 SkTime : String : 2112 SkTime : String : 2113
Plz Add This TDL. All voucher showing date, time and user name Option : PurchaseUser : @@Ispurchase Option : Journaluser @IsJournal Option : Receiptuser @IsReceipt OPtion : Paymentuser @Ispayment [!Part : PurchaseUser] Add : Line : SKUser,SKDate,SKTime, [!Part : JournalUser] Add : Line : SKUser,SKDate,SKTime, [!Part : ReceiptUser] Add : Line : SKUser,SKDate,SKTime, [!Part : PaymentUser] Add : Line : SKUser,SKDate,SKTime, Plz Admin help me voucher printing showing Date, time & user name. or only user name.
Try this [#Part : VCHNarration] Add : Line : SKUser, SKDate,SKTime [Line : Skuser] Field : Name Field,Shortname Field Local : Field : Name Field : Info : "User Name " Local : Field : Short name Field : Set as : If $$InCreatemode Then ##Svusername Else $SkUser Local : Field : Shortname field : Storage : SKUser Local : Field : Shortname field : Skip : Yes [Line : SKdate] Field : Name Field,Shortname Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineDate Else $SkDate Local : Field : Name Field : Storage : SkDate Local : Field : Name Field : Skip : yes [Line : SKTime] Field : Name Field,Shortname Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineTime Else $SkTime Local : Field : Name Field : Storage : SkTime Local : Field : Name Field : Skip : yes [System : Udf] Skuser : String : 2111 SKdate : string : 2112 SkTime : String : 2113
I have tried attached code also not working [#Part : VCHNarration] Option : SalesUser : @@Issales OR @@IsPurchase OR @@IsReceipt OR @@IsPayment OR @@IsContra OR @@IsJournal [!Part : SalesUser] Add : Line : SKUser,SKDate,SKTime, [Line : Skuser] Field : Name Field,Shortname Field Local : Field : Name Field : Info : "User Name " Local : Field : Short name Field : Set as : If $$InCreatemode Then ##Svusername Else $SkUser Local : Field : Shortname field : Storage : SKUser Local : Field : Shortname field : Skip : Yes [Line : SKDate] Field : Name Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineDate Else $SkDate Local : Field : Name Field : Storage : SkDate Local : Field : Name Field : Skip : yes [Line : SKTime] Field : Name Field Local : Field : Name Field : Set as : If $$InCreateMode Then $$MachineTime Else $SkTime Local : Field : Name Field : Storage : SkTime Local : Field : Name Field : Skip : yes [System : Udf] Skuser : String : 2111 SkTime : String : 2112 SkTime : String : 2113 ;;======================end of report================================
Dear Admin / Experts, Please post a TDL of Voucher Type Wise Godown and Stock Group Control which is useful to all industries. Waiting for your reply at the earliest... Regards vanandd
Thanks for sharing code Iwant help from you that i want to restrict sundry debtor group according to i specify on secrurity. I done all but didnot restrict on report please help me.......
I am New in tally looking for Voucher wise Security , as Security given by Tally Solution not only block back dated entry ,it is block to open entry as well ,that is make use difficult to check sales and purchase invoice
Rather than trying to find LONG LONG method via TDL.........there is a simple method To check backdated entries you can press SHIFT+Enter or ALT+Enter, depends on report to check back dated entries. Security in Tally is good and designed with a lots of thoughts and ideas ...... and yet there are alternate ways provided also. Alternatively, you cal designate a new ID for user to check entries by giving them JUST "view" access and you can assign it that way also. The trick is to MASTER the security control...........
Godown for Parent shows error, [Could not find original description for Collection:Godown for Parent]