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.
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





























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. 

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



   

You can also use Object in Form for Creating Voucher using Function. For More visit @anuragtiwari7149 



















Comments

  1. [#Menu:Gateway of Tally]
    Add: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

    ReplyDelete
  2. Sir Creat Collection ke bad Alter and Display ka Collection keyse hoga pls describe..

    ReplyDelete
  3. Why not Here we all discuss everything for create custom software and tnx Krishnendu ji for comment

    ReplyDelete
  4. [#Menu:Gateway of Tally]
    Add: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

    ReplyDelete
  5. Sir Cost Centre & Cost Category menu me escape or exit nehi ho raha hai Tally hang ho raha hai

    ReplyDelete
  6. aap 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
  7. [#Menu:GateWay of Tally]
    Add: 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]
    --

    ReplyDelete
  8. ;01 Add Mwnu Item
    [#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

    ReplyDelete
  9. [#Menu:Gateway Of Tally]
    Add: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

    ReplyDelete
  10. ;01 Add Mwnu Item
    [#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

    ReplyDelete
  11. ;01 Add Mwnu Item
    [#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---

    ReplyDelete
  12. Hi 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

    ReplyDelete
    Replies
    1. Dear 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

Post a Comment

Popular posts from this blog

How to Customize Sale Invoice

Sales Report with Pending Amount Part-14th (Final)