Bank Detail in Invoice Customise

I create tdl code for my invoice.

but I want to add bank detail in my invoice.

How to do guide me.

I attach herewith my code.

 

Dear Hemant,

Please refer the default tdl in Tally developer 9, (ie., invoice.500) there you can get the details related to your query. Entire code is given to capture companies banking details to be printed in invoice.

 

[#Part: EI DelNoteInfo]

Add : Lines : After : EI PortDestination: EI Bankdetail
;Invisible : NOT @@DespatchDet OR @@IsDebitNote OR @@IsCreditNote
Height : 10

[Line: EI Bankdetail]

Field : Medium Prompt, EI Bankdetail
Local : Field : Medium Prompt : Info : $$LocaleString:"Bank Details. :"
Invisible : @@IsOrderVch

[Field: EI Bankdetail]

Use : Short Name Field
Storage : BasicBankdetail
Case : Normal
Table : BankLedgerColl
ShowTable : Always

[Collection : BankLedgerColl]
Type : Ledger
Filter : BankFilter
Title : "Bank Details"
[System :Formula]
BankFilter:$parent Contains "Bank Account"


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Part : compass CustomerDetailsRightBottom]
Line : compass BankDetailsDet
width: 180 mms

space top: 17 mms

[Line : compass BankDetailsDet]
right Field : compass BankDetailsDet,;compass BankDetailsAc,;;compass BankDetailsbranch

[Field : compass BankDetailsDet]
Use : Name Field
Set as :"Bank Details:"+$name:ledger:$basicbankdetail

width:115 mms


[Field : compass BankDetailsAc]

Use : Name Field
Set as :"A/C No : "+$BankDetails:Ledger:$BasicBankdetail

[Field : compass BankDetailsbranch]
Use : Name Field
Set as :"Branch Name : "+$BranchName:Ledger:$BasicBankdetail


;;;;;;;;;;;Try this .

 

pl expain with tally screen short.......
because i will not display the result

 

Not getting the result.

 

you have to select the bank from supplementary details

 

Hi if u have the Rel. 4.5 it has the facility to print bank details in Inovice no need of customization

 

what is above code for Tally Erp 9 rel 3.6 version

 

Hi Giving you one of my sample code designed to add Bank Detaila and print the same in Invoice
;;; Please try to understand the code and do not just copy and paste, then it will help you more

