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

Wednesday, 7 July 2021

FULL DETAILED BALANCE SHEET, TRIAL BALANCE, PROFIT AND LOSS | FREE TDL CODE FOR TALLY PRIME AND FOR ERP9


Tally provide us best reports to complete our work on time with simple way. After making entries we generate important reports and useful reports like Balance Sheet, Trial Balance and Profit loss. We Create Masters, Ledgers, Group, Invoice, Vouchers etc to create all the reports. In this sometime we get less details in Balance sheet , Trial Balance and P & L. There is some hidden ledgers in group in detailed format of balance sheet etc. But now with this free TDL code we can see full detailed Balance Sheet, Trial Balance and Profit Loss account..  Yes! You are in right place to create these type reports with a simple free TDL code of Tally Prime and Tally ERP9
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 Generate full detailed Balance Sheet, Trial Balance and Profit and Loss.

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 for Balance Sheet, Trial Balance or Profit loss Account, here you find all ledgers with group details and there amount.

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 Explode groups in full detail
2. How to Modify Balance Sheet, Trial Balance and Profit loss
3. And Many More.......

TDL Code : 

For Balance sheet and Trial Balance

[#Part:DSP ACCBody]
Lines:DSP ACCLine
Repeat:DSP ACCLine:TrialBal GroupLedgerChildofGroupName
Scroll:Vertical
Local:Line:DSP ACCLine:Delete:Explode
Local:Line:DSP ACCLine:Add:Explode:DSP ACCBody:$$IsGroup AND (@@IsWKGCapItem OR @@LearnwellGroupDT)
Local:Line:DSP AccLine:Delete:Space Top


[#Part:BSGRP Explosion]
Lines:BS Detail
Repeat:BS Detail:BS GroupLedgerChildofGroupName
Scroll:Vertical
Local:Line:BS Detail:Delete:Explode
Local:Line:BS Detail:Add:Explode:BSGRP Explosion:$$IsGroup AND (@@IsWKGCapItem OR @@LearnwellGroupDT)
Local:Line:BS Detail:Delete:Space Top

[System:Formula]
LearnwellGroupDT:$$KeyExplode OR ##ExplodeFlag


TDL Code For Detailed Profit and Loss



[#Part:BSGRP Explosion]
Lines:PL Detail
Repeat:PL Detail:BS GroupLedgerChildofGroupName
Scroll:Vertical
Local:Line:PL Detail:Delete:Explode
Local:Line:PL Detail:Add:Explode:BSGRP Explosion:$$IsGroup AND (@@IsWKGCapItem OR @@LearnwellGroupDT)
Local:Line:PL Detail:Delete:Space Top

[System:Formula]
LearnwellGroupDT:$$KeyExplode OR ##ExplodeFlag


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