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.
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
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.
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
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.
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
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.
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
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.
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:
Write Headings for Cell Value (Like : From Date and To Date)
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.
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.
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
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
If you want to Connect Tally with Excel to Get GST Summary then follow this simple process. Always required Excel in a business or accounting to maintain books of income, expenses and taxes etc. Excel is most usable software for calculations/presentations for a business. And also lots of businesses use Tally to maintain books properly. If it possible to connect Tally with Excel to fetch Tally Data into Excel then our most of problems will be solved. This Tally to Excel data import method will be “Sanjeevani” for CA and accountants.
So this can possible through Excel Power Query and Tally ODBC connectivity. To Import Tally Data into Excel most powerful and fastest way is Excel Power BI. We can import any report of Tally directly into excel through this Power BI method.
Connect Tally with Excel to Get GST Summary:
After reading this post you will be able to import GST summary from Tally to Excel and can refresh it every time after any changes.
Required Tools/Codes to connect Tally with Excel:
1. Microsoft Excel
2. Tally Software
3. Tally ODBC URL
4. XML Schema for Export
5. Report Name
Follow below Steps to Import Data from Tally to Excel:
1. Open Tally and Excel
2. Go to Excel Data Tab – New Query – From Other Source – Blank Query
3. We can change Query Name in properties section at right hand side.
With Tally ODBC Port (Open Database Connectivity(ODBC) we can dynamically exchange data between Tally Prime/Tally.ERP 9 and any other application dynamically.
When we enable Tally ODBC a DSN file will be created in our computer document folder.
In Audit Trial Rule The Ministry of Corporate Affairs (MCA) issued a notification directing companies that use accounting software for maintaining their books of account is required to have an Audit Trail feature, creating an edit log of all transactional changes along with the date.
According to the recent notification, the new audit trail rule in accounting software will now be implemented from 1st April,2023. This was originally planned for 2021 and but later the effective date was moved to 1st April,2022. Now, it is postponed to 1st April, 2023.
To ensure that this is being implemented, companies need to ensure that their existing accounting software comprises an audit trail feature to remain compliant to the latest amendment. With this move, business entities would now be required to keep an edit log of all transactions and time stamps, with changes made in the books of account. They also need to enable their workforce to adhere to it. In case their existing software doesn’t come with this feature, they need to consider shifting to accounting software that provides the audit trail feature.
With the audit trail (edit log) mandated by MCA, you might have questions if the rule is applicable to all businesses? Applicable only for a set or type of companies? Are there any guidelines that define the business applicability of the edit log rule?
To answer, the audit trail (edit log) rule is not applicable for all businesses. This rule applies only to those companies that fall under the purview of Ministry of Corporate Affairs (MCA). In short, if your company is governed by the regulations and guidelines of MCA, you need to ensure you follow the rule from 1st April,2023.
As per the Companies Act 2013, the new amendment released by the MCA will be applicable to the following companies, including the companies that are managed by State and Central Government, NGOs who are receiving funds from various stakeholders:
All Public and Private Limited Companies
One Person Companies (OPCs)
Companies owned by Government of India
State Government Companies
Not-for-Profit Companies/Organization
Nidhi Companies
Businesses who are outside the purview of audit trail rule
The following businesses don’t fall under the purview of the audit trail rule:
Individuals
Proprietorship concerns
Partnership firms
LLP-Limited Liability Partnership
Reasons and implications of the new audit trail rule
It is undeniable that having an end-to-end log of all financial events like purchases, sales, and expenses can be proven beneficial to back trace any anomalies in the system. The edit log would, further, enable businesses to analyse each activity, thereby helping in remaining compliant.
The new rule has been introduced to bring transparency and restrict or reduce data manipulation of companies. This also implies that all accounting software is required to have the Audit Trail feature to ensure that their users are compliant with the new amendment and must comprise of the following enhancements:
Track and create an edit log of all transactional changes made in the books of account
Capture all timeline details like date whenever any changes are done
Accounting software must ensure that the edit log cannot be disabled
Audit trail (edit log) features of TallyPrime Edit Log Release 2.1
The latest release ‘TallyPrime Edit Log Release 2.1‘, is enhanced with the edit log feature that caters to the amendment released by the Ministry of Corporate Affairs (MCA). Following are the features of TallyPrime edit log release:
Track the edits for masters and every transaction
Capture the date details and username when such changes (edits) are made
Difference report to show the elements of the version that have been modified
Reports are enhanced to filter the edited transactions
Designed to ensure edit log feature will be enabled all the time to meet the MCA guidelines of ‘Edit trail cannot be disabled.
Watch the above video to see how to use audit trial rule