;; --------------------- Bank Details Entry Screen
[#Menu : Display Menu]
Add : Item : At End : Bank Details : Execute : Bank Details

[Report : Bank Details]
Auto : Yes

[Form : Bank Details]
Part : AgencyBank Details
FullHeight : NO
Height : 80% page
width : 75% Page
Space Top : 2
Space Bottom : 2

[Part : AgencyBank Details]
Line : accName, BkName, BkAcno, BkBrCode, BKifscCode,BkSwiftCode
Width : 60% Page

[Line : AccName]
Field : Medium Prompt, Short Name Field
Local : Field : Medium Prompt : Setas : "A/c Name :"
Local : Field : Medium Prompt : Style : Normal BOld
Local : Field : Short Name Field : Modifies : Acname
Local : Field : Short name Field : Style : Small
Local : Field : Short name Field : width : 40% Page
space Top : .5
Space Bottom : .5

[Line : BkName]
Use : AccName
Local : Field : Medium Prompt : Set as : "Name Of Bank :"
Local : Field : Short Name Field : Modifies : BKName

[Line : BkAcno]
Use : AccName
Local : Field : Medium Prompt : Set as : "A/c No :"
Local : Field : Short Name Field : Modifies : BKacc
[Line : BkBrCode]
Use : AccName
Local : Field : Medium Prompt : Set as : "Branch Code :"
Local : Field : Short Name Field : Modifies : BKbranch

[Line : BKifscCode]
Use : AccName
Local : Field : Medium Prompt : Set as : "I.F.S.C Code :"
Local : Field : Short Name Field : Modifies : BKIFSCNO

[Line : BkSwiftCode]
Use : AccName
Local : Field : Medium Prompt : Set as : "Swift Code :"
Local : Field : Short Name Field : Modifies : BKSwiftNo


[System : Variable]
Acname : " "
BKName : " "
BkAcc : " "
Bk Branch : ""
BkIFSCNo : " "
BKSwiftNo : " "

[Variable : AcName]
Type : String
Persistent : yes

[Variable : BKName]
Type : String
Persistent : yes

[Variable : BKAcc]
Type : String
Persistent : yes

[Variable : Bkbranch]
Type : String
Persistent : yes


[Variable : BKIFSCNo]
Type : String
Persistent : yes

[Variable : BKswiftNo]
Type : String
Persistent : yes


;; For printing
[#Part: EXPINV SignOff]
Option : Agency Signoff : @@Issalesorder or @@ispurcorder or @@issales

[!Part : Agency SignOff]
Delete : Parts
Add : part : Expinv Words, CoStNumber
add : Parts : AgencyDigiBank Details, AgencyEstimate
vertical : yes

[Part : CoStNumber]
Line : CoStNumber

[Line : CostNumber]
Field : Medium Prompt, Short Name Field,Simple Prompt, Name Field
;;Right Field : Simple Prompt, Name Field
Local : Field : Medium Prompt : Set as : "S.T. Number :"
Local : Field : Medium Prompt : Style : Small Bold
Local : Field : Short name Field : Style : Small
Local : Field : Short Name Field : setas : $STRegNumber:Company:##SVCurrentCompany
Local : Field : Simple Prompt : Set as : "Company PAN NO :"
Local : Field : Simple Prompt : Style : Small Bold
Local : Field : Name Field : Set as : $IncomeTaxNumber:Company:##SVCurrentCompany
Local : Field : Name Field : Style : Small
[#Part : Expinv Rightsign]
Delete : Bottom Parts

[Part : AgencyEstimate]
Option : Agency sign1 : @@issalesorder or @@ispurcorder
Option : Agency Sign2 : @@issales

[!Part : Agency Sign2]
Add : Bottom Part : AgencySign3

[Part : Agency Sign3]
Line : EXPSMP Signature
Bottom Lines: EXPSMP Authourity
Height : 15 mms
;;PrePrinted : Yes


[!Part : AgencySign1]
;;Delete : Part : EXPINV Declaration
Add : Bottom Part : Agency Sign

[Part : Agency Sign]
Part : SignLeft Part
Right Part : SignRight Part
[Part : SignLeft Part]
Line : AgencyCoName, Agencyline2, Agencyline3
Bottom Line : Agency signatory

[Part : SignRight Part]
Line :AcceptLine, CustomerNameLine, CustNm2, Custnm3, Custsign,Date Line

[Line : AcceptLine]
Field : Short name Field
Local : Field : Short Name Field : Set as : "We Accept,"
Local : Field : Short Name Field : Style : Small

[Line : CustomerName Line]
Field : name Field
Local : Field : Name Field : Set as : $PartyledgerName
Local : Field : Name Field : Style : Large
Local: Field : Name field :Full width : Yes

[Line : CustNm2]
Field : Short Name Field
Local : Field : Short name Field : Set as : " "

[Line : Custnm3]
Use : Custnm2

[Line : Custsign]
Field : Short Name Field
Local : Field : Short name Field : Set as : "Authorised Signatory"
Local : Field : Short Name Field : Style :Small

[Line : DateLine]
Field : Short name Field
Local : Field : Short Name Field : set as : "Date :"

[Line : AgencyCoName]
Field : Name Field
Local : Field : Name Field : Set as : @@InvoiceCmpName
Local : Field : Name Field : Style : Large Bold
Local : Field : Name Field : Full width : Yes

[Line : AgencyLine2]
Use : Agencyconame
Local : Field : Name Field : Set as : " "

[Line : AgencyLine3]
Use : Agencyline2


[Line : Agency Signatory]
Field : Name Field,Short Name Field
Local : Field : Name Field : Set as : If @@issalesorder then "Business Lead" else "Authorised Signatory"
Local : Field : Default :Style : "Small"
Local : Field : Name Field : Width : 30
Local : Field : Short Name Field : set as : "Commercial"
Local : Field : Short Name Field : Invisible : @@ispurcorder



[#Field: EXPINV EOE]
Info : $$LocaleString:"E. & O.E"
Invisible : Yes

[Part : AgencyDigiBank Details]
Lines : Bank Title Line,Bank Line1, Bank Line2, Bank Line3
Invisible : Not (@@issalesorder or @@issales)

[Line : Bank Title Line]
Field : Name Field
Local :Field : Name Field : Set as : "Our Bank Details for Transferring Payment Through TT:"
Local : Field : Name Field : Full width : Yes
Local : Field : Name Field : Style : Small BOld
Local : Field : Name Field : Border : Thin Bottom

[Line : Bank Line1]
Field : Name Field, Short Name Field
Local : Field : Default : Style : Small
Local : Field : Name Field : Set as : "Account Name : " + ##Acname;; Agencydigi Communications Pvt. Ltd."
Local : Field : Short Name Field : Set as : "Branch Code : " + ##BkBranch ;; 0669"
Local : Field : Default: Full width : Yes


[Line : Bank Line2]
Use : Bank Line1
Local : Field : Name Field : set as : "Name of Bank : " + ##BKName ;;
Local : Field : Short Name Field : set as : "IFSC Code : " + ##BKIFSCNo ;;

[Line : Bank Line3]
Use : Bank Line1
Local : Field : Name Field : Set as : "Account No. : " + ##BkAcc ;;
Local : Field : Short Name Field : Set as : "Swift Code : " + ##BkSwiftNo ;
Border : Thin Bottom

;;;Also giving you the screen shot of the same in

 

Thanks for replay.

 

thanx for this code. but i am using this i can't print buyer'r tin no. and company tin no in sales invoice. please help me

 

Not working Plz? post full tdl file

 

Gayatri ji,

I think, you have to compile above 2 codes as per your needs, (with necessary changes, ) then check. after making changes, if you not succeed, then I will help you.
Thanks & warm regards

 

Ok thanks i will try again

 

This code is working but every time we have to fill detail in Bank detail before taking print. once we exit from tally all the information lost form the bank detail field

 

above tdl is working like f-12 features . all the company in tally same bank detail

 

not working. i ma using release 4.7 and i have customized invoice according to requirement but i could not print bank detail.

I have taken f12 at the time or printing and select bank but in printing it is not comming. pls help....................

 

how to get bank details in bank ledger for printing in invoice?

 

how to get bank details from bank ledger for printing invoice