Cheque Details print in Voucher

Dear Experts .............
How to print cheque details in default voucher format................ please help me

 

Witch Voucher and where you want to print Cheque Detail.... explain in detail i try to solve it

 

Khan jee,
i want to print cheque detail in payment & receipt voucher in tally.erp9 release 1.1

 

@ vumika poudel please use correct forum for your request.

 

I mean i need TDL code to print cheque detail like 'cheque no', 'cheque date' in payment & receipt voucher, because tally erp 1.1 not support this features by default.

 

Hi,
for Tally.ERP 9 Rel 1.1, you have to add two new udf for Cheque No. & Cheque Date in the Payment & Receipt Voucher Form. And the same can be used for Printing also.

--------------

[#Part: VCH Narration]
Add : Option : BankDet Pay Narration : $$IsPayment:##SVVoucherType or $$IsRecipt:##SVVoucherType

[!Part: BankDet Pay Narration]
Add : Line : At Beginning : BankDet VCH Cheque Number, BankDet VCH ChqDate

[Line: BankDet VCH Cheque Number]
Fields : Short Prompt, BankDet VCH Cheque Number
Local : Field : Short Prompt : Info : "Cheque No. :"
Local : Field : Short Prompt : Set Always : Yes
Local : Field : Short Prompt : Style : Normal Bold
Local: Field : Default : Inactive : @@BankDetBanks

[Field: BankDet VCH Cheque Number]
Use: Name Field
Storage : MyChequeNumber
Style: Normal
Set Always : Yes

[Line: BankDet VCH ChqDate]
Fields: Short Prompt, BankDet VCH ChqDate
Local: Field : Short Prompt : Set as : "Date :"
Local: Field : Short Prompt : Set always : Yes
Local: Field : Short Prompt : Style : Normal Bold
Local: Field : Default : Inactive : @@BankDetBanks

[Field : BankDet VCH ChqDate]
Use : Short Date Field
Storage : MyChequeDate
Set as : If $$IsEmpty:$$Value then $Date else $$Value
Set Always : Yes
Style : Normal
Align : Left
[System: Formula]
BankDetBanks: $$FilterCount:AllLedgerEntries:HasBankEntry = 0
[System: UDF]
MyChequeNumber : String : 360
MyChequeDate : Date : 360
--------------
The above code will add the udf in the Screen. Pl. try to extend the code for Printing. Best Wishes.

 

Pritam Krishna Jee Thank You Very Much, but pritam jee i'am unable to print cheque detail on voucher because im new in tdl & i don't know how to extend other code for print, please help me, you fulfill my 99% of my requirement

 

Vumika Ji
use following code and print Receipt as Formal Receipt you can get your solution
Receipt Voucher Alteration ---> Set yes Print Formal Receipt After Saving

if you get any other clarification reply

=================================================
[#Part: VCH Narration]
Add : Switch : BankDetRcpt : Bank VCH Narration : @@IsPayment OR @@IsReceipt

[!Part: Bank VCH Narration]
Add : Line : At Beginning : Bank Cheque Number, BankName

[Line: Bank Cheque Number]
Fields : Medium Prompt, BankCheque Number, Short Prompt, BankChqDate
Local : Field : Default : Inactive : @@BankDetBank
Local : Field : Medium Prompt : Info : $$LocaleString:"Cheque Number:"
Local : Field : Short Prompt : Set as : $$LocaleString:"Dated:"

[Field: BankCheque Number]
Use : Number Field
Storage : BankChequeNumber
Format : "NoZero, NoComma"
Max : 7
Width : 7

[Field: BankChqDate]
Use : Uni Date Field
Storage : BankChqDate
Set as : If $$IsEmpty:$$Value then $Date else $$Value
Set Always : Yes
Align : Left

[Line: BankName]
Fields : Medium Prompt, BankName
Local : Field : Default : Inactive : @@BankDetBank
Local : Field : Medium Prompt : Info : $$LocaleString:"Bank Name:"
Invisible : NOT @@IsReceipt

[Field: BankName]
Use : Name Field
Storage : BankNames

[System: UDF]
BankNames : String : 1000
BankChequeNumber: Number : 1001
BankChqDate : Date : 1002

[#Form: Printed Receipt]
Add: Part:After: PRCT Body : BankPart

[Part: BankPart]
Lines : PRCT BankName, PRCT ChequeNo, PRCT ChqDate
Local : Field : Short Prompt : Style : Normal Italic
Local : Field : Short Prompt : Width : 17

[Line: PRCT BankName]
Fields : Short Prompt, PRCT BankName
Local : Field : Short Prompt : Info : $$LocaleString:"Bank Name" + ":"
Local : Field : Short Prompt : PrePrinted : Yes
SpaceBottom : 1

[Field: PRCT BankName]
Set as : $BankNames
Style : Normal Bold
FullWidth : Yes

[Line: PRCT ChequeNo]
Fields : Short Prompt, PRCT ChequeNo
Local : Field : Short Prompt : Info : $$LocaleString:"Cheque No." + ":"
Local : Field : Short Prompt : PrePrinted : Yes
SpaceBottom : 1

[Field: PRCT ChequeNo]
Set as : $BankChequeNumber
Style : Normal Bold
FullWidth : Yes

[Line: PRCT ChqDate]
Fields : Short Prompt, PRCT ChqDate
Local : Field : Short Prompt : Info : $$LocaleString:"Cheque Date" + ":"
Local : Field : Short Prompt : PrePrinted : Yes
SpaceBottom : 1

[Field: PRCT ChqDate]
Set as : $BankChqDate
Style : Normal Bold
FullWidth : Yes

 

Khan Jee,
Thank you very much its working but it is just activated in receipt only. & no cheque details are shown such as cheque no. cheque date

 

What exactly you want, please send a screenshot or design it in excel so that we can help you.

 

Hi

The Balance Code:

[#Part: PPRBottomDetails]

Option: PPRBottomDetails Rct Pymt: (@@IsPayment OR @@IsReceipt)

[!Part: PPRBottomDetails Rct Pymt]

Add: Parts: At Beginning: BankDet VCH CheqDet

[Part: BankDet VCH CheqDet]

Lines : BankDet VCH PCheque No Title, BankDet VCH PCheque No, +
BankDet VCH PBank Title, BankDet VCH PBank

[Line: BankDet VCH PCheque No Title]

Use : PPR SubTitles
Local : Field : Name Title Field : Info : $$LocaleString:"Cheque Number and Date :"

[Line: BankDet VCH PCheque No]

Left Fields : BankDet VCH Cheque Number
RightFields : Amount Title Field
Indent : 4
Local : Field : AmountTitleField : Border: Thin Left
Local: Field: Default: Style: Normal
Local: Field: BankDet VCH Cheque Number: Type: String
Local: Field: BankDet VCH Cheque Number: Width: 0
Local: Field: BankDet VCH Cheque Number: FullWidth: Yes
Local: Field: BankDet VCH Cheque Number: Delete: Storage
Local: Field: BankDet VCH Cheque Number: Set As: $$String:$MyChequeNumber + " dt " + $$String:$MyChequeNumber

 

Vumika ji
pls send a sample what actually you want then I can help you
any screenshot or sample
if you get any trouble in receipt pls connect with Team-viewer so i give you solution

 

Dear Experts please find attached file herewith the sample default voucher in need highlighted details on default payment voucher & receipt voucher

 

Dear Experts please find attached file herewith the sample default voucher in need highlighted details on default payment voucher & receipt voucher
View attachment 575 View attachment 576

 

Pritam jee Error occured
Pritam jee Error occured

 

Hi, Attach the full code file. Presently I dont have 1.1 Release. Will check. Meantime other members can help.

 

Pritam Sir
Please Find Attached text file with full code.............................

 

Dear Vumika Ji
pls go with Attachment its complete code with print report
if you get any difficulty keep in touch

 

Yes Khan Jee
what a magic ........................ thank you very very very much

 

Welcome Vumika Ji

 

Khan Jee
is it possible in tally 9 2.14

 

Vumika ji
I am not try you can try to run in Tally 9 2.14 i have no this release
if you get any problem contact me

 

Khan Jee
It is not printed from multiple account printing,,,,,,,,, is it possible to print cheque details in voucher when printing from multiple account printing ??????

 

Vyumika ji
how to print multi account printing.....explain me process from witch menu you have to print

 

Khan please view this picture