2022 Best Free Tally Prime and Tally ERP9 Invoice customization TDL | Free Tally TDL Code to customize Invoice | How to create colored Tally Invoice

1 September 2022

In a firm we all need to conduct work professionally to impress our consumers. If we present professional appearing invoice to customer, undoubtedly they will impress with our store or organisation. If you use Tally accounting software, you are in the correct spot. Tally uses a straightforward yet robust invoicing style that may contain anything. Tally Invoice, however, does not appear professional. Therefore, we will create a colourful invoice today. The item headings and other areas of the invoice are coloured.With the help of this free Tally TDL code, we can customise and colour the Tally invoice item column information to suit our needs. 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 Invoice. Colored Tally Invoice TDL Code: How to use Invoice customization TDL code: HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now create an invoice and take it print You can see changed header of item details section and changed color of invoice. 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. How to use Tally Invoice customize TDL video: Watch above video to learn : How to change names in invoice print How to add color in invoice print. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\invoicetdl.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your Invoice TDL is ready to use

3rd Richest Person – Adani | Gautam Adani become World third richest | Gautam Adani net worth and business

30 August 2022

With a net worth of $ 137.4 billion, Indian billionaire Gautam Adani is now the third-richest businessperson in the world (about Rs 11 lakh crore). He passed French businessman Bernard Arnault to take this job. This marks the first time an Asian has been in the Bloomberg Billionaires Index’s top three. He is now only ranked after Bezos and Musk. Elon Musk, the founder of Tesla, is ranked first with a net worth of $251 billion, followed by Jeff Bezos with $153 billion. The only other Indian in the top 10 is Adani. Mukesh Ambani, the chairman of Reliance Industries, is ranked 11th with a net worth of $91.9 billion (Rs 7.3 lakh crore). Also read Jio Cloud PC and Air fiber Gautam Adani overtook Bill Gates last month: Adani rose to the fourth-richest businessperson last month. He surpassed Bill Gates. Adani’s net wealth increased by $60.9 billion alone in 2022. This is five times what every businessman makes. In February, he became richer than Mukesh Ambani, chairman of Reliance Industries. Adani’s net worth was $57 billion in April 2021: On April 4, Adani became a member of the club of millionaires. Centibillionaires are people whose net wealth is greater than $100 billion. Adani’s net worth was $57 billion in April of 2021. In the fiscal year 2021–2022, Adani’s net worth increased at the quickest rate in the whole globe. Seven firms owned by the Adani Group are publicly traded. Adani’s cement business too: The Indian cement division of Holcim had been announced to be purchased by Gautam Adani’s company earlier in May. $10.5 billion was spent on the transaction. The Adani Group quickly climbed to second place in the Indian cement industry as a result of this purchase. India’s largest private port operator: The largest private port operator and end-to-end logistics service provider in India is Adani Ports and Special Economic Zone Limited (APSEZ Ltd.). It has developed a portfolio of port infrastructure and services across India in less than two decades. The nation’s port capacity is represented by its 13 well-located ports and terminals, which total 24% of the total. Adani’s Group Journey: Listed in NSC and BSC in 1994 under Rs.150/share Started trading from Mudra Port in 1995 Started a Joint Venture with Wilmar in Singapore in 1996 2001 Started City Gas Distribution Business 2009 Indonesia’s Banyu mine acquired 2010 Australia’s Karmickal mine acquired Started manufacturing solar PV panels in 2017 Fortune emerges as largest food FMCG brand in 2018 Emerged as the world’s biggest IRM player in 2019 2020 entry into airport business

2022 Tally Prime and Tally ERP 9 Free TDL Code to create alphabetical stock items | Create more attractive invoices by sorting stock items in alphabetical Order | Best Tally Prime TDL free code

30 August 2022

We may use this free Tally TDL code to generate a flawless invoice for our clients if you print an invoice from Tally but it doesn’t seem great due to a random stock item serial. Yes! We may now print invoices with alphabetically ordered items.By sorting stock items in Tally Invoice, we may create a flawless invoice with this item sorter (Tally TDL). We may add or remove new fields from this Tally Prime and Tally ERP TDL code in accordance with our needs, and it will function flawlessly with Tally Erp9 and Tally Prime. The best basic TDL code for sorting stock items alphabetically in invoice printing. 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. Best simple tdl code to make invoice with alphabetical items. TDL Code: How to use Invoice with alphabetical Item TDL code: HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to generate invoice and fill multiple stock items Then take a print of that invoice voucher. You will find all items in alphabetical order in print. 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. How to use Item history TDL video: Watch above video to learn : How to create a TDL to sort item names. How to create collection with repeat option for Tally TDL FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\alphabetialItems.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your alphabetical item in invoice TDL is ready to use

Full Detailed Item History TDL at Invoice Time | 2022 Best Tally Prime and Tally ERP 9 TDL for Invoicing | Sales and Purchase History TDL

29 August 2022

