Tally Prime TDL to Track Item Details

2022 Best Tally Prime TDL to Track Item Details | Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost in Invoice Item List TDL

by with One Comment Tally Prime TDLTDL 2022TDL for Tally
In this blog we will see about Tally Prime TDL to Track Item Details like HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost in Invoice Item List.
If you want to do proper invoicing with stock items then you need to know everything about item details like Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost etc. when create invoice.
Tally have best solution about this type invoicing with it’s TDL files.
So today we will create a TDL for Tally Prime and Tally ERP9 to see item all details, even also can see when you sale it last time with Voucher Date.
This is must have Tally TDL for Tally Prime and Tally ERP9 for invoicing.
With this Free Tally Prime TDL, we can add item additional details.
 

Tally Prime TDL to Track Item Details TDL Code:

 
[#Collection:VCH Stock Item Extract]
Add:Format:$Name,20
Add:SubTitle:$$LocaleString:”Item Name”,”HSN”,”GST%”,”STD Cost”,”MRP”,”VCH Date”,”Alias”,Cl Balance”
Add:Format:$GSTHSNCode
Add:Format:$GSTIGSTRate
Add:Format:$StandardCost
Add:Format:$MRPDetails[Last].MRPRateDetails[Last].MRPRate
Add:Format:$LastVoucherDate
Table Sort:$ClosingBalance
 
HOW TO USE :
    1. Copy the above code and make a text file
    2. Load in Tally ERP9 or in Tally Prime (Method provided below)
3. Go to generate invoice and select item.
     4. you will find item additional details and also can search item with any details.
 

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 add item details in invoice.
2. How to modify fields of invoice in Tally.
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Copy the code and make a text file.
2. Save 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 


Now your TDL is ready to use.
Find more on Our Other Website Engage to Tech
Send whatsapp from Excel

Send Whatsapp from Excel | Excel to Whatsapp Sender | Send Unlimited Whatsapp from Excel | Whatsapp Message Sender | Send bulk Message from Excel to Whatsapp

by with 5 Comments Excel VBAFREE EXCEL FILES
In this blog we will talk about how to Send Whatsapp from Excel. Now we can send bulk messages in Whatsapp from Excel. Before using the code, you must see above video.
Friends nowadays whatsapp become popular everywhere, and also for business. We send lots of business related messages to our customers or office employees, like outstanding details, invoice details, address etc. Sometime we need to send bulk whataspp messages to multiple contact. To avoid this lengthy process we need to make a tool that can send bulk whatsapp.
Also checkout Check Spelling Instantly Excel VBA code
So lets create whatsapp sender in Excel VBA. Follow bellow steps to create whatsapp sender:
1. First of all open a Microsoft Excel File
2. Goto Developer Tab (If not enable developer tab in your Excel, watch above video)
3. Add a module to write codes.

Send Whatsapp from Excel Code:

 
Sub Whatsappmst()
On Error Resume Next
Dim rowsz As Long
rowsz = 1000
rowsz = Wapp.Cells.End(xlDown).Row
Dim z As Integer
For z = 2 To rowsz
Dim ie As Object
Set ie = CreateObject(“InternetExplorer.Application”)
If Wapp.Cells(z, 2) = vbNullString Then
Exit Sub
Else
ie.navigate “whatsapp://send?phone=” & Wapp.Cells(z, 2) & “&text=” & Wapp.Cells(z, 3)
Application.Wait Now() + TimeSerial(0, 0, 3)
SendKeys “~”, True
End If
Next z
End Sub
 
4. Paste above code in a VBA module
5. Create Some contacts and messsages in Excel
6. We can create Macro Button to send whatsapp messages. (Watch the above video)
Now our whatsapp sender is ready to use.
Find more on our other website Engage to Tech
Simple Way to Connect Goolge Sheet with Excel

Simple Way to Connect Goolge Sheet with Excel | Google Sheet to Microsoft Excel Live Data Connection | Excel Power BI to Connect Google Sheet

by with No Comment ExcelExcel VBAFREE EXCEL FILES
In this blogpost we will see how to Connect Goolge Sheet with Excel in a simple way. Friends when have multiple branches or have offices on different locations, or want to work multiple people on same project or sheet. Then we simply use google sheet. In single google sheet many people can work from different computers. But sometime we need to handle it with Microsoft Excel and want to create reports according to our need. Same we can set and import Google sheet data into excel. And also can excess it live.
So let’s see how can import google sheet data into Excel and use live.:

Connect Goolge Sheet with Excel:

1. Goto Google Sheet
 
2. Open Document That want to import in Excel
 
3. Click on Share
 
4. Choose anyone with the link and copy link:
5. Now Open Excel – Goto Data – New query – From Other Source – From Web
6. Paste URL that you copied from Google Sheet:
7. Now do some changes in URL:
    Example
        Copied URL from Google Sheet:
https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/edit?usp=sharing
        New URL after Changes:
 
https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/export?format=xlsx

(Changes : edit to export ,  usp to format, sharing to xlsx)

 
8. Click on Sheet and Click on Load

Wait for some time . Now our google sheet will be loaded in Excel

We can refresh to fetch new changes.
Watch the above video for more details.
Automatic Last Rate and Last Discount Ledger Wise and Item Wise

Automatic Last Rate and Last Discount Ledger Wise and Item Wise | 2022 Best Tally TDL | Best Free Tally Prime TDL

by with No Comment Tally Prime TDLTDL 2022TDL for Tally
Remember, last time what discount you provided to customer and in which stock item; don’t worry this Automatic Last Rate and Last Discount Ledger Wise and Item Wise Tally TDL will help you. Sometime when we do accounting and create invoices of customer, there is lots of things to do in an invoice. We need to check customer all details like, there products, GST, Discount, Selling price, purchase price etc. When customer come to you and told that last time you provided this discount and product price was different, then you go to check there previous details and tell customer the truth that the price and discount was this. If we use Tally then these things become smooth, because of Tally TDL (Tally Definition Language). With TDL file we can fetch customer last purchase rate and item discounts. And at the same invoicing time we can check party last purchase rate and there discounts.

Automatic Last Rate and Last Discount Ledger Wise and Item Wise Tally Prime TDL:

So today have something special for your Tally. With this Tally TDL we can track customer or Ledger wise last rate and item discounts and can set it automatically in invoice. After adding this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL we can solve all our problems related to customer.
If you use Tally Prime or Tally ERP9, this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL will help to create invoice correctly . And always this will help to remember customer discounts and there item prices. 
This is must have Tally TDL for Tally Prime and Tally ERP9.
With this Free Tally Prime TDL, Now we can create invoice correctly without any fail.
 
HOW TO USE:
    1. Dowload TDL code with provided link
    2. Load in Tally ERP9 or in Tally Prime (Method provided below)
3. Go to generate invoice of any previous customer.
     4. you will find there last buying rate and last provided discount of any item.
 

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 fetch last rate and last discount ledger wise
2. How to modify fields of invoice in Tally.
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save 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 


Now your TDL is ready to use.
Download TDL file with below download button

Our other Website Engage to Tech

Item wise Discount Amount instead of Percentage

Item wise Discount Amount instead of Percentage | Tally TDL for Discount Amount in Invoice | 2023 Best Free Tally Prime TDL

by with 3 Comments Tally Prime TDLTDL 2022TDL for Tally
If you want to give direct discount in amount not with percentage then use this Item wise Discount Amount instead of Percentage TDL for Tally. Everything possible in Tally through TDL. If you want any invoicing or reports as per your requirement, then can create through TDL (Tally Definition Language).
At the same sometime we need to add discount amount for Items instead of percentage.
With this we can add discount amount for all items at invoicing time.

Item wise Discount Amount instead of Percentage:

In this Tally 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 Prime. Best simple tdl code to add item discount as amount in invoice.
 
HOW TO USE:
 
        1. Copy below TDL code and make a text file.
        2. Save text file then load in Tally Prime (Method provided below the code)                   
        3. Now go to Sales Voucher for invoicing.
        4. Now we can put amount in the place of discount %.
 

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 add own fields and lines in Tally
2. How to alter Tally field section.
3. And Many More…….
TDL Code : 
 
 
[#Field: VCH DiscTitle]
Set as: “Disc Amt”
[#Field: VCH Discount]
Delete: Format
Add: Format: “Nopercent,NoZero”
[#Field: VCHBATCH Discount]
Delete: Format
Add: Format: “Nopercent,NoZero”
[#Field: VCH Value]
Resetval: if (@@NoBaseUnits OR $$IsEmpty:BilledQty) then $$Value else (($Rate * $BilledQty) – $Discount)
 
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)
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.

Our another website Engage to Tech

Track Details with Additional Fields

Track Details with Additional Fields | TDL to add own fields in Voucher and Group Summary | 2023 best free Tally Prime and Tally ERP9 TDL

by with No Comment Tally Prime TDLTDL 2022TDL for Tally
Want to add your own details in voucher and Stock Summary, then this Track Details with Additional Fields Tally TDL will help you. In Tally at vouching time we need to see party additional details like, Party Contact details and GST number and also we need to see Item last sale and purchase price when select item in voucher. After this also we need to ledger notes and party contact details in group outstanding summary to track outstanding properly.
So with this free Tally TDL code we can add additional fields in our Tally software.
Now see contact details, ledger notes, item last sale price, Item Last purchase price etc. in fixed fields. Track Details with Additional Fields.

Track Details with Additional Fields:

In this Tally 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 Prime. Best simple tdl code see party additional details, item last sale and last purchase price in voucher and group outstanding with party contact details and ledger notes in Tally.
 
HOW TO USE:
 
        1. Copy below TDL code and make a text file.
        2. Save text file then load in Tally Prime (Method provided below the code)                   
        3. Now go to outstanding reports, or vouchers .
        4. Now we can see contact details of ledgers, items and notes 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 add own fields and lines in Tally
2. How to alter Tally field section.
3. And Many More…….
TDL Code : 
 
[#Line:DSP ACCLine]
option:LearnwellOS
[!Line:LearnwellOS]
Add:Field:LWOS
[Field:LWOS]
Set As:$Narration + ” – ” + $LedgerContact + “-” + $LedgerMobile
color:red
 
[#Line:EI consignee]
option:LearnwellVC
[!Line:LearnwellVC]
Add:Field:LWVC
[Field: LWVC]
Set As:$LedgerContact:Ledger:#EIConsignee + “-” + $LedgerMobile:Ledger:#EIConsignee + ” GST:” + $PartyGSTIN:Ledger:#EIConsignee
Width:40
color:red
skip:yes
 
[#Line:VCHBatch ColumnOne]
option:LearnwellItem:@@Issales
[!Line:LearnwellItem]
Add:Field:LWIT
[Field:LWIT]
Set As:$LastSalePrice:StockItem:$StockItemName
color:red
skip:yes
 
[#Line:VCHBatch ColumnOne]
option:LearnwellItemP:@@IsPurchase
[!Line:LearnwellItemP]
Add:Field:LWITP
[Field:LWITP]
Set As:$LastPurcPrice:StockItem:$StockItemName
color:red
skip:yes
 
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)
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.

Our Another Website Engage to Tech

Tally Tool Tip

Tally Tool Tip | Sticky Notes for Tally | Notification TDL for Tally | 2023 Best Free Tally Prime and Tally ERP9 TDL

by with No Comment Tally Prime TDLTDL 2022TDL for Tally
If you want to add sticky notes for Tally then this Tally Tool Tip TDL will help you a lot. When we use any software or tool related to our business, every time we need help or reminder messages to work properly. In this tool tip and sticky notes play important role. With Tooltip and sticky notes we can find out our problems and solve it easily. In Tally there is no tool tip or sticky notes, so sometime we forgot important things. But with Tally TDL (Tally Definition Language) we can modify our Tally software and can add tool tip for vouchers, group summary and ledgers etc.
In Tally TDL tool tip option play important role, by this we can add tool tip like sticky notes. With this we can see ledgers note, ledgers contact details and also can see last sale or purchase rates for billing items. Like this we can create other reports also by adding tool tip in Tally fields section.

Tally Tool Tip TDL:

In this TDL code we use Tally tooltip facility. In this Tally 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 Prime. Best simple tdl code see tool tip and sticky notes in Tally.
 
HOW TO USE:
 
    1. Copy below TDL code and make a text file.
    2. Save text file then load in Tally Prime (Method provided below the code)
3. Now go to outstanding reports, or vouchers and move cursor on ledgers.
    4. Now we can see tool tips for that 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 add tool tip option in Tally
2. How to alter Tally field section.
3. And Many More…….
TDL Code : 
 
[#Field:DSP DispName]
tooltip:$Narration + ” – ” + $LedgerContact + “-” + $LedgerMobile
 
[#Field: EI Consignee]
Tooltip:$LedgerContact:Ledger:#EIConsignee + $LedgerMobile:Ledger:#EIConsignee
 
[#Field:VCHBatch BilledQty]
Tooltip:$LastSalePrice:StockItem:$StockItemName
 
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)
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.

Our another website Engage to Tech

How to get Excel Cell value in Excel Power Query

How to get Excel Cell value in Excel Power Query | How to fetch Date from Excel sheet to Excel Power BI | How to Collect Tally Data in to Excel | Tally to Excel Import

by with 2 Comments ExcelExcel VBA
How to get Excel Cell value in Excel Power Query and How to fetch Date from Excel sheet to Excel Power BI let’s learn in this blog post. Excel power query is an amazing tool in excel. With Excel Power Query / Excel Power BI we can collect Tally Data in to Excel through ODBC connection. And can import Tally Live Data in to Excel.

How to get Excel Cell value in Excel Power Query:

If you see previous post, you observe that there we can change dates in our code only. So we need to change date etc. from our excel sheet without going in power query code. This will be simple method to collect data from Tally.


How to Connect Excel Cell Value (Date) with Power Query:

  1.  Write Headings for Cell Value (Like : From Date and To Date)
  2. Fill Date below the Headings
     3. Select Dates with Header.
     4. Right Click on selected cells
     5. Choose Get data from Table/Range
        6. Click on My Table has headers and Click OK
       7. Now you will reach in power query code.
       8. In power query Dates will come with time.
       9. Remove time by changing datetime into Date in power query code
to
        10. After changing in Date, Right Click on From Date header – Change Type – Using Locale
      11. Keep Data Type Text and Locale – English and Press OK
        12. Repeat same process fro To Date (Right click on ToDate – Change Type – Using Locale – Text and English – OK)
        13. Right Click on Date and choose Add as new query
        14. Repeat same process for second date
        15. Now Change From Date and To Date name in properties (name without any space)
        16. Now You can use FromDate and ToDate in another power query code of this sheet.
For More clarification Please watch Above Video:
BUSINESS SUMMARY TDL

BUSINESS SUMMARY TDL | Business Summary TDL for Tally Prime | 2023 best Tally Prime TDL

by with No Comment Tally Prime TDLTDL 2022TDL for Tally
Business Summary TDL will help to summarized your company all mis amounts. We must do accounting to maintain business books and see it’s progress. If you use Tally to maintain business accounting and maintain it’s books, always create a business summary to follow your profits and customers along with top lists of ledger account. So today I have something special to create a business summary of your Tally books. In Tally we can customize our reports with TDL (Tally Definition Language ) files.
With this Tally TDL we can find out our business summary within a second. In this Tally Prime TDL we can see reports for a fixed period, like Profit loss, Sale purchase, cash and bank reports, outstanding of top customers and top selling products in single click. This is best Tally TDL file to have in your Tally.

Business Summary TDL for Tally Prime:

With this Free Tally Prime TDL, Now we can create our business summary with top selling and supplier ledgers and products, top receivables and payable, profit and cash flows etc.
 
HOW TO USE:
 
        1. Dowload TDL code with provided link
        2. Load in Tally Prime (Method provided below) 
        3. Now you will find Business button on top of Tally between toolbar buttons
        4. Set period and click on business button to see business summary
 
This is best free TDL to have in your Tally . This TDL can use for lifetime.
This free TDL Code will perfectly work with Tally Prime.
 
Watch above video to learn :
1. How to use business button
2. How to modify TDL code
3. And Many More…..
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save 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 
 


Now your TDL is ready to use.
Download TDL file with below download button
 
Tally Prime Auto Backup

Tally Prime Auto Backup | Automatic Data Backup TDL for Tally Prime | 2023 Best Tally Prime Auto Backup TDL | Free Tally Backup TDL

by with No Comment Tally Prime TDLTDL 2022TDL for Tally
Tally Prime Auto Backup TDL will help to get autobackup date and time wise. We always work hard and want to try finish our work on time. In life we can not restore our past life backup. But in Tally software it allow to restore data backup and works smoothly without any error.
It is very important in working to take software backups to solve our mistakes by restoring data backup.
If you use Tally Prime or Tally ERP9, this Auto backup TDL will help to create backups of data at company open and company close time. And always this will help to remember to create backup file of your working company.

Tally Prime Auto Backup:

This is must have Tally TDL for Tally Prime and Tally ERP9.
With this Free Tally Prime TDL, Now we can create Tally Data backups without any fail.
 
HOW TO USE:
 
        1. Dowload TDL code with provided link
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. When open or close any company it will ask to take backup of Tally Data
        4. Press enter or Click on Yes to create a back of files with Date and Time
 

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 create backup of Tally Data.
2. How to see backup list with date and time.
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save 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 
 


Now your TDL is ready to use.
Download TDL file with below download button