a) What are the pre-requisites to install Tally 9?
Another Achievement from Tally Mani, Now You can print your Barcode Label from Tally 9
Now Generate your Barcode Label directly from Tally 9
Now Logo Printing is possible in Tally9
Now Tally mani Proudly announce Logo printing possibilities in Tally 9.
[#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
;; 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
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
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
;; 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
;; 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 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 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 New menu in the Gateway of Tally, Through TDL)
[#Menu: Gateway of Tally]
Item: My FirstTDL
