How to create customize Software in Tally using TDL
Dear Friends there are Many Accounting Software Like Sap ERP , Tally ERP , Bussy , KhataBook and Zoho Books. etc. All accounting Software has Three Funda (Rule)
1. Master :- Like Group , Ledger , Stock Item , Stock Group , Unit etc. 2.Transection :- Like Contra , Payment , Receipt , Journal , Sales , Purchase , Debit Note , Credit Note etc. 3.Report :- Like Balance Sheet , Trial Balance , Profit & Loss , Sales Register , Purchase Register , Payment Register , Receipt Register etc. First we learn how to create Master in Tally Software. When we save any Master this save into Tally Database like a Table. In the First Part we learn How to create Group Ledger using TDL.In the Second Part we learn How to create Ledger Master in Tally using TDL.
In the Third Part we learn How to create Cost Centre in Tally Using TDL.
In the Fourth Part we learn How to create Cost Category in Tally Using TDL.
Dear Friends We can also Create any Voucher using Tally TDL for more you can visit My Channel Anurag Tiwari and Practice it create Different type of Voucher and Multiple Dr and Cr.
In the Fifth Part we learn How to create Stock Group in Tally Using TDL.
In the Sixth Part we learn How to create Stock Category in Tally Using TDL.
In the Seventh Part we learn How to create Godown in Tally Using TDL.
In the Eighth Part we learn How to create Stock Item in Tally Using TDL.
Dear Friend it's Important to learn that what type of Object we use for Creating Master
1. Ledger Group [Object: Group]
2. Ledger [Object: Ledger]
3. Cost Centre [Object: CostCentre]
4. Cost Category [Object: CostCategory]
5.Stock Group [Object: StockGroup]
6. Stock Category [Object: StockCategory]
7. Godown [Object: Godown]
8. Stock Item [Object: StockItem]
In Ninth Part we learn how to Create Group Report in Tally Using TDL.
In Tenth Part we learn how to Create Ledger Report in Tally Using TDL.
In Eleventh Part we learn how to Create Cost Centre Report in Tally Using TDL.
In Twelfth Part we learn how to Create Cost Category Report in Tally Using TDL.
In Thirteenth Part we learn how to Create Stock Group Report in Tally Using TDL.
In Fourteenth Part we learn how to Create Stock Category Report in Tally Using TDL.
In Fifteenth Part we learn how to Create Godown Report in Tally Using TDL.
In Sixteenth Part we learn how to Create Stock Item Report in Tally Using TDL.
I request to all of you write TDL code how to create Ledger Group ,Ledger , Cost Centre Cost Category Stock Group Stock Category Godown and Stock Item
Now Friend also Create Group Ledger Report, Ledger Report , Cost Centre Report , Cost Category Report , Stock Group Report , Stock Category Report , Godown Report , Stock Item Report
Link Table of Tally Database :-
# Link Cost Category with Ledger Master
# Link Cost Centre with Ledger Master
[Field : LedCostCentF]
Use : Name Field
Storage : CentUdf
Table : CostCentre Coll
Show Table : Always
[System : UDF]
CentUdf : String : 1001
# Link Stock Category with Stock Item
# Link Godown with Stock Item
use this code for your task
[#Menu : Gateway of Tally]
Add : Item : Create Voucher Using Function : Call : MyVchCreate
[Function: MyVchCreate]
Action : 01 : NEW OBJECT : VOUCHER
Action : 02 : SET VALUE : Date : "01-06-2023"
Action : 03 : SET VALUE : VoucherTypeName : Journal
Action : 04 : SET VALUE : Narration :My bill due al-kdahrfyhasjhnfkjlashrf
Action : 05 : INSERT COLLECTION OBJECT : AllLedgerEntries
Action : 06 : SET VALUE : LedgerName : Hari
Action : 07 : SET VALUE : Is Deemed Positive : "Yes"
Action : 08 : SET VALUE : Amount : -60
Action : 09 : SET TARGET : ...
Action : 10 : INSERT COLLECTION OBJECT : AllLedgerEntries
Action : 11 : SET VALUE : LedgerName : Ravi
Action : 12 : SET VALUE : Amount : 20
Action : 13 : SET VALUE : Is Deemed Positive : "No"
Action : 14 : SET TARGET : ..
Action : 15 : INSERT COLLECTION OBJECT : AllLedgerEntries
Action : 16 : SET VALUE : LedgerName : ant
Action : 17 : SET VALUE : Amount : 40
Action : 18 : SET VALUE : Is Deemed Positive : "No"
Action : 19 : SET TARGET : ..
Action : 20 : SET VALUE : PersistedView : ##SVViewName
Action : 21 : CREATE TARGET
Dear friend now create a form and using this form and function create voucher
[#Menu:Gateway of Tally]
ReplyDeleteAdd:Item:Creat-Master:Menu:Master
[Menu:Master]
Indent:"Account Master"
Item: Blank
Add:Item:Group:Create Collection:Group Coll
[Collection:Group Coll]
Type:Group
Report:GrpReport
[Report:GrpReport]
Title:"Group Creation"
Form:GrpForm
Object:Group
[Form:GrpForm]
Use:Master form Template
Part:GrpNamePart,GrpParentPart
[Part:GrpNamePart]
Line:GrpNameLine
[Line:GrpNameLine]
Field:Medium Prompt,GrpNameField
Local:Field:Medium Prompt:Set as:"Group Name"
[Field:GrpNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
[Part:GrpParentPart]
Line:GrpParentLine
[Line:GrpParentLine]
Field:Medium Prompt,GrpParentField
Local:Field:Medium Prompt:Set as:"Parent"
[Field:GrpParentField]
Use:Name Field
Storage:Parent
Table:Group
Show Table:Always
Sir Creat Collection ke bad Alter and Display ka Collection keyse hoga pls describe..
ReplyDeleteWhy not Here we all discuss everything for create custom software and tnx Krishnendu ji for comment
ReplyDelete[#Menu:Gateway of Tally]
ReplyDeleteAdd:Item:Creat-Master:Menu:Master
[Menu:Master]
Indent:"Account Master"
Item: Blank
Add:Item:Group:Create Collection:Group Coll
Add:Item:Ledger:Create Collection:Ledger Coll
Add:Item:Cost Centre:Create Collection:CostCentre Coll
Add:Item:Cost Category:Create Collection:CostCategory Coll
;;Creat Group Master
[Collection:Group Coll]
Type:Group
Report:GrpReport
[Report:GrpReport]
Title:"Group Creation"
Form:GrpForm
Object:Group
[Form:GrpForm]
Use:Master form Template
Part:GrpNamePart,GrpParentPart
[Part:GrpNamePart]
Line:GrpNameLine
[Line:GrpNameLine]
Field:Medium Prompt,GrpNameField
Local:Field:Medium Prompt:Set as:"Group Name"
[Field:GrpNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
[Part:GrpParentPart]
Line:GrpParentLine
[Line:GrpParentLine]
Field:Medium Prompt,GrpParentField
Local:Field:Medium Prompt:Set as:"Parent"
[Field:GrpParentField]
Use:Name Field
Storage:Parent
Table:Group
Show Table:Always
;;Creat Ledger Master
[Collection:Ledger Coll]
Type:Ledger
Report:LedReport
[Report:LedReport]
Title:"Ledger Creation"
Form:LedForm
Object:Ledger
[Form:LedForm]
Use:Master form Template
Part:LedNamePart,LedParentPart
[Part:LedNamePart]
Line:LedNameLine
[Line:LedNameLine]
Field:Medium Prompt,LedNameField
Local:Field:Medium Prompt:Set as:"Ledger Name"
[Field:LedNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
[Part:LedParentPart]
Line:LedParentLine
[Line:LedParentLine]
Field:Medium Prompt,LedParentField
Local:Field:Medium Prompt:Set as:"Parent"
[Field:LedParentField]
Use:Name Field
Storage:Parent
Table:Group
Show Table:Always
;;Creat CostCentre Master
[Collection:CostCentre Coll]
Type:CostCentre
Report:CostCentReport
[Report:CostCentReport]
Title:"Cost Centre Creation"
Form:CostCentForm
Object:Cost Centre
[Form:CostCentForm]
Use:Master form Template
Part:CostCentNamePart
[Part:CostCentNamePart]
Line:CostCentNameLine
[Line:CostCentNameLine]
Field:Medium Prompt,CostCentNameField
Local:Field:Medium Prompt:Set as:"Cost Centre Name"
[Field:CostCentNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
;;Creat CostCategory Master
[Collection:CostCategory Coll]
Type:Cost Category
Report:CostCatgReport
[Report:CostCatgReport]
Title:"Cost Category Creation"
Form:CostCatgForm
Object:CostCategory
[Form:CostCatgForm]
Use:Master form Template
Part:CostCatgNamePart
[Part:CostCatgNamePart]
Line:CostCatgNameLine
[Line:CostCatgNameLine]
Field:Medium Prompt,CostCatgNameField
Local:Field:Medium Prompt:Set as:"CostCategoryName"
[Field:CostCatgNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
Sir Cost Centre & Cost Category menu me escape or exit nehi ho raha hai Tally hang ho raha hai
ReplyDeleteaap Tally ka kon sa version use kar rahe hi
ReplyDeleteSir latest version
Deleteaap har master ki alag alag file bana kar include ka use kare in your main file [include : your file name] maine apni is playlist main bataya hi
ReplyDelete[#Menu:GateWay of Tally]
ReplyDeleteAdd: Item: Create-Master: Menu: Master
[Menu:Master]
Indent: "Account Master"
Item : Blank
Add: Item: Group: Create Collection: Group Coll
Add: Item: Ledger: Create Collection: Ledger Coll
Add: Item: Cost Centre: Create Collection: CostCentre Coll
[Include: 01-00-Gsp Mstr.txt]
[Include: 02-00-Led Mstr.txt]
[Include: 03-00-Cost Cent.txt]
[Include: 04-00-Cost Cat.txt]
--
Tnx Ashok Ji for Comment
Delete;01 Add Mwnu Item
ReplyDelete[#Menu:Gateway Of Tally]
Add:Item:Creat-Master:Menu:Master
;02
[Menu:Master]
Indent:"Account Master"
Item :Blank
Add:Item:Group:Create Collection:Group Coll
;03
[Collection:Group Coll]
Type:Group
Report:GrpReport
;04
[Report:GrpReport]
Title:"Group Creation"
Form:GrpForm
Object:Group
;05
[Form:Grpform]
Use:Master Form Template
Part:GrpNamePart,GrpParentPart
;06
[Part:GrpNamePart]
Line:GrpNameLine
;07
[Line:GrpNameLine]
Field:Mediumprompt,GrpNameField
Local:Field:MediumPrompt:Set As:"Group Name"
;08
[Field:GrpNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
;09
[Part:GrpParentPart]
Line:GrpParentLine
;10
[Line:GrpParentLine]
Field:Mediumprompt,GrpNameField
Local:Field:MediumPrompt:Set As:"Parent"
;11
[Field:GrpParentField]
Use:Name Field
Storage:Parent
Table:Group
Show Table:Always
Tnx Ashok Ji
Delete[#Menu:Gateway Of Tally]
ReplyDeleteAdd:Item:Creat-Master:Menu:Master
;01
[Menu:Master]
Indent:"Account Master"
Item :Blank
Add:Item:Group:Create Collection:Group Coll
Add:Item:Ledger:Create Collection:Ledger Coll
;02
[Collection:Ledger Coll]
Type:Ledger
Report:LedReport
;03
[Report:LedReport]
Title:"Ledger Creation"
Form:LedForm
Object:Ledger
;04
[Form:LedForm]
Use:Master Form Template
Part:LedNamePart,LedParentPart
;05
[Part:LedNamePart]
Line:LedNameLine
;06
[Line:LedNameLine]
Field:Mediumprompt,LedNameField
Local:Field:MediumPrompt:Set As:"Ledger Name"
;07
[Field:LedNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
;08
[Part:LedParentPart]
Line:LedParentLine
;09
[Line:LedParentLine]
Field:Mediumprompt,LedParentField
Local:Field:MediumPrompt:Set As:"Parent"
;010
[Field:Parent]
Use:Name Field
Storage:Parent
Table:Group
Show Table:Always
;01 Add Mwnu Item
ReplyDelete[#Menu:Gateway Of Tally]
Add:Item:Creat-Master:Menu:Master
;02
[Menu:Master]
Indent:"Account Master"
Item :Blank
Add:Item:Group:Create Collection:Group Coll
Add:Item:Ledger:Create Collection:Ledger Coll
Add:Item:Cost Centre:Create Collection:CostCentre Coll
;03
[Collection:CostCentre Coll]
Type:CostCentre
Report:CostCentReport
;04
[Report:CostCentReport]
Title:"CostCentre Creation"
Form:CostCentForm
Object:CostCentre
;05
[Form:CostCentForm]
Use:Master Form Template
Part:CostCentNamePart
;06
[Part:CostCentNamePart]
Line:CostCentNameLine
;07
[Line:CostCentNameLine]
Field:Mediumprompt,CostCentNameField
Local:Field:MediumPrompt:Set As:"CostCentName"
;08
[Field:CostCentNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
;01 Add Mwnu Item
ReplyDelete[#Menu:Gateway Of Tally]
Add:Item:Creat-Master:Menu:Master
;02
[Menu:Master]
Indent:"Account Master"
Item :Blank
Add:Item:Group:Create Collection:Group Coll
Add:Item:Ledger:Create Collection:Ledger Coll
Add:Item:Cost Centre:Create Collection:CostCentre Coll
Add:Item:Cost Category:Create Collection:CostCategory Coll
;03
[Collection:CostCatgReport Coll]
Type:CostCategory
Report:CostCatgReport
;04
[Report:CostCatgReport]
Title:"CostCategory Creation"
Form:CostCatgForm
Object:CostCategory
;05
[Form:CostCatgForm]
Use:Master Form Template
Part:CostCatgNamePart
;06
[Part:CostCatgNamePart]
Line:CostCatgNameLine
;07
[Line:CostCatgNameLine]
Field:Mediumprompt,CostCategNameField
Local:Field:MediumPrompt:Set As:"CostCategory Name"
;08
[Field:CostCatgNameField]
Use:Name Field
Storage:Name
Case:First Upper Case
Unique:Yes
;;---end---
THANK YOU ASHOKE SINGHVI JI
DeleteTnx Ashok ji for this Comment
ReplyDeleteHi Team, Thanks for giving such a valuable knowledge on Tally Developer language and it's utility. Can you Please share some code and demos on connecting MySQL or Oracle with Tally using creating and Using API with C# or Python. Thanks in advance
ReplyDeleteDear vardha ji Tnx and welcome for this you can visit @anuragtiwari7149 here we upload regular basis video on python SQLite3 Excel to Tally Using Python send data to Tally direct and many more
Delete