Breaking

EXCEL TO TALLY - AUTOMATION 10.0 | BEST EXCEL TO TALLY DATA TRANSFER UTILITY | EXCEL TO TALLY PRIME IMPORT | EXCEL TO TALLY ERP9 IMPORT

This is Excel to Tally Automationto automate your Data Entry with Tally. It is very helpful to import Excel Datainto Tally, easy and quickly...

Friday, 13 December 2019

RECYCLE BIN FOR TALLY ERP9

TDL (Tally Difinition Language) files always make our work so easy. You can modified you Tally with TDL files. TDL files are very simple to make, just after few coding you can modify your Tally software (Accounting Software). Tally is best accounting software in Asia pacific , and very simple to use, But Tally not has inbuilt Recycle Bin. But we can make it by TDL coding. So I have some codes for your Tally that you can use  as Recycle Bin.

With this TDL file you can add a Recycle Bin in Tally.
Now you can delete entries without any worry and get back it any time.
This is must have TDL for Tally.
You can use Recycle Bin for Tally for your any version of Tally Like, Tally ERP9 , Tally 9 or GST Tally etc.

Copy the below code and follow instruction given below the code:

[#Menu: GatewayofTally]
  Add: Item: Before:Reports: @@locRecyclebin :Display :LW Del :NOT $$IsEmpty:$$SelectedCmps
  Add: Item: After: @@locRecyclebin: Blank
  Control :@@locRecyclebin: $$Allow:Create:Vouchers

[Report: LW Del]
  Use: Voucher Register
  Title   : "Recycle Bin"
  Local: Line: DSP Vchdetail: Empty: NOT $fldDeleted
  Set: FamilyVoucherFlag: Yes
  Set: IsRestoreMode: Yes
  Set: SV To Date : $$YearEnd:##SVCurrentDate 
  Set: lConfirmation: Yes

[#Form: Voucher]
  Local: Line : VCH NarrPrompt: Add: Fields: Recycle Bin
  Set Always: RecycleBinFlag: If ##IsRestoreMode then ##RecyclebinFlag else No

[Field: Recycle Bin]
  Use: Logical field
  Storage: fldDeleted
  Set as: If ##IsRestoreMode then No else ##RecyclebinFlag
  Set Always: Yes                                         
  Type: Logical 
  Invisible: Yes

[#Collection: DayBook Vouchers of Company]
  Fetch : fldDeleted 
  
[#Key: BottomToolBarBtn3_Delete]
  Title   : $$LocaleString:"Delete"
  Option: RbinFormDelete: if ($$IsVoucher AND NOT ##IsRestoreMode) then Yes else No

[#Key: BottomToolBarBtn3]  
  Title   : $$LocaleString:"Delete"
  Option: RbinDeleteLineObject: Yes
  
[#Key: Delete Line Object]
  Key     : Alt+D
  Option: RbinDeleteLineObject: Yes

[#Key: Delete Line ObjectEx]
  Key     : Alt+D
  Option: RbinDeleteLineObject: Yes
  
[!Key: RbinFormDelete]
  Key: Alt+D
  Action: Alter: Rpt Confirmation

[!Key: RbinDeleteLineObject]
  Key: Alt+D
  Action: Alter Object

[Key: Restore from Bin]
  Key: CTRL+R
  Action: Alter Object

[Report: Rpt Confirmation]
  Add: Form: frm Confirmation
  Variable: lConfirmation
  Set: lConfirmation: Yes
  Title: "Confirm"

[Form: frm Confirmation]
  Add: Part: LWhead,LWtt, LWdoubl
  Add: Bottom Part: LWlower
  Full Width  : No
  No Confirm  : Yes
  Space Left  : 5
  Space Right : 5
  Space Top   : 2
  Space Bottom: 1
  Width: 25% screen
  Height: 25% screen

[Part: LWhead]
  Horizontal Align: Centre
  Lines : ln Heading

[Part: LWtt]
  Horizontal Align: Centre
  Lines : Form SubTitle
  Local : Field : Form SubTitle : Info : $$LocaleString:"Delete?? [Yes/No]"

[Part: LWdoubl]
  Horizontal Align: Centre
  Lines : ln Confirmation

[Part: LWlower] 
  Horizontal Align: Centre
  Lines : ln Caption1

[Line: ln Heading]
  Add: Field : fldHeading 

[Line: ln Confirmation]
  Add: Field: LearnWellC,LearnWellR,LearnWellO

[Line: ln Caption1]
  Add: Field: fldCaption1

[Field: LearnWellC]
  Use: Logical Field
  Set as: ##lConfirmation          
  Modifies: lConfirmation

[Field: LearnWellR]
  Use: Logical Field
  Set as: #LearnWellC
  Set Always: Yes
  Modifies: RecycleBinFlag
  Skip: Yes
  Invisible: Yes

[Field: LearnWellO]
  Use: Logical Field
  Set as: #LearnWellC
  Set Always: Yes
  Modifies: OptionalFlag
  Skip: Yes
  Invisible: Yes

[Field: fldHeading]
  Info: "Tally-RECYCLE BIN"
  Color:Blue
  Style:Bold

[Field: fldCaption1]
  Info: "www.Learnwells.com"
  Color:Red
  Style:Bold

[#Report: Daybook]
  Local: Line: DSP VchDetail: Empty : $fldDeleted
  Set: IsRestoreMode: No

[#Report: Ledger Vouchers]
  Local: Line: DSP VchDetail: Empty : $fldDeleted
  Set: IsRestoreMode: No

[#Line: DSP VchDetail]
  Add: Option: DSP VchDetail Restore: $fldDeleted

[!Line: DSP VchDetail Restore]
  Add: Keys: Restore from Bin

[#Field: VCH Optional]
  Option: Rbin VCH Delete: ##OptionalFlag and NOT ##IsRestoreMode
  Option: Rbin VCH Restore: ##OptionalFlag and ##IsRestoreMode 

[!Field: Rbin VCH Delete]

  Style: My Style
  Set as: if #Recyclebin then "PRESS ENTER to DELETE" else @UseOptStr
  Skip: if #Recyclebin then No else Yes
  Color:Red
  
[Style: My Style]
  Font: Verdana
  Height: 18
  Bold: Yes
  

[!Field: Rbin VCH Restore]


  Add: Fields: Long Prompt,LearnWellC,FlgLWr,FlgLWrf,FlgLWop,FlgLWfld
  Local: Field: Long Prompt: Info: "PRESS ENTER to RESTORE"
  Local: Field: Long Prompt: Full Width: Yes
  Local: Field: Long Prompt: Align: Right
  Local: Field: Long Prompt: Style: My Style
  Color: Red
[Field: FlgLWr]
  Use: Logical field
  Type: Logical : Forced
  Modifies: RecyclebinFlag
  Set as: NOT #LearnWellC
  Set Always: Yes                                        
  Invisible: Yes
  Skip: Yes

[Field: FlgLWrf]
  Use: Logical field
  Type: Logical 
  Storage: fldDeleted
  Set as: #FlgLWr
  Set Always: Yes                                     
  Invisible: Yes
  Skip: Yes

[Field: FlgLWop]
  Use: Logical field
  Type: Logical 
  Modifies: OptionalFlag
  Set as: #FlgLWr
  Set Always: Yes                                
  Invisible: Yes
  Skip: Yes

[Field: FlgLWfld]
  Use         : Logical Field
  Storage     : Is Optional
  Set as      : #FlgLWop
  Set always  : Yes
  Invisible   : Yes
  Skip        : Yes

[#Form: Voucher]
  Option: RbinVoucher: ##OptionalFlag

[!Form: RbinVoucher]
  Key: SaveVoucher

[Key: SaveVoucher]
  Key: Enter
  Action: Form Accept

[#Field: Plain VCH Date]
  Option: Rbin Plain VCH Date: ##OptionalFlag

[!Field: RBin Plain VCH Date]
  Skip: if #RecycleBin then Yes else No
  
[System: Variable]
  RecycleBinFlag: "No"
  IsRestoreMode: "No"
  lConfirmation: "No"

[System: Formula]
  locRecyclebin : $$LocaleString:"Recycle Bin"

[System: UDF]
  fldDeleted: Logical : 1

[Variable: RecycleBinFlag]
  Type: Logical
  Volatile: Yes
  Persistent: No

[Variable: IsRestoreMode]
  Type: Logical
  Volatile: No
  Persistent: no

[Variable: lConfirmation]
  Type: Logical
  Persistent: No
  Volatile : Yes
  Default: No



HOW TO LOAD ABOVE CODE IN TALLY:-

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as - C:\Users\HP\Desktop\rec\RecycleBin.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup - Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Also you can download it with below Button:




4 comments:

  1. Nothing can disprove the fact that loading the junk and other waste material can really create an unfavorable situation for you and your family. In this regard, you should seek expert services of junk removal services provider. Grab hire in Coventry

    ReplyDelete
  2. many many thanks. its working

    ReplyDelete