Tuesday, May 27, 2008

TDL Lesson 9 : Cheque No Field in Voucher Entry Screen

[#Part : VCH Narration]
Add : Option : BankDet VCH Narration : @@ISPayment OR @@IsPayment

[System : Formula]
IsReceipt : $$IsReceipt:##SVVoucherType
IsPayment : $$IsPayment:##SVVoucherType

[System : Formula]
HasMyBankEntry : $$FilterCount:AllLedgerEntries:HasBankEntry = 0

[!Part : BankDet VCH Narration]
Add : Lines : AT Beginning : TMVCH ChqNo

[Line : TMVCH ChqNo]
Field : Long Prompt, TMChqNo ;
Local : Field : Long Prompt : Info : "Cheque No(s) :"
Local : Field : Long Prompt : Inactive : @@HasMyBankEntry
Local : Field : Long Prompt : Fixed : Yes
Local : Field : Long Prompt : Width : 18
Local : Field : Long Prompt : Style : Normal Bold


[Field : TMChqNo]
Use : Number Field
Storage : TMChqNo
Format : "NoZero,NoComma"
Inactive : @@HasMyBankEntry
Width : 10

[SYSTEM : UDF]
TMChqNo : NUMBER : 202

16 comments:

Unknown said...

While uploading the same there wass an error saying Field: TMchqno.
Cannot find description

Please let us know the Solution

Mani said...

HI Senthi,

in the above code there are three TMChqNo is mentioned.

check the spelling u might be mis-spelt

Unknown said...

after adding UDF in voucher, how to print this additional details in voucher.

Mani said...

[#Line: DSP VchAccDetail]
Add:Right Fields :Before :DSP VchType:TMLedChqNo

[Field: TMLedChqNo]
Use : Number Field
Set as : $TMChqNo
Style : Small Italic
Width : 7
Align : Right
Format : "NoZero,NoComma"

RAMDAS said...

Dear sir,

how can i display running balances (ie. difference between debit side and credit side) in day book. hope an early reply from you.

thanking you

ramdas

Mani said...

The Running balance is Available in Tally Default Features (Tally.ERP9).

Press F12 to Activate the Same in Ledger Summry

Anonymous said...

Dear Mani, how can we add a new field in voucher title fields like in between the description nd rate field as i want GST Field to be there. i need ur help.

Unknown said...

Using this cheque no. field in voucher entry screen,
and how to filter at Day Book or other Bank/Ledger Report, using Alt+F12 (Range) Key.
In Form - "Range of Information in Report"
Voucher having Cheque No(Particulars) Containing(Range of Info.) 123456
I think possibility with [#Field: IFLT Method]
please guid in details.
THANKS
-H.Patel

Unknown said...

How to Filter a cheque number entered in Voucher's UDF Field.

Rajan Ghanshyam said...

I want to expand full width declaration on the invoice,

Pls, any one help me to do the same

Unknown said...

Can I add a field in stock journal Entry after or before Qty column.

Bhumika Poudel said...

how to print this additional Cheque no details in voucher

this formula doesn't work
[#Line: DSP VchAccDetail]
Add:Right Fields :Before :DSP VchType:TMLedChqNo

[Field: TMLedChqNo]
Use : Number Field
Set as : $TMChqNo
Style : Small Italic
Width : 7
Align : Right
Format : "NoZero,NoComma"

Mani said...

Pls let me know in which reports u r trying to add the chq no. based on the reports i can guide

Tally.ERP9 Customization said...

Dear Sir
Can we print A/C Payee comments as 45 degree angle on cheque??? something like below image.
Thank You

Mani said...

TEXT can not be printed in 45 Degree, instead create a BMP/JPG and try image printing

bk said...

dear sir
invoice heading bg change code please, slno,descriprtion of goods,hsn/sac,gst rate,qty,Net rate,disc,rate,per,disc.%,amount,
and bottom column total amount