With this amazing free TDL code we can get GST detailed summary as we want with one click.
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. May be it is best trick to get data from Tally according to our need.
HOW TO USE:
1. Load below GST Summary TDL code in Tally ERP9 or Tally Prime (Method provided below the code)
2. Paste this line in Narration : Select $Date, $VoucherTypeName,$VoucherNumber, $Reference, $Narration,$LWL1, $LWA1, $LWL2, $LWA2, $LWL3, $LWA3, $LWL4, $LWA4, $LWL5, $LWA5,$Amount from LearnWellColl where $VoucherTypeName=”Sales”
3. Now you will get sales report with every detail like GST Detail , Voucher Number, Voucher Type, References, Narration, Ledgers and there amount.
4. So after getting detailed summary of sales report, we can export it into Excel and do our work easily.
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 work in all Tally versions. for more detail watch above Video.
TDL Code :
[Collection:LearnWellColl]
Type:Voucher
Fetch:Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,Narration,Amount
Compute:LWL1:$$CollectionField:$LedgerName:1:AllLedgerEntries
Compute:LWA1:$$CollectionField:$Amount:1:AllLedgerEntries
Compute:LWL2:$$CollectionField:$LedgerName:2:AllLedgerEntries
Compute:LWA2:$$CollectionField:$Amount:2:AllLedgerEntries
Compute:LWL3:$$CollectionField:$LedgerName:3:AllLedgerEntries
Compute:LWA3:$$CollectionField:$Amount:3:AllLedgerEntries
Compute:LWL4:$$CollectionField:$LedgerName:4:AllLedgerEntries
Compute:LWA4:$$CollectionField:$Amount:4:AllLedgerEntries
Compute:LWL5:$$CollectionField:$LedgerName:5:AllLedgerEntries
Compute:LWA5:$$CollectionField:$Amount:5:AllLedgerEntries
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.
