In this blogpost we will add Bank Details with QR Code in Invoice. We always follow best techniques to do our work smartly and finish on time. In this QR images play important roles in our daily life work. If we want to pay instantly and without any error, we use QR code because QR payment methods are easily available and can do transactions with any UPI payment apps. And same if we use Tally to generate invoices, there are bank details option in Invoice printing. With this bank details our customers can pay by adding our account details on there books/Bank. But this is lengthy process on today’s era. But if you want to collect payments instantly then can use QR images in Invoice. So today I will provide a best TDL code to add Bank details with QR Code in our Tally invoices. We can add QR image along with Bank Details. With this anyone can pay our bills by scanning of QR images. In this TDL code we use Tally Prime QR code facility.
Bank Details with QR Code in Invoice:
In this Tally Prime 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 add QR code in Invoices.
Also checkout Additional fields in Stock Summary and Vouchers
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 for invoicing and enable bank details for invoice.
4. Now we can see Bank details with QR Code Image in our Invoice 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.
Watch above video to learn :
1. How to add extra fields in Invoice Print.
2. How to add Use Tally QR code facility.
3. And Many More…….
TDL Code :
[*Part : EXPINV BankInfo]
Add : Bottom Parts : After : EXPINV DateTime :LearnWellBankQR
[Part :LearnWellBankQR]
Parts :LearnWellQrP, EXPINV BankDetails
[Part :LearnWellQrP]
Part :LearnWellQRCode
Vertical : Yes
[Part :LearnWellQRCode]
Horizontal Alignment : Left
Vertical : No
Lines :LWQrL
QR code: (“upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No. “+$$String:$voucherNumber) : True
Height : 10% page
Width : 12% Page
[Line :LWQrL]
Field :LWQrF
[Field :LWQrF]
Set As : “”
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)
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
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 other website Engage to Tech
sir im using tally erp9 after loading tdl qr code is not showing
please help
something went wrong says qrcode
THIS CODE NOT PRINTING DROPDOWN NAME IN INVOICE PRINT
PLEASE HELP
[System: UDF]
MyDBShipDocument: Aggregate: 2
ShipDocumentName: String: 1113
[#Part: CMP AccFeat Left]
Add: Line: CMP EnableShipDocument
[Line: CMP EnableShipDocument]
Field: Medium Prompt, CMP EnableShipDocument
Local: Field: Medium Prompt: Info: “Enable Name of Territory Executive ? ”
Space Top: 1
[Field: CMP EnableShipDocument]
Use: Logical Field
Storage: EnableShipDocument
Set as: If $$IsEmpty:$$Value then “No” else $$Value
Sub Form: CMP ShipDocumentReport: $$Value = “Yes”
[System: UDF]
EnableShipDocument: Logical: 1117
[Report: CMP ShipDocumentReport]
Form: CMP ShipDocumentForm
[Form: CMP ShipDocumentForm]
Part: CMP ShipDocumentPartTitle, CMP ShipDocumentPartDetails
Background: White, Petal Pink
[Part: CMP ShipDocumentPartTitle]
Line: CMP ShipDocumentLineTitle
[Line: CMP ShipDocumentLineTitle]
Field: Long Prompt
Local: Field: Long Prompt: Style: Small Bold
Local: Field: Long Prompt: Info: “Territory Executive ”
[Part: CMP ShipDocumentPartDetails]
Line: CMP ShipDocumentLineDetails
Repeat: CMP ShipDocumentLineDetails: MyDBShipDocument
BreakOn: $$IsEmpty:$despatchthroughName
Height: 6
Scroll: Vertical
CommonBorder: Yes
[Line: CMP ShipDocumentLineDetails]
Field: CMP ShipDocumentNameField
[Field: CMP ShipDocumentNameField]
Use: Short Name Field
Storage: ShipDocumentName
Border: Thin Left
[Collection: MyShipDocumentCollection]
Type: MyDBShipDocument: Company
Childof: ##SVCurrentCompany
Format: $ShipDocumentName,30
Title: Territory Executive
[#Field: EI ShipDocument]
Use : Short Name Field
Storage : BasicShipDocumentBy
Set as : if NOT $$IsEmpty:@@EIBasicShipDocument then @@EIBasicShipDocument Else $$Value
Set always : Yes
Skip On : NOT @@DoEditAll AND NOT $$IsEmpty:@@EIBasicShipDocument AND @@IsObjOfTypeTrackOrOrder
Width: 30
Table: MyShipDocumentCollection,By Hand,By Courier,EndofList
ShowTable: Always
Key: Create MyShipDocumentCollection
Sir help me this tdl code is loaded done but not generated Qr Code
[#Part : CMP TallyShopFeatures Left]
Add : Line : At End : RJACTIVATEMODULE
[Line:RJACTIVATEMODULE]
Fields : Long Prompt,RJACTIVATEMODULE
Local : Field : Long Prompt : Set as : “Configure Qr Code for Invoices?”
Local : Field : Long Prompt : Style : RJSTYLE
Local : Field : Long Prompt : Background : Yellow
Local : Field : Long Prompt : Color : Blue
Local : Field : Long Prompt : Width : 40
[Field:RJACTIVATEMODULE]
Use : Logical Field
Table : YesNoTable
Set Always : Yes
Show Table : Always
Storage : RJACTIVATEMODULE
Sub Form : QrConfig:$$Value
Style : RJSTYLE
Background : Blue
Color : Yellow
Width : 10
[Style:RJSTYLE]
Font : if $$SysInfo:IsWindows then “Arial” else “Helvetica”
Height : @@RJSize
[System: Formula]
RJSize : 10
IsCustomizationEnabled : $RJACTIVATEMODULE:Company:##SVCurrentCompany
[System:UDF]
RJACTIVATEMODULE : Logical : 1011
VTYPRJACTIVATEMODULE: Logical : 1012
[System:UDF]
QrIncludeAmount:Logical:7927
QrPaymentMode:String:7234
QrUpiId:String:7235
;QrBankIfsc:String:7236
;QrBankAccount:String:7437
;QrMobileNo:String:7438
QrMmid:String:7439
;Report for Qr Configuration
[Report:QrConfig]
Title:”QrCode Configuration”
Form:QrConfig
[Form:QrConfig]
Width:50% page
Part:QrConfig
[Part:QrConfig]
Lines:QrConfigTitle,QrPaymentMode,QrIncludeAmount,QrUpiId;,QrBankAccount,QrBankIfsc,QrMobileNo,QrMmid
Space Bottom:2
Space Left:2
Space Right:2
Space Top:2
Line:QrHelpLine
[Line:QrConfigTitle]
Field:Name Field
Local:Field:Name Field:Info:”Configure Qr Code Settings”
Local:Field:Name Field:Full Width:Yes
Local:Field:Name Field:Align:Center
Local:Field:Name Field:Border:thinbottom
[Line:QrPaymentMode]
Space Top:0.5
Fields:LongPrompt,QrPaymentMode
Local:Field:LongPrompt:Info:”Payment Mode”
[Field:QrPaymentMode]
Use:Name Field
;Table:QrPaymentModes
Set as : “UPI ID”
Set Always:Yes
Show Table:Always
Storage:QrPaymentMode
Width:50
Dynamic : “”
Read Only:Yes
[Collection:QrPaymentModes]
Title:”Payment Modes”
List Name:”UPI ID”,”Bank Account & IFSC”,”Mobile Number & MMID”
[Line:QrIncludeAmount]
Field:Long Prompt,QrIncludeAmount
Local:Field:LongPrompt:Info:”Include Amount?”
Space Top:0.5
[Field:QrIncludeAmount]
Use:Logical Field
Show Table:Always
Set as:No
Storage:QrIncludeAmount
[Line:QrUpiId]
Field:Long Prompt,QrUpiId
Local:Field:LongPrompt:Info:”Enter UPI Id”
Space Top:0.5
Local : Field : Long Prompt : Inactive: @@NOUPID
Invisible : @@NOUPID
[Field:QrUpiId]
Storage:QrUpiId
Use:Name Field
Width:50
Case : Lower Case
Inactive: @@NOUPID
Control:QrInvalidMsg:$$IsEmpty:$$Value
[System : Formula]
QrPaymentMode:$QrPaymentMode:Company:##SvCurrentCompany
NoUPID : $QrPaymentMode!=”UPI ID”
NoBank : $QrPaymentMode!=”Bank Account & IFSC”
NoMMID : $QrPaymentMode!=”Mobile Number & MMID”
QrUPId :$QrUpiId:Company:##SvCurrentCompany
QrBankAccount :$$LocaleString:($QrBankAccount:Company:##SvCurrentCompany)
QrIFSCode :$QrBankIfsc:Company:##SvCurrentCompany
QrMobileNo :$$LocaleString:($QrMobileNo:Company:##SvCurrentCompany)
QrMMID : $$LocaleString:($QrMmid:Company:##SvCurrentCompany)
IsQrAmountInclude:$QrIncludeAmount:Company:##SvCurrentCompany
QrInvalidMsg:”Invalid Input!”
[Line:QrBankAccount]
Field:Long Prompt,QrBankAccount
Local:Field:LongPrompt:Info:”Enter Bank Account Number”
Space Top:0.5
Local : Field : Long Prompt : Inactive: @@NoBank
Invisible : @@NOBank
[Field:QrBankAccount]
Storage:QrBankAccount
Use:Name Field
Width:50
Format:NoComma,NoZero
Inactive: @@NoBank
Control:QrInvalidMsg:$$IsEmpty:$$Value
[Line:QrBankIfsc]
Field:Long Prompt,QrBankIfsc
Local:Field:LongPrompt:Info:”Enter IFSC Code”
Space Top:0.5
Local : Field : Long Prompt : Inactive: @@NoBank
Invisible : @@NOBank
[Field:QrBankIfsc]
Storage:QrBankIfsc
Use:Name Field
Width:50
Inactive: @@NoBank
Control:QrInvalidMsg:$$IsEmpty:$$Value
[Line:QrMobileNo]
Field:Long Prompt,QrMobileNo
Local:Field:LongPrompt:Info:”Enter Mobile Number”
Space Top:0.5
Local : Field : Long Prompt : Inactive: @@NoMMID
Invisible : @@NOMMID
[Field:QrMobileNo]
Storage:QrMobileNo
Use:Name Field
Width:50
Format:NoComma,NoZero
Inactive: @@NOMMID
Control:QrInvalidMsg:$$IsEmpty:$$Value
[Line:QrMmid]
Field:Long Prompt,QrMmid
Local:Field:LongPrompt:Info:”Enter MMID”
Space Top:0.5
Local : Field : Long Prompt : Inactive: @@NoMMID
Invisible : @@NOMMID
[Field:QrMmid]
Storage:QrMmid
Use:Name Field
Width:50
Format:NoComma,NoZero
Inactive: @@NoMMID
Control:QrInvalidMsg:$$IsEmpty:$$Value
[Line:QrHelpLine]
Space Top:2
Field:SimpleField
Local:Field:Simple Field:Info:”**Make Sure Above Entered Information is Valid and Working”
Local:Field:Simple Field:Align:Center
Local:Field:Simple Field:Full Width:Yes
Local:Field:Simple Field:Color:Red
[Function:InitQrCodeGeneration]
Variable:QString: String:”upi://pay?”
Variable:QinvNumber:String:$$StringFindAndReplace:($$String:$VoucherNumber):”_”:”-”
Variable:QPartyName:String:$$TrimRefId:($$StringFindAndReplace:$PartyLedgerName:”_”:”-“)
Variable:QCompany:String:$$TrimRefId:($$StringFindAndReplace:##SvCurrentCompany:”_”:”-“)
Variable:QAmount:String:($$LocaleString:($$Number:$Amount))
10:If:@@QrPaymentMode contains “UPI ID”
11:Set:QString:##QString+”pa=”+@@QrUPId+”&”
12:Set:QString:##QString+”pn=”+##QCompany+”&”
13:Set:QString:##QString+”mc=0000&”
14:Set:QString:##QString+”tr=”+##QinvNumber+”_”+##QPartyName+”_Pay%20to%20″+##QCompany+”&”
amt1:If:@@IsQrAmountInclude
15:Set:QString:##QString+”am=”+##QAmount+”&”
amt2:End If
16:Set:QString:##QString+”mam=0&cu=INR”
17:Return:##QString
18:End If
[Function:TrimRefId]
Parameter:v1:String
01:If:$$StringLength:##v1 > 4
02:Return:$$StringPart:##v1:0:4
03:Else
04:Return:##v1
05:End If
QR Tdl shows Error: INTENT_NOT_SUPPORTED…
Please help