We always need something special that solve all our problems and create all things in simple way according to our need. Same things we required when invoicing in Tally. When we select any item in Tally invoice we need to see it’s history of sales and purchase with all details. Like when this item was purchased or sold, who was the customer, Date, item rate, quantity,discount etc.. Everything we need to know about that item. So today I have special full detailed item history TDL at invoice time for your Tally Prime and Tally ERP9. With this free TDL code we can see Invoice number, Date, voucher type, Party Detail, Item Rate, Discount, Amount, Godown etc. in One place. Load TDL file in Tally ERP9 or in Tally Prime, then go for invoicing , select item and press Alt+H to see full history of stock item with Sales, Purchase, Debit and Credit Note History. 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. Best simple tdl code to make see full Item History Detail. TDL Code: How to use Item detailed history TDL code: HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to generate invoice and select item and and press ctrl+H to see item history. In item history you will find Sales and Purchase details of item with there Date, Party Name, Voucher type, Invoice number, item rate, item discount, quantity, godown etc. everything in one place. 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. How to use Item history TDL video: Watch above video to learn : How to add see item full history tdl. How to load tdl code in Tally prime and how to use Tally shortcut button for item history TDL. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\itemhistory.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your Item full history TDL is ready to use

2022 best Free TDL code to stop negative billing | Best free Tally Prime TDL codes | New Tally Prime TDL Codes | Controlling Negative Stock entry in a Voucher

28 August 2022

Sometimes we accidentally send our clients the erroneous invoice because we either don’t have the item in stock or it has a negative value. Stock item mismatch results from this.However, we can now prohibit negative billing in both creation and alteration modes thanks to this free Tally TDL code. This Tally Prime and Tally ERP Stop negative billing code allows us to add or delete additional data as needed and is compatible with both Tally Erp9 and Tally Prime. Most effective TDL code for preventing negative billing TDL Code: How to use stop negative billing TDL code: HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to generate invoice and select item and put quantity of item. If this item no have closing stock, then you can not proceed further in invoice, it will stop negative billing and show you a message. 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. How to use negative billing control video: Watch above video to learn : How to add message box for item in invoice. How to alter Tally fields through TDL code. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\stopnegativebilling.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your control negative billing TDL is ready to use

Attach Document in Voucher | 2022 Best Free Tally Prime and Tally ERP9 TDL | Voucher with Attachment TDL

24 August 2022

We put a lot of effort into making everything great. Tally is now the most useful accounting and business software, and we may alter Tally to suit our needs due to TDL Codes. In this post we will see how to Attach Document in Voucher. Sometimes while creating vouchers for things like sales, purchases, journal entries, and payments, we wonder whether we may include any crucial scans of documents. Yes! It is much faster to attach a document in Tally Voucher than to search through files and other locations. Simply open Tally to view the attachment. This will both save us a tonne of time and help us avoid making mistakes. I thus have a very essential task for you and your company. With this amazing free Tally ERP9 and Tally Prime TDL code we can  attach any document, when we creating vouchers and can see it latter.Your documents can be in JPG or Pdf or any other form. This Tally TdL make our work more effective and accurate. This is must have  TDL file for Tally ERP9 and Tally Prime that can use for lifetime.  It will work in all Tally versions. for more detail watch the video. TDL code: HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to create vouchers, there you will find a space to paste file path. And same you will find Open file button in side bar to open attachment of vouchers at any time even after saving a voucher. 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 : How to see how to create own field in Tally voucher screen. How to create side bar button in Tally. How to use storage in Tally TDL FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\attachement.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your voucher with attachment TDL is ready to use.

Prevent Master duplication TDL | 2022 Best Tally Prime and Tally ERP9 TDL to Prevent Duplicate Ledger and Item

21 August 2022

Stop Master duplication in Tally TDL can boost your business performance. Tally is a most usable business software in India because of it’s simplicity and reporting system. If you maintain your masters and vouchers correctly in Tally then it will become life saving tool for business. But sometime by mistake we create some duplicate masters with another name and by repeating this mistake we make our Tally Data a garbage and can not create a proper reports. So we need to avoid this type mistakes if we want to do proper accounting.  To avoid this type mistakes I have something special for our Tally. We can create a TDL to avoid master duplication so we can do all things in proper way.  So today in this post we will create a TDL for our Tally prime and also for Tally ERP9 to prevent duplicate masters. In this TDL we will add a Master list in Tally Master creation screen so when we go to create masters first we track the name of Ledger or Item that we want to create then after searching we can create unique masters. This is must have Tally TDL for Tally Prime and Tally ERP9 to prevent master duplication.With this Free Tally Prime TDL, we can add ledgers and item lists in our master creation screen that can be tracked by typing present names in Tally master.In this code we do two steps – one for Ledger master and another for Item masters. TDL Code HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to create Ledger or Stock Item Master There you will find ledger list or item list and can search the name before creating new master. 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 : How to add master table in Master creation screen. How to alter Tally Master creation screen fields and parts FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Stop Duplicate.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your prevent duplicate TDL is ready to use

Data Analysis Tally Prime | Best Reports of Tally Prime | Generate Important reports without TDL

19 August 2022

