Breaking

Excel2Tally-Ultimate_Ecommerce | Import E-Commerce Data into Tally and file GST on time | Best E commerce data import software

  This  is Excel to Tally Ultimate E commerce Automation to Import your E-Commerce Data Entry into Tally with Easy and quick way. With this...

Friday, 5 February 2021

GET DETAILED GST SUMMARY WITH ONE CLICK | BEST TALLY TDL 2021 | BEST TALLY PRIME TDL


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:\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