We all working in Tally because of it’s simple entry system ad simple reporting system. And Daybook is Backbone of Tally, here we can find everything related to vouchers. So today we will modified Tally daybook according to our need. In Daybook Summary we can extract GST Details, TCS-TDS details, Discount Details etc. of Vouchers and can show all things in Daybook 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 Tally Daybook as per our need.
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 Daybook to see summary along with GST, TDS, Discounts etc.
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 Daybook
2. How to extract voucher GST, TDS etc. details
3. And Many More…….
TDL Code :
[#Line: DBTitle1]
Add : Right Fields : Before : DSP VchtypeTitle: LWIGSTT1,LWCGSTT2,LWSGSTT3
[Field: LWIGSTT1]
Use : NameField
width : 10
Set as : “IGST”
[Field: LWCGSTT2]
Use : NameField
width : 10
Set as : “CGST”
[Field: LWSGSTT3]
Use : NameField
width : 10
Set as : “SGST”
[#Line: DSPVCHDetail]
Add : Right Fields : Before : DSP Vchtype:LWIGSTD1,LWCGSTD2,LWSGSTD3
[Field:LWIGSTD1]
Use : Amount Field
Width : 10
Set as : $$AsPositive:($AllLedgerEntries[1, @@LearnWellLD1].Amount)
[Field:LWCGSTD2]
Use : Amount Field
Width : 10
Set as : $$AsPositive:($AllLedgerEntries[1, @@LearnWellLD2].Amount)
[Field:LWSGSTD3]
Use : Amount Field
Width : 10
Set as : $$AsPositive:($AllLedgerEntries[1, @@LearnWellLD3].Amount)
[System : Formula]
LearnWellLD1 : $LedgerName Contains “igst”
LearnWellLD2 : $LedgerName Contains “cgst”
LearnWellLD3 : $LedgerName Contains “sgst”
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:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty 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
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.
sir please provide cost center wise profit and loss tdl
sir how to add taxable value