Friends we all use Tally because of it’s simplicity and powerful reporting system. With Tally we can do our accounting easily. Tally have lots of reporting system that we use on daily basis. But some reports we generate via TDL Files, and we don’t know that Tally already have this type reports. So Today I have something special for your reporting systems and MIS .Today I have Data Analysis system of Tally that can fulfill your lots of MIS requirements. Data Analysis facilitates is conducting internal analysis and verification of the company’s financial data. Data Analysis will help in identifying exceptional areas and thereby ease the process of verification. With the help of Data analysis we can create our important MIS reports also. Data Analysis facilities have both Tally Prime and Tally ERP9. But in Tally Prime have more features with easy to use modules. So in this post you will read about Tally Prime Data Analysis. How to view Data Analysis Report in Tally Prime: There is two methods to find data analysis reports: Gateway of Tally > Display More Reports > Analysis & Verification > Data Analysis. 2. Alternatively, press Alt+G (Go To) > type or select Data Analysis Reports > and press Enter Various tools are available in Data analysis section of Tally Prime that can be use for various purpose. Follow below sections/tab of Tally to know more: Verification of Chart of Accounts Verification of Stock Items Verification of Balances Analytical Procedures Pending Documents Periodic Payments and Receipts Repeated Transactions Relative Size factor (RSF) Inter Bank Transactions Cash Withdrawals/ Deposits to Bank Fixed Assets Analysis Transaction on holiday Highest and Lowest Value Transactions Pending Advances Stale Cheque /Instruments (Please watch the above video to see another use of Data Analysis Facility of Tally Pirme and how to use other options and buttons of Data Analysis Facility of Tally Pirme.) Verification of Chart of Accounts – Drill down into this report will help to scrutinize the Chart of Accounts and compare this with previous year Chart of Accounts and suggest the necessary corrections if required. Verification of Stock Items – Drill down into this report will help to scrutinize various Stock Items and compare the Stock Items list with the previous year. This will help in taking necessary decisions and provide necessary corrections. Verification of Balances – Drill down into this report will help to scrutinize the difference in Opening Balances and transaction details during the selected year and suggest necessary corrections based on the exceptions highlighted. The user can also generate the ledger wise variance report for the Closing Balances. Analytical Procedures – This report can be used to analyse the data based on various parameters (e.g. Group, Cost Centre etc.) by a detailed comparison mechanism available. The user can take of note areas where more attention is required. Pending Documents – This report will display all the Pending Bills, Sales Orders, Purchase Orders and Receivables & Payables during the analysis year. Periodic Payments and Receipts – This report provides the list of recurring Ledger Vouchers based on the Periodic Ledgers identified by the users. Repeated Transactions – Drill down into this report will display the transactions for which the same amount is repeated more than once for each Ledger during the analysis year. The user can use this report to check the intentional errors while passing the entries. Relative Size factor (RSF) – Drill down into this report will display the Relative Size Factor for each Ledger Voucher which is arrived by dividing the highest Voucher amount to the second-highest Voucher amount for the Ledger Vouchers. Inter Bank Transactions – This report will display all the transactions carried out between the Banks during the analysis period Cash Withdrawals/ Deposits to Bank – Drill down to this report will display the bank ledgers from which the cash is withdrawn or deposits are made. This report also displays the Total Amount of transaction and the Number of vouchers through which the withdrawal or deposits are made during the selected year. Fixed Assets Analysis – This report provides the details of all the Fixed Assets possessed by the selected Company at the end of the analysis Year. Transaction on holiday – Drill down to this report displays all the transactions recorded on Weekly Off or Declared Holidays in the analysis year. Highest and Lowest Value Transactions – This report provides ledger wise Highest and Lowest value transactions carried out during the selected period along with Difference Range and Difference Range Percentage details. Pending Advances – Drill down to this report will display the ledgers for which the advances made (Loan given) are pending during the analysis year. Stale Cheque /Instruments – Drill down to this report will display the Bank Ledgers with stale cheque/ Instruments. This report also displays the Total amount and count of stale cheques/ Instruments. Also can use another buttons like, Basic of Value, Change View, Exception Reports etc. from side bar buttons of Tally to generate more type detailed reports.

Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost in Invoice Item List

17 August 2022

To do appropriate invoicing with stock items then you really want to have a deep understanding of items subtleties like Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost and so on when make receipt.Count have best arrangement about this kind invoicing with it’s TDL documents.So today we will make a TDL for Tally Prime and Tally ERP9 to see item all subtleties, even likewise can see when you deal it last time with Voucher Date.This is should have Tally TDL for Tally Prime and Tally ERP9 for invoicing.With this Free Tally Prime TDL, we can add thing extra subtleties. TDL Code HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to generate invoice and select item. Now we can see item additional 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 : How to add item details in invoice. How to alter Tally TDL collection. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\invoiceitem.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your Tooltip TDL is ready to use

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

8 August 2022

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. So lets create whatsapp sender in Excel VBA. Follow bellow steps to create whatsapp sender: First of all open a Microsoft Excel File Goto Developer Tab (If not enable developer tab in your Excel, watch above video) Add a module to write codes. Excel to Whatsapp Code: Paste above code in a VBA module Create Some contacts and messages in Excel  We can create Macro Button to send whatsapp messages. (Watch the above video) Now our whatsapp sender is ready to use.