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...

Tuesday, 5 October 2021

2021 Best Free Tally TDL Code | Tally customization for Voucher, Print, Report | Best Free TDL for Tally Prime & Tally ERP9

 


At the time of working in Tally, sometime we want some additional fields in voucher, and also want take print of invoice with some additional details, and also can create a report with these extra fields.
If you need these type modifications in tally then you are in right place.
With this Tally TDL code we can add some extra fields like delivery date, sales person name, agent name, or any other details in voucher creation screen. And also can take out invoice print with these extra details. If we add some extra details in invoice, we must generate it's MIS reports to manage all details smoothly. Yes! with this TDL code also we can generate reports, and all details can see in party Ledger summary.  
In this Tally Prime and Tally ERP TDL code we can add some additional fields or we can remove extra fields according to our need, and this will work perfectly with Tally Erp9 and Tally Prime. Best simple tdl code to customize Voucher, Invoice and generate reports.

HOW TO USE:

        1. Copy below TDL code and make a text file.
        2. Save text file then load in Tally ERP9 or in Tally Prime (Method provided below the code)                   3. Now go to voucher to add some extra fields
        4. Also can see Extra fields details in Invoice
        5. Also can see Extra fields details in Party Ledger

This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will perfectly work with Tally Prime.

Watch above video to learn :
1. How to modify Voucher
2. How to Modify Invoice
3. How to Modify Ledger Summary
4. And Many More.......

TDL Code : 


[#Part:VCHTitle2Right]
option:LearnwellDate
[!Part:LearnwellDate]
Add:Lines:AtEnd:LWDDate,LWSalesMan
[Line:LWDDate]
Field:MediumPrompt,LWDateType
Local:Field:MediumPrompt:Info:"Delivery Date"
Local:Field:MediumPrompt:Width:8% Page

[Line:LWSalesMan]
Field:MediumPrompt,LWSalesMType
Local:Field:MediumPrompt:Info:"Sales Man"
Local:Field:MediumPrompt:Width:8% Page

[Field:LWDateType]
Use:Name Field
Storage:LearnWellStr1
Width:20
Set Always:Yes
Skip:$$InAlterMode

[Field:LWSalesMType]
Use:Name Field
Storage:LearnWellStr2
Width:20
Set Always:Yes
Skip:$$InAlterMode

[System:UDF]
LearnWellStr1:String:880
LearnWellStr2:String:890

[#Line:DSP VCHACCTitles]
Add:Right Fields:Before:DSP VCHTypeTitle:LWDTitle,LWSTitle
[Field:LWDTitle]
Use:Name Field
Set As:"Delivery Date"
Skip:Yes
Color:Blue

[Field:LWSTitle]
Use:Name Field
Set As:"Sales Man"
Skip:Yes
Color:Blue

[#Line:DSP VCHDetail]
Add:Right Fields:Before:DSP VCHType:LWDDetail,LWSDetail
[Field:LWDDetail]
Use:Name Field
Set As:$LearnWellUDF1
Skip:Yes
Color:Blue

[Field:LWSDetail]
Use:Name Field
Set As:$LearnWellUDF2
Skip:Yes
Color:Blue

[#Collection:Vouchers of Ledger]
Compute:LearnWellUDF1:$LearnWellStr1
Compute:LearnWellUDF2:$LearnWellStr2

[#Part:Expinv Terms]
Add:Lines:Expinv SubTitle,LWTermP
Local:Field:Expinv SubTitle:Info:"Other Sales Detail"
Local:Field:Expinv SubTitle:Border:Thin Bottom
Repeat:LWTermP:LWTermPP
Invisible:Not @@IsInvoice

[Line:LWTermP]
Field:NameField
Local:Field:NameField:Set As:$Name
Local:Field:NameField:Widht:45% page

[Collection:LWTermPP]
ListName:"Delivery Date :" + #LWDDetail
ListName:"Sales Man  :" +#LWSDetail



HOW TO USE ABOVE CODE:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE 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\Party Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
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.

No comments:

Post a Comment