With this Tally TDL we can customize our group summary and can use this TDL to add Bank Details in Group Summary. Adding bank details in group summary will help you to make payments to customers in simple way. You can find customers bank details on outstanding list to create payments in simple way.
TDL to add Bank Details in Group Summary:
Using Tally Definition Language (TDL) to add bank details in the Group Summary is a valuable customization for businesses using Tally Prime software. By integrating bank details such as account numbers, IFSC codes, and bank names within the group summary reports, companies can streamline financial operations and enhance transparency.
TDL to add Bank Details in Group Summary TDL Code:
To add bank details like, Account Number, IFSC Code etc, in Customer Outstanding Group summary use below Code:
[#Line: DSP CmpTitle]
Add: Field:After:DSP NameTitle:AccName,BankNumber,IFSC,Mobile
Border:Thin box
[Field:AccName]
Space Left:40
Set as:"Bank Name"
Width:20
Invisible:##DSPShowTrans
[Field:BankNumber]
Set as:"Account Number"
Width:20
Invisible:##DSPShowTrans
[Field:IFSC]
Set as:"IFSC Code"
Width:10
Invisible:##DSPShowTrans
[Field:Mobile]
Set as:"Mobile Number"
Width:10
Invisible:##DSPShowTrans
[#Line: DSP AccLine]
Add: Field:After:DSP AccName:AccNameD,BankNumberD,IFSCD,MobileD
Border:Thin box
[Field:AccNameD]
Space Left:25
Set as:$PaymentDetails.BankName
Width:20
Invisible:##DSPShowTrans
[Field:BankNumberD]
Set as:$PaymentDetails.AccountNumber
Width:20
Invisible:##DSPShowTrans
[Field:IFSCD]
Set as:$PaymentDetails.IFSCode
Width:15
Invisible:##DSPShowTrans
[Field:MobileD]
Set as:$LedgerMobile
Width:15
Invisible:##DSPShowTrans
[#Field: DSP NameTitle]
Background:red
Tally Prime TDL to Add Bank Details in Sundry Creditors List:
HOW TO USE TDL CODE:
Copy above TDL code and create a text file.
Save text file and load in Tally
Add Bank Details in Sundry Creditors Party Ledgers.
Now go in Group summary of Sundry Creditors.
You will find Party’s Bank Details in Group summary.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Tally TDL to Add Bank Details in Group Summary Video:
See the below video to learn how to add Bank details in Ledger and How to add bank Details in Group Summary through this Tally Prime TDL:
Watch above videos to learn :
How to use TDL files in Tally.
How to add Bank Details in Party Ledger.
How to add Bank Details in Sundry Creditors Group summary.
If you use Tally and create lots of Invoices and print every time, then this Tally TDL to Automatic Save Invoices and Vouchers can help you. This Tally Prime TDL will help you to save Invoices and Vouchers immediately on your computer after creating in Tally.
Tally TDL to Automatic Save Invoices and Vouchers:
Tally TDL (Tally Definition Language) enables businesses to customize and extend the functionality of Tally. This Tally Prime TDL allows invoices and vouchers to be automatically saved upon creation, eliminating the need for manual saving and reducing the risk of errors or omissions. This TDL will save vouchers and Invoices in PDF format on your computer.
Tally Prime TDL to Save Invoices and Vouchers on Computer:
HOW TO USE TDL CODE:
Copy above TDL code and create a text file.
Save text file and load in Tally
Now go to Create a voucher or Alter a Voucher.
Now Vouchers will save in your computer (Change Folder path in code as per your computer).
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Tally TDL to Automatic Save Invoices and Vouchers Video:
See the below video to learn how to save invoices and vouchers in computer through Tally Prime TDL:
Watch above videos to learn :
How to use TDL files in Tally.
How to add computer path in TDL Code.
How to save invoices and vouchers in computer folder from tally.
In this blog post we will customize Letter Head Invoice through Tally Prime TDL. Tally is best business software around the world, and more popular in India. And also we can customize Tally according to our need through TDL (Tally Definition Language).
In todays code we will learn how to do Invoice Customization to Print Tally Invoice in Letter Head.
Letter Head Invoice:
Letterhead invoice is a professional document used by businesses to request payment for services or products rendered. If you want to give a professional invoice to your customers, then you can use this Letter Head Invoice Tally Prime TDL, and can print Invoice directly on Letter Head from Tally.
This code will help to print your Tally invoice on Letter Head:
[#Part: EXPINV SaleTopLeft]
Height : If ($$InExportMode OR $$InMailAction OR $$InUploadAction) AND ($$IsSysNameEqual:Excel:##SVExportFormat OR $$IsSysNameEqual:HTML:##SVExportFormat) THEN +
(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) ELSE +
(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) % page
Delete: Parts: EXPINV Company
[#Form: Printed Invoice]
Add:Parts:LWCMPDetails
[part:LWCMPDetails]
Add:Parts:LWQR
[Part:LWQR]
Part :LearnWellQRIn,qrtxt
Vertical : Yes
[Part :LearnWellQRIn]
Horizontal Alignment :Left
Vertical : No
Lines :LWQrLn
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No."+$$String:$voucherNumber) : True
Height : 10% page
Width : 12% Page
[Line :LWQrLn]
Field :LWQrFn
[Field :LWQrFn]
Set As : ""
[Part:qrtxt]
Line:as
[Line:as]
Field:as
[Field:as]
Use:name field
Set as:"Scan to Pay"
[#Part: EXPINV Signature]
Delete:Border
[#Part: EXPINV Column]
Border:Thick Box
Delete:Line:EXPINV Column2
Local : Field : Default : Style :Normal Bold
Local : Field : Default : Print FG :White
Print BG:Black
[#Part:EXPINV Title]
Local: Line :EXPINV Title: Space top:1
Tally Prime TDL to Print Invoice on Letter Head:
HOW TO USE TDL CODE:
Copy above TDL code and create a text file.
Save text file and load in Tally
Now go to print an sales Invoice on letter head.
You will find that your invoice perfectly print on letter head.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Invoice Customization Tally Prime TDL Video:
See the below video to learn how to customize Invoice in Tally Prime through TDL:
MSME TDL for Tally Prime file can help you to customize your TallyPrime to suitable with Micro, Small, and Medium Enterprises (MSMEs) Businesses. Tally Prime, a popular accounting and business management software, offers a powerful solution of everything with the help of TDL files. In this blog post, we delve into the world of MSME TDL (Tally Definition Language) customization for Tally Prime, exploring its features and benefits.
With this Tally TDL we can add MSME number and MSME type in Company Details, Party Ledgers, Ledger Statements, Billwise outstandings and also in Invoice Printing.
Understanding MSME TDL for Tally Prime file:
TDL, or Tally Definition Language, serves as the customization language of Tally Prime. It allows users to extend the functionality of Tally Prime to suit specific business needs. MSMEs, with their unique requirements, can leverage TDL to optimize their accounting and operational processes.
Importance of Tally Prime MSME TDL:
MSMEs often face challenges such as complex invoicing, GST compliance, inventory management, and the need for customized financial reports. MSME TDL in Tally Prime becomes a valuable asset in overcoming these challenges, offering tailored solutions to streamline operations.
MSMEs can customize their invoices through TDL to reflect their MSME Number and Type Along with Customer’s MSME Number and Type. It will show in Company Details and in Buyer and Consignee Details
Ledger and Outstanding Reports:
MSMEs can create customized financial reports using TDL, tailoring them to their specific needs. This includes Ledger statements and Bill wise outstanding statements. This MSME TDL for Tally Prime will help to add MSME number and MSME Type in Reports.
MSME Number and Type in Company Detail and Party Ledger Details:
We can add MSME Number and MSME type of our company in Company section in Tally Prime and also We can add MSME Number and MSME type of our company in Ledger Creation section in Tally Prime.
MSME TDL Tally Prime Download Link :
Download full MSME TDL for Tally Prime with Below Link:
Fill MSME number and MSME type in Company Creation Screen.
Fill MSME Number and MSME type in Party Ledger.
Now you can see MSME Number and MSME typein Ledger Statements, and Bill Wise Statements and also in Print.
This is best TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
How to Create MSME TDL Code Video:
See the below video to learn how to Create MSME TDL file for Tally Prime:
Watch above videos to learn :
How to Modify Company and Ledger Details and Add Own Details in Tally through TDL Code.
How to Use Ledger UDF fields in Report and Invoice Print.
Here is Best Method to Change Display and Entry Language in Tally Prime 4.0. In India there are multiple languages used by people. We use languages like, Hindi, Gujarati, Tamil, Telugu, Kannad, Malyalam etc languages. Local language will be better to understand our business and people. And in Tally Prime we can change data entry language and also display language.
In this blog post, we’ll delve into the seamless language-changing capabilities of Tally Prime, with a focus on languages like Hindi, Gujarati, Tamil, Telugu, Arabic, Kannada, Malayalam, and more.
Change Display and Entry Language in Tally Prime 4.0:
Tally Prime makes it easy for users to switch the display language, ensuring that the software interface is accessible and user-friendly for individuals from different linguistic backgrounds. Here’s a step-by-step guide on how to change the display language in Tally Prime:
Open Tally Prime
Goto Help – Setting – Language
There are two Options 1st is Display language and 2nd is Data Entry language
We can select more options of languages in Data Entry languages. (But in Display language have only English. Follow below steps to add more languages in Display language also)
In this post we will add GST Details in Movement Analysis Tally Prime TDL that will help to track customer details along with there GST Number, Address and Mobile Number. We also add Stock Item GST details like GST Rate and HSN code.
Movement Analysis in Tally Prime plays a pivotal role in understanding the movement of goods, tracking stock transfers, and analyzing sales and purchases.
GST Details in Movement Analysis Tally Prime TDL:
By incorporating GST details within Movement Analysis, businesses can streamline their GST-related processes, ensuring compliance and facilitating seamless transactions.
How to Access Movement Analysis in Tally Prime:
Movement analysis report is used for comparative studies. They give an insight into the flow characteristics of the stock in an organization. It also helps in finding out the slow moving items which cause blockages in the flow of the working capital of the organization.
● Go to Gateway of Tally > Display More Reports > Statement of Inventory > Movement Analysis .
You can see additional details with ledgers and stock items.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Movement-Analysis Tally Prime TDL Video:
See the below video to learn how to customize Reports in Tally Prime through TDL:
Watch above videos to learn :
How to use TDL files in Tally.
How to customize tally Reports through TDL.
How to access movementanalysis of Tally.
How to add GST details of Ledgers and Stock Items.
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\MovementAnalysis.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 Custom MovementAnalysis TDL for Tally Prime is ready to use.
Integrating GST details within Movement Analysis in Tally Prime using TDL empowers businesses to streamline their operations, enhance compliance, and facilitate smoother transactions. By customizing the software to incorporate these essential details, businesses can navigate the complexities of GST requirements with greater ease and efficiency.
If you use Tally and have a fixed format of Invoice Print that looks basic, then you can try this Custom Invoice Tally Prime TDL.
With this Invoice Customization TDL for Tally Prime you can change font and size of heading of your Invoice and also can change font and size of your company details in invoice that looks better and professional.
Custom Invoice Tally Prime TDL:
With this Custom Invoice Tally Prime TDL we can modify the layout and design elements of invoices. Here’s what you can achieve through this customization:
Font and Size Modification of Invoice in Tally:
Heading Customization: You have the flexibility to change the font style, color and size of the invoice heading, making it more prominent and aligned with your brand’s visual identity. Company Details: Customize the font and size of your company details on the invoice.
Grid Lines on Item Details of Invoice in Tally:
Grid lines on item details area make Invoices more professional and clear look of Item details.
Enhanced Professionalism of Invoices in Tally:
By fine-tuning the fonts and sizes, you can create a more polished and professional look for your invoices, leaving a lasting impression on clients and stakeholders.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Invoice Customization TDL for Tally Prime Video:
See the below video to learn how to customize Invoice in Tally Prime through 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\CustomInvoice.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 Custom Invoice TDL for Tally Prime is ready to use.
In the competitive business landscape, every interaction with clients and stakeholders matters. Invoices, often overlooked as mere financial documents, present an opportunity to reinforce your brand’s professionalism. With the Custom Invoice Tally Prime TDL, you can transform the appearance of your invoices from basic to sophisticated, leaving a lasting impression and elevating your brand image.
If you want to file GST returns on Time without any error, then this GST Summary TDL is for you. With this GST Summary TDL for Tally Prime and Tally ERP9 you can see Invoice wise and Party wise and State wise GST Totals. It works like Pivot Table, that can help you submit your GST returns on time without wrong GST filing.
GST Summary TDL:
The GST Summary TDL enables users to access granular insights, breaking down GST totals at multiple levels—Invoice-wise, Party-wise, and State-wise. This level of detail ensures a thorough understanding of GST data before filing returns.
By functioning like a Pivot Table, this TDL minimizes the chances of errors in GST filings. Users can review and reconcile data accurately, significantly reducing the risk of incorrect GST submissions.
The ability to view GST data across different parameters. You can see Sales, Credit Note, Purchase vouchers in Single Screen.
GST Summary TDL code:
[#Menu : Gateway of Tally]
Add : Item : LearnWell GST :Display :Learnwell GST Summary
[Report :Learnwell GST Summary]
Title:GST Summary
Variables : SV CurrentCompany
Form :Learnwell GST Summary
Variable : SVFromDate,SVToDate
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Set : Is Day Book : Yes
[Form :Learnwell GST Summary]
Part :DSP AccTitles, LWTitles, LWGSTPurchase,LWDBTitle2Bot
Buttons : ChangeDybkDate,ChangePeriod
Background :Light Autumn Green
Page Break :LWPageBreak2
Width : 100 % Page
Height : 100 % Page
Space Bottom : 0.50
Space Left : 0.50
Space Right : 0.50
Space Top : 0.50
Vertical Align : Center
Horizontal Align : Center
[Part: LWPageBreak2]
Part: LWTitles
[Part : LWTitles]
Use : LWGSTPurchase
Delete : Repeat
Delete : Scroll
Border : ColumnTitles
Local : Field : Default : Type : string
Local : Field : LWParty: Set As : "Party Name"
Local : Field : LWGST : Set As : "GST No"
Local : Field : LWRef : Set As : "Ref No"
Local : Field : LWVCHv : Set As : "VCH No"
Local : Field : LWVCHd: Set As : "VCH Date"
Local : Field : LWVCHT: Set As : "VCH Type"
Local : Field : LWVCHs: Set As : "State"
Local : Field : LWRefDate : Set As : "Ref Date"
Local : Field : LWtotal1 : Set As : "Basic Amount"
Local : Field : LWtotal3 : Set As : "CGST "
Local : Field : LWtotal4 : Set As : "SGST "
Local : Field : LWtotal2 : Set As : "IGST "
Local : Field : LWtotal5 : Set As : "Invoice Amount"
Local :Field : Default : Style : Small Bold
Local: Field: Default: Align: Center
Local: Field: Default: Background: Very Light Orange
Border : Totals
[Part :LWGSTPurchase]
Line : LWGSTPurchase
Repeat :LWGSTPurchase :LearnwellCollGSTPur
tOTAL : LWtotal1,LWtotal2,LWtotal3,LWtotal4,LWtotal2,LWtotal5
Common Border : Yes
Scroll : Vertical
[Line :LWGSTPurchase]
Field :LWVCHT,LWVCHv,LWVCHd,LWRef,LWRefDate,LWParty,LWGST,LWVCHs,LWtotal1,LWtotal2,LWtotal3,LWtotal4,LWtotal2,LWtotal5
Option : Alter on enter
Option : DisplayOnAltEnter
[Field :LWRefDate]
Use : Short Date Field
Set As : $ReferenceDate
Border : Thin Right
Format:"Short Date"
Style:Small
[Field :LWVCHd]
Use : Short Date Field
Set As : $Date
Border : Thin Right
Format:"Short Date"
Style:Small
[Field :LWVCHv]
Use : Name Field
Set As : $VoucherNumber
Border : Thin Right
Width:10
Style:Small
[Field :LWVCHT]
Use : Name Field
Set As : $VoucherTypeName
Border : Thin Right
Width:10
Style:Small
[Field :LWVCHs]
Use : Name Field
Set As : $StateName
Border : Thin Right
Width:10
Style:Small
[Field : LWParty]
Use : NAme Field
Set As : $LedgerName
Width : 30
Border : Thin Right
Alter : Voucher
Display : Ledger Vouchers:$$ISLedger
Variable: Ledger Name
Style:Small
[Field : LWGST]
Use : Name Field
Set As :$PartyGSTIN:Ledger:$PartyLedgerName
Width : 11
Border : Thin Right
Style:Small
[Field : LWRef]
Use : NAme Field
Set As : $REFERENCE
Width : 10
Border : Thin Right
Align:Center
Style:Small
[Field : LWtotal1]
Use : Amount Field
Set As: $$CollAmtTotal:allinventoryEntries:$Amount + $$FilterAmtTotal:LedgerEntries:BASIC1:$Amount + $$FilterAmtTotal:LedgerEntries:BASIC2:$Amount
Border : Thin Right
Format:"DrCr,NoZero"
[Field : LWtotal3]
Use : Amount Field
Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Border : Thin Right
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal4]
Use : Amount Field
Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount
Border : Thin Right
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal2]
Use : Amount Field
Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount
Border : Thin Right
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal5]
Use : Amount Field
Set As : $Amount
Format:"DrCr,NoZero"
[System: Formula]
SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST"
CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"
IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST"
BASICS :$$FilterAmtTotal:LedgerEntries:BASIC1:$Amount
BASIC1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SALE"
BASICP :$$FilterAmtTotal:LedgerEntries:BASIC2:$Amount
BASIC2 :$Name:Ledger:$LedgerName Contains $$LocaleString:"PURCHASE"
[Collection : LearnwellCollGSTPur]
Type : Ledger
Type : Vouchers
Walk : allLedgerEntries
Filter : LWVoucherType
Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount
Fetch : *.*
Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100
Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2
Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2
[Part: LWDBTitle2Bot]
Lines : daybookTotalLine2
[Line: daybookTotalLine2]
Use : LWGSTPurchase
Local: Field: Default : Style : Small Bold
Local: Field: Default: Align: Right
Local : Field : LWParty: Set As : "Total"
Local : Field : LWRef : Set As : ""
Local : Field : LWtotal1 : Set As : $$Total:LWtotal1
LOCAL : FIELD: LWtotal3:Set as:$$Total:LWtotal3
LOCAL : FIELD: LWtotal4:Set as:$$Total:LWtotal4
LOCAL : FIELD: LWtotal2:Set as:$$Total:LWtotal2
LOCAL : FIELD: LWtotal5:Set as:$$Total:LWtotal5
Border : Totals
Local: Field: Default: Background: Very Light Orange
[System: Formula]
LWVoucherType : $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName
CSTFilter2 : not ##IsRevChargeAppl
Copy or Download above TDL code and create a text file.
Save text file and load in Tally
In Gateway of Tally you will find Learnwell GST Tab.
Click the Learnwell GST summary Tab to See the GST Reports.
Change Tally Period according to your need.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
GST Summary TDL Code Video:
See the below video to learn how to See GST Summary in Tally Prime:
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\GSTSummary.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 GST Summary TDL file for Tally Prime is ready to use.
The GST Summary TDL for Tally Prime and Tally ERP9 is a remarkable addition to the arsenal of tools available for businesses navigating GST compliance. Its ability to offer intricate insights, prevent errors, and expedite the filing process is invaluable in today’s regulatory landscape.
If you use Tally Prime 3 , there is no GST number in GSTR3B report, but we required sometime. so with this TDL file we can add GST number in GSTR3B report Also.
For businesses accurate and comprehensive reporting is crucial. Tally Prime 3, a prominent accounting software, is widely utilized for its robust functionalities, yet some users encounter limitations, particularly the absence of the GST number in the GSTR-3B report. Addressing this gap by customizing the report through TDL (Tally Definition Language) can prove beneficial.
GST Number in GSTR3B:
The GSTR-3B report acts as a vital summary, encapsulating essential tax details for a specific period under GST regulations. However, the absence of the GST number within this report in Tally Prime 3 could pose challenges for businesses needing this critical information for their records or compliance obligations.
[#Line:GSTRSTATVCHSColTitle1]
field:LWTitleGST
[field:LWTitleGST]
Set as:"GST Number"
Background:Yellow
Color:Red
[#Line:GSTRStatVCHSDtls]
Border:Thin Box
Field:LWGSTNu
[Field:LWGSTNu]
Set as:$GSTVCHPartyGSTIN
Background:Yellow
Color:Red
GST Number in 3B Report TDL:
HOW TO USE TDL CODE:
Copy above TDL code and create a text file.
Save text file and load in Tally
Goto see GSTR3B report, there you will find GST Numbers of Party along with Party name (watch the below video for more details).
Now You can see GST Numbers in 3B report in Tally Prime 3.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
GST Number in GSTR3B in Tally Prime 3 TDL Code Video:
See the below video to learn how to customize GST 3B report in Tally Prime:
With this Customized Invoice Tally Prime TDL we can provide professional invoices to our customers, even want to create Normal Invoice or E- Invoice. In these invoice format can show your logo and company details like address and GST and QR in top of Invoice. And also change Item listing in header colors and font.
This is best and good looking invoice format for both Normal & E-Invoice. With Tally Definition Language (TDL), users can further personalize their invoices to meet specific business needs
Customized Invoice Tally Prime TDL:
Normal invoices are the standard format used for billing purposes. This Invoice TDL allows users to customize these invoices extensively. With this Normal & E-Invoice Format TDL, businesses can:
Adding Company Logo and Details:
Incorporate your company logo, address, GST details, and other pertinent information at the top of the invoice for a personalized touch.
QR Code Integration:
In normal invoices adding QR code of Bank Payment detail and and in E- Invoice, E- Invoice QR code along with Bank Payment QR code.
Invoice Details and Party Details in Horizontal form:
To save extra spaces of invoice changed invoice details like, Invoice number, Date, references etc. and Buyer and Consignee Details in Horizontal form in Invoice.
Changing Item Listing looks:
Modify the item listing section’s colors, fonts, and layout in the header to align with your brand aesthetics.
Customized E- Invoice and Normal Invoice TDL code:
Tally Prime’s flexibility combined with TDL empowers users to create tailored invoices that reflect their brand identity and meet regulatory requirements.
[#Part: EXPINV SaleTopLeft]
Height : If ($$InExportMode OR $$InMailAction OR $$InUploadAction) AND ($$IsSysNameEqual:Excel:##SVExportFormat OR $$IsSysNameEqual:HTML:##SVExportFormat) THEN +
(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) ELSE +
(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) % page
Delete: Parts: EXPINV Company
[#Form: Printed Invoice]
Add:Parts:LWCMPDetails,LWTaxTitle,LearnwellEQR
[Part:LWTaxTitle]
Add:Line:LwTTLine
Border:thin bottom
Space Top:.5
[Line:LwTTLine]
Add:Field:LWTTF
Border:Thin Top
[Field:LWTTF]
Set as:"Tax Invoice"
Full Width:Yes
Align:Centre
Style:Invstyle
[Style:Invstyle]
Use: Normal Bold
Height:15
[Part:LWCMPDetails]
Add:Parts:CMPLogo,CMPdtl,LWSCPay
Space Bottom:.5
Width:100% page
[Part:CMPLOGO]
Part :LearnWellLOGO
Vertical : Yes
[Part :LearnWellLOGO]
Horizontal Alignment :Left
Vertical : No
Lines :LWLG
Graph Type: ##SALogoPath
Height : 12% page
Width : 15% Page
[Line :LWLG]
Field :LWLGF
[Field :LWLGF]
Set As : ""
[Part:CMPdtl]
Lines:LWCMPName,LWCMPAdd
Repeat:LWCMPAdd:CompanyAddress
[Line:LWCMPName]
Field:LWCMPName
[Field:LWCMPName]
Use:name field
Set as:@@CMPMailNAme
Full Width:Yes
Align:Centre
Style:Cmpstyle
[Line:LWCMPAdd]
Field:LWCMPAdd
[Field:LWCMPAdd]
Set as:$address
Align:Center
Full Width:Yes
Style:ADDStyle
[Style:Cmpstyle]
Use: Normal Bold
Height:20
[Style:ADDStyle]
Height:10
Use:Normal
[#Part: EXPINV Signature]
Delete:Border
[#Part: EXPINV Column]
Border:Thick Box
Delete:Line:EXPINV Column2
Local : Field : Default : Style :Normal Bold
Local : Field : Default : Print FG :White
Print BG:Black
[#line : EXPINV invdetails]
option:bg print:@@oddline
[!line:bg print]
local : field : default : print bg :Light grey
[system:formulae]
OddLine : $$IsOdd:$$Line
;---------------------------------------------
[#Part: EXPINV OpPageBreak]
Delete: Parts:EXPINV Title
Delete:Parts:EXPINV Leading
Add:Parts:Before:EXPINV Column:LearnwellInvNo1,LearnwellInvNo
[#Part : Expinv Rightsign]
Delete : Bottom Parts
Add:Bottom Part:EXPINV Signature
[Part:LearnwellEQR]
Add:Part:LWEInv1,LWEInvQR,LearnwellBankQR
Border:Thin box
Invisible: NOT ##SAGSTWithQRInfo OR $$IsEmpty:@@eInvoiceQRCValue OR NOT @@IsVchGSTeInvAppl
[Part:LWEInv1]
Line: LWExpinv IRN, LWExpinv AckNo, LWExpinv AckDate
Local: Line : LWExpinv AckNo : Space top : 0.10
Local: Line : LWExpinv AckDate : Space top : 0.10
Space Top:.5
[Line: LWExpinv IRN]
Use : LWeInv IRN Details Template
Local: Field: Medium Prompt : Set as : $$LocaleString:"IRN"
Local: Field: Name Field : Set as : @@GSTeInvIRN
Local: Field: Name Field : Width : 30% Page
Local: Field: Name Field : Line : 03
[Line: LWExpinv AckNo]
Use : LWeInv IRN Details Template
Local: Field: Medium Prompt : Set as : $$LocaleString:"Ack No."
Local: Field: Name Field : Set as : If ##IseInvPSPrintAfterSave Then ##eInvPSAckNo Else $IRNAckNo
[Line: LWExpinv AckDate]
Use : LWeInv IRN Details Template
Space Bottom: 0.25
Local: Field: Medium Prompt : Set as : $$LocaleString:"Ack Date"
Local: Field: Name Field : Set as : If ##IseInvPSPrintAfterSave Then $$String:##eInvPSAckDate Else $$String:$IRNAckDate
[Line: LWeInv IRN Details Template]
Field: Medium Prompt, Name Field
Local: Field: Medium Prompt : Width : 4
Local: Field: Medium Prompt : Style : Small
Local: Field: Name Field : Style : Small Bold
[Part:LWEInvQR]
Part:LWeInvoice QRC Title2, LWeInvoice QRC Title
Vertical: Yes
[Part: LWeInvoice QRC Title]
Line: LWeInvoice QRC Title
[Line: LWeInvoice QRC Title]
Field: LWeInvoice QRC Title
Space Bottom: 0.5
[Part: LWeInvoice QRC Title2]
QRCode: @@eInvoiceQRCValue : Yes
Line: LWeInvoice QRC Title2
Width: 20% page
Height: 10% Page
[Line: LWeInvoice QRC Title2]
Field: Info Field
[Field: LWeInvoice QRC Title]
Use : Simple Field
Set as: $$LocaleString:"e-Invoice"
Style: Small Bold
Width: Normal
[Part :LearnWellBankQR]
Parts :EXPINV BankDetails,LearnWellQrP
Border:Thin box
Space Top:.5
[Part :LearnWellQrP]
Part :LearnWellQRCode
Vertical : Yes
[Part :LearnWellQRCode]
Horizontal Alignment : Right
Vertical : No
Lines :LWQrL
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No. "+$$String:$voucherNumber) : True
Height : 12% page
Width : 15% Page
[Line :LWQrL]
Field :LWQrF
[Field :LWQrF]
Set As : ""
[Part:LWSCPay]
Part :LearnWellQRIn,qrtxt
Vertical : Yes
Invisible:NOT $$IsEmpty:@@eInvoiceQRCValue
[Part :LearnWellQRIn]
Lines :LWQrLn
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No."+$$String:$voucherNumber) : True
Height : 8% page
Width : 12% Page
[Line :LWQrLn]
Field :LWQrFn
[Field :LWQrFn]
Set As : ""
[Part:qrtxt]
Line:as
[Line:as]
Field:as
[Field:as]
Use:name field
Set as:"Scan to Pay"
[Part:LearnwellInvNo]
Parts:EXPINV Consignee, EXPINV ConsigneeContact, EXPINV Buyer, EXPINV Contact
Bottom Parts: EXPINV Country
Vertical : No
Border:Thin box
[Part:LearnwellInvNo1]
Parts:LWBSLeft,LWBSMiddle,LWBSRight
Vertical:Yes
Border:thin box
[Part:LWBSLeft]
Parts : EXPINV Number,EXPINV Date,EXPINV SupplierRef,EXPINV DelNote,EXPINV ShipDate
Vertical : No
[Part:LWBSRight]
Parts : EXPINV DueDate, EXPINV OtherRef, +
JWInOutInv MotorVehicleNo, +
EXPINV PlaceOfRcpt, EXPINV PortDischarge, JMInOutInv ProcessingDuration
Vertical : No
[Part:LWBSMiddle]
Parts: EXPINV OrderNumber, EXPINV OrderDate, EXPINV ShipDoc,EXPINV Destination,JWMTIn ChallanNo,EXPINV PreCarr, EXPINV Vessel, EXPINV PortLoading, JMInOutInv EmptyPart
Border:thin box
Copy or Download above TDL code and create a text file.
Save text file and load in Tally
Goto print and sales invoice, and enable bank details etc. (watch the below video for more details).
You can see changed invoice format.
This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.
Customized Invoice Tally Prime TDL Video:
See the below video to learn how to use Custom Invoice TDL in Tally Prime:
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 file for Tally Prime is ready to use.
By leveraging Tally Prime’s TDL capabilities, you can craft professional and personalized invoices for both Normal and E-Invoice formats. Incorporating your company logo, details, QR codes, and adjusting the visual aspects of the item listing allows you to present a consistent brand image while meeting the necessary invoicing standards. This level of customization not only enhances the professionalism of your invoices but also helps strengthen your brand identity with every interaction.
