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

Lesson 8 : Address Book From Tally

;; How to Create Address Book in Tally

[#Menu: Gateway Of Tally]
Add : Item : After : ~Balance Sheet : Address Book : Menu : AddressBookMenu

[Menu: AddressBookMenu]
Add : Item : Sundry Debtors Details : Display : TMSD Address Book
Add : Item : Sundry Creditors Details : Display : TMSC Address Book

[Report: TMSD Address Book]
Use : DSP Template
Form : TMSD Address Book

[Form: TMSD Address Book]
Use : DSP Template
Part : TMSD Address Book Title, TMSD Address Book


[Part : TMSD Address Book Title]
Line : TMSD Address Book Title

[Line : TMSD Address Book Title]
Use : TMSD Address Book
Local : Field : SD Sr No : Set as : "SNo"
Local : Field : SD Name : Set as : "Name"
Local : Field : SD Contact No: Set as : "Contact Person"
Local : Field : SD Phone : Set as : "Phone"
Local : Field : SD Address : Set as : "Address"
Border : Column Titles

[Part : TMSD Address Book]
Line : TMSD Address Book
Repeat : TMSD Address Book : TM Sundry Debtors
Scroll : Vertical
Common Border : Yes

[Line : TMSD Address Book]
Field : SD Sr No, SD Name
Right Field : SD Contact No, SD Phone, SD Address

[Field : SD Sr No]
Use : Short Name Field
Set as : $$Line
Style : Normal
Width : 4
Align : Centre

[Field : SD Name]
Use : Name Field
Set as : $Name
Full Width : Yes
Style : Normal
Border : Thin Left

[Field : SD Contact No]
Use : Short Name Field
Set as : $LedgerContact
Style : Normal
Border : Thin Left

[Field : SD Phone]
Use : Short Name Field
Set as : $LedgerPhone
Style : Normal
Border : Thin Left

[Field : SD Address]
Use : Short Name Field
Set as : $$FullList:Address:$Address
Style : Normal
Border : Thin Left
Lines : 0

[Collection: TM Sundry Debtors]
Type : Ledger
Child of : $$GroupSundryDebtors
Belongs To : Yes


[Report : TMSC Address Book]
Use : TMSD Address Book
Local : Collection : TM Sundry Debtors : Child Of : $$GroupSundryCreditors

Lesson 7 : UDF In Ledger Creation

Create a Single UDF in Ledger Master to store the value of ECC Number.

[system : UDF]
ECC : String : 100

[#Part : Led Other Details]
Add : Line : Eccln

[Line:Eccln]
Field : Short Prompt, Eccfld
Local : Field: Short Prompt:Set as: "Ecc no"

[Field: Eccfld]
Use : Short Name Field
Storage : Ecc

Lesson 6 : Learn UDF, How to Use UDF

Defining a UDF

Users can define Fields which have a storage component defined. User Defined Fields (UDF) can
be of type String, Amount, Quantity, Rate, Number, Date and Logical .

[System: UDF]
Name of UDF: Type of UDF: Index Number: Is Repeatable

All User Defined Fields must be defined at the System level. The programmer has to give a unique name to the UDF, by which it will be accessed. For every UDF, an index number has to be provided

[System: UDF]
MyUDF : String : 3

[Field: NewField]
Use : NameField
Storage : MyUDF ;;--------- To store the value

[Field: MyField]
Use : NameField
Set as : $MyUDF ;;--------- To retrieve the value

Lesson 5 : Design your Own Invoice Printing

;; Design Your Own Invoice Printing Only Thru Tally Mani Blog

[#Form: Comprehensive Invoice]
Add : Option : My Invoice : @@IsSales

[#Form: Simple Printed Invoice]
Add : Option : My Invoice : @@IsSales

[! Form : My Invoice]
Delete : Parts
Delete : Bottom Parts
Delete : PageBreak
Space Top : 0
Space Bottom: 0
Space Left : 0
Space Right : 0

Add : Parts : My Invoice Top Part, My Invoice Body Part
Add : Bottom Part: My Invoice Bottom Part
Add : Pagebreak : CLPGBrk,OPGBrk

[Part: My Invoice Top Part]
Line : MI CmpName,MI VCHDate,MI PartyName,MI PartyAdd1, MI ColumnTitles
Repeat: MI PartyAdd1:PartyAddress

[Line: MI CmpName]
Field : MI CmpName

[Field: MI CmpName]
Use : Name Field
Set as : @@CMPMailNAme
FullWidth : yes
Align : Centre

[Line: MI VCHDate]
Field : Short Prompt, MI VCHDate
Right Field : Simple Prompt, MI VCHNo
Local : Field : Short Prompt : Set as : "Voucher Date : "
Local : Field : Simple Prompt : Set as : " Voucher No : "

[Field: MI VCHDate]
Use : Short Date Field
Set as : $Date

[Field: MI VCHNo]
Use : Short Name Field
Set as : $VoucherNumber

[Line: MI PartyName]
Field : Short Prompt, MI PartyNAme
Local : Field : Short Prompt : Set as : "Party Name : "

[Field: MI PartyName]
Use : Name Field
Set as : $PartyLedgerName

[Line: MI PartyADd1]
Field : MI PartyADd1

[Field: MI PartyADd1]
Use : Name Field
Set as : $Address
Indent : 10

[Line: MI Column Titles]
Use : IE Details
Local : Field : Default : Lines : 2
Local : Field : Default : Type : String
Local : Field : Default : Style : Normal Bold
Local : Field : Ie SRNo : Set as : "Sr No"
Local : Field : IE SiName : Set as : "Name"
Local : Field : IE Qty : Set as : "Billed Qty"
Local : Field : IE Rate : Set as : "Rate"
Local : Field : IE Amount : Set as : "Amount"
Border: Column Titles

[Part : My Invoice Body Part]
Part : IE Details, LE Details
Vertical : Yes
Scroll : Vertical
Common Border : yes

[Part : IE Details]
Line :IE Details
Repeat : IE Details : Inventory Entries
Total : IE Qty, IE Amount

[Line : IE Details]
Field : IE SrNo, IE SiName
Right Field : IE Qty, IE Rate, IE Amount
Explode : Item Desc : $$NumItems:UserDescription > 0

[Part : Item Desc]
Line : Item Desc
Repeat : Item Desc : UserDescription

[Line : Item Desc]
Field : Item Desc

[Field : Item Desc]
Use : Name Field
Width : 40
Indent : 8
Set as : $UserDescription
Style : Normal Italic


[Field : IE SrNo]
Use : Short Name Field
Set as : $$Line
Border : Thin Left
Width : 4

[Field : IE SIName]
Use : Name Field
Set as : $StockItemName
Border : Thin Left
FullWIdth : Yes
[Field : IE Qty]
Use : Number Field ;; Qty Primary Field
Set as : $BilledQty
Border : Thin Left
Format : "NoSymbol,Primary"
Align : Right

[Field : IE rate]
Use : Rate Price Field
Set as : $Rate
Border : Thin Left

[Field : IE Amount]
Use : Amount Field
Set as : $Amount
Border : Thin Left Right
Format : "NoComma,NoZero"

[Part : LE Details]
Line : LE Details
Repeat : LE Details : Ledger Entries
Scroll : Vertical

[Line : LE Details]
Use : IE Details
Local : Field : IE SrNo : Set as : ""
Local : Field : IE SiName: Set as : $LedgerName
Local : Field : IE Qty : Set as : ""
Local : Field : IE Rate : Set as : +
$$String: $RateOfInvoiceTax +“%”
Local : Field : IE Amount: Set as : $Amount
Local : Field : IE SiName: Align : Right
Local : Field : IE Qty : Format : "NoZero"
Local : Field : IE Rate : InActive: $RateOfInvoiceTax = 0
Local : Field : IE Rate : Type : String
Empty : $LedgerName = $PartyLedgerName


[Part : My Invoice Bottom Part]
Line : MI Total Line, MI AmtInWords, MI ForCmp, MI AuthSign

[Line : MI Total Line]
Use : IE Details
Local : Field : Default : Style : Normal Bold
Local : Field : IE SrNo : Set as : ""
Local : Field : IE SiName: Set as : "Totals"
Local : Field : IE Qty : Set as : $$Total:IEQty
Local : Field : IE Rate : Set as : ""
Local : Field : IE Amount: Set as : $Amount
Border : Totals

[Line : MI AmtInWords
Field : Short Prompt, MI AmtInWords
Local : Field : Short Prompt : Set as : "Amount in words : "

[Field : MI AmtInWords]
Use : Name Field
Set as : $$InWords:$Amount
FullWidth : yes
Style : Small

[Line : MI ForCmp]
Right Field : MI ForCmp
[Field : MI ForCmp]
Use : Name Field
Set as : "For " + @@CMPMailNAme
Align : Right
Width : 0

[Line : MI AuthSign]
Right Field : MI AuthSign
Space Top : 2

[Field : MI AuthSign]
Use : Name Field
Set as : "Authorised Signatory"
Width : 0
Align : Right
[Part : CLPGBrk]
Line : CLPGBrkln
[Line :CLPGBrkln]
Right Field : CLPG Brkfld
[Field :CLPG Brkfld]
Use : Name Field
Set as :” Continued………………….”
[Part: OPGBrk]
Use : My Invoice Top Part

Lesson 4 : Design Your Own Trail Balance Through TDL

;; Design your Own Trailbalance

[#Menu: Gateway of Tally]
Add : Item : TMTrialBalance : Display : TM Trial Balance

[Report: TM Trial Balance]
Form : TM Trial Balance

[Form: TM Trial Balance]
Top Part : TMTB Detail

[Part: TMTB Detail]
Top Line : TMTB Detail
Repeat : TMTB Detail: TMTB Collection
Scroll : Vertical

[Line: TMTB Detail]
Left Fields : TMTB Name
Right Fields : TMTB Amt

[Field: TMTB Name]
Width : 30
Set as : $Name

[Field: TMTB Amt]
Type : Amount
Width : 15
Set as : $ClosingBalance
Align : Right

[Collection: TMTB Collection]
Type : Ledger

Lesson 3 : Creating a Sample Report, My First Report

Lesson 3 (Creating Report & form)

[#Menu: Gateway of Tally]
Item: My First TDL: Display: My First Report

[Report: My First Report]
Form: My First Form

[Form: My First Form]
Part: My First Part

[Part: My First Part]
Line: My First Line

[Line: My First Line]
Field: My First Field

[Field: My First Field]
Set as: “Welcome to the world of TDL”

Lesson 2 : Creating Menu & Sub Menu Thru TDL, Tally Menu

Lesson 2 (Creating Menu & Sub Menu in the Gateway of Tally Through TDL)

[#Menu: Gateway of Tally]
Item : Quarterly Reports: Menu: MIS Reports

[Menu: MIS Reports]
Item : MIS Report 1
Item : MIS Report 2

Lesson 1 : Creating a New Menu in Tally Thru TDL

Lesson 1 (Creating New menu in the Gateway of Tally, Through TDL)

[#Menu: Gateway of Tally]
Item: My FirstTDL