Please note that the project sub form shown here is only for a demonstration purpose and you don’t have to run your Tally in the developer mode! To find out the default definitions you have to look for a key word from Tally and then go to Tally developer use Control +D and search for that keyword and follow the steps as shown in the earlier chapter in led contact details .

To find out the default definitions in stock item master, please refer the unit 1, module 4.

If you are using Tally developer release 6.6.1 or above then you will not find out the .500 file name. Because Folder name and file name are changed in Tally developer 6.6.1 and above. you will have to find out the main file

which are like masters/ledgers, masters/stkitem and inside that fodler there is a top main file from which you can find out the report file which is the replacement for the earlier .500 files.
For a quick reference stkitemreport.tdl under the master/stkitem stkmain.tdl is the default report file which was earlier stkitem.500 file


https://tallynine.com/module-4/how-to-look-up-the-existing-definition-in-tdl/

61 thoughts on “How to retrieve the Field Value using Storage Name/UDF Name

  1. Nct Solutions Nct Solutions says:

    sir i have done this coding as per video but it is showing error in TDL
    plz check whats the error

    [#Part:Led contact]
    Add: Line: ledmasterline: Retrive opening line

    [Line: Retrive opening line]
    Field: medium prompt, opbalfld
    Local: Field: medium prompt: Set as:”opening balance is rs”

    [Field: opbalfld]
    Use: amount field
    Set as: $openingbalance

    1. Hello,
      You need to read and try to understand the error. Please post your error message here.
      and when a code doesn’t work you need to review the course chapter/video again. May be it is just a small error. a careful review of your code can help you to sort out issues on your own.

      [#Part:Led contact]
      Add: Line: ledmasterline: Retrive opening line

      Here you used : instead of a , between the two lines
      it should be

      [#Part:Led contact]
      Add: Line: ledmasterline, Retrive opening line

  2. Nct Solutions Nct Solutions says:

    hello sir,
    i have write these codes to fetch units automatically from master in stock item ledger
    but it not showing any result…plz check where is the error

    [#Part: STKI Units]
    Add:Line: retrive units

    [Line:retrive units]
    Field: medium prompt, units field
    Local:Field:medium prompt:Set as:$$LocaleString:”unit of item”

    [Field:units field]
    Use:symbol field
    Set as: $baseunits

  3. Giridharan Varadharajan says:

    Giridharan varadharajan

    Sir,
    I want to know the following from you, which I think is very vital in TDL Development
    1. How to Open Tally In Developer mode. Only then we know what is default name we are searching for. Then only we can with Developer help locate the exact.

    2.assume that we have located the field in Tally developer, then how to find out its Line, part, form in its higher hierarchy from field level.

    It if get some clarity on the above, then it will be very easy.
    Please help me in this regard.
    Regards.
    Giridharan Varadharajan

    1. Hello Giridharan,
      Yes, there are multiple ways to find out the default definitions in Tally TDL.
      There are 4 chapters on the same subject. Easiest way to do is to run the tally in the Developer mode and there is a tutorial also on how to run the Tally in the Developer mode. You will get them in the next chapters.

      But learning something new in the hard way is a better approach thats why I kept those chapters later as I don’t want to give an easy way to students.
      Once they learn it in the hard way, they will be better to do hard ways else if they get the things easily, they will lose the interest. Also the real passionate will continue.

  4. Giridharan Varadharajan says:

    Giridharan Varadharajan

    Sir,
    I have attached the output & code for retrieving the default storage-ledger Opening balance in my folder.
    for your information.
    Regards
    Giridharan Varadharajan

  5. Virat Mehta says:

    [#Part: ledcontact]
    Add: Line :After :ledmasterline : retrive openingline

    [Line : retrive openingline]
    Field: medium prompt, opbalfd
    Local: Field:medium prompt: Set as:”opening balance is Rs.”

    [Field: opbalfd]
    Use: amount field
    Set as: $openingbalance

    as u say i done coding but nothing happen in my tally erp9
    i am facing error
    its error in tdl
    ‘field:yournewfld’
    incorrect type of field!
    conflict with storage!

  6. vishal

    [#Part: LedContact]
    Add: Line: After: LedMasterline: Retrive Openingline

    [Line: Retrive Openingline]
    Field: Medium Prompt, opBalfld
    Local: Field: Medium Prompt: Set as: “Opening Balance is Rs.”

    [Field: opBalFld]
    Use: Amount Field
    Set as: $OpeningBalance

    sir please help me out
    hwy this code is not working ?

  7. but first resolve the issue that why i am not able to see comment

  8. sricomputerskarur says:

    Sir, I have one doubt.
    I can execute tally from developer. But it couldnt work in developer mode, and its not showing the definition name of the pointing field, like yours.

    1. That simply means the Tally is not running in the Developer mode. If it is running in the developer mode then it will 100% show the default definitions.
      But right now you accessing the Field Retrival value so you don’t need to run Tally in the developer mode. There are other chapters for running the Tally in The developer which you can refer.
      The reason is that just by executing the tally through right click in the Tally developer doesn’t meant that Tally will run in the Developer mode. It will run Tally with or without the developer mode.

  9. knbestsolution says:

    ;stckitem level

    [#Part: STKI Units]
    Add:Line:After:STKI BaseUOM:STKI QTY
    Background:YELLOW

    [Line:STKI QTY]
    Field:MEDIUM PROMPT,STKI QTY VALUE
    Local:Field:MEDIUM PROMPT:Set as:”QTY IN BOX”
    Local:Field:MEDIUM PROMPT:Color:RED

    [Field:STKI QTY VALUE]
    Use:NUMBER FIELD
    Storage:QTYINBOX
    Color:BLUE

    [System:UDF]
    QTYINBOX:Number:1221

    ;;======================;;
    ;sumbform in entry level
    [#Line : EI ColumnOne]
    Add : Option : EI ColumnOneOpt : @@IsSales

    [!Line : EI ColumnOneOpt]
    Add : Right Fields : Before : VCH QtyTitle : VCH BOXQTY
    Local : Field : VCH BOXQTY : Info : “QTY IN BOX”
    Local : Field : VCH BOXQTY : Color : Red

    [Field : VCH BOXQTY]

    Use : NAME FIELD
    Set as:” ”
    Set Always : Yes
    Style : Small Bold
    Width : 2.5 cms
    Align : Right

    [#Line : EI InvInfo]

    Add : Option : EI InvInfoOpt : @@IsSales

    [!Line : EI InvInfoOpt]

    Add : Right Fields : Before : VCH BilledQty : VCHBOXQTYVAL

    [Field: VCHBOXQTYVAL]
    Use: NUMBER FIELD
    Style : Small Bold
    Width : 2.5 cms
    Align : Right
    Set as :$QTYINBOX:StockItem:$StockItemName
    Background:RED
    This is my code but the value in item master is storing but not in sales invoice the value is not fetching from master

    1. Save your codes in the Dropbox, I will check that in evening and revert back to you

  10. knbestsolution says:

    ;stckitem level

    [#Part: STKI Units]
    Add:Line:After:STKI BaseUOM:STKI QTY
    Background:YELLOW

    [Line:STKI QTY]
    Field:MEDIUM PROMPT,STKI QTY VALUE
    Local:Field:MEDIUM PROMPT:Set as:”QTY IN BOX”
    Local:Field:MEDIUM PROMPT:Color:RED

    [Field:STKI QTY VALUE]
    Use:NUMBER FIELD
    Storage:QTYINBOX
    Color:BLUE

    [System:UDF]
    QTYINBOX:Number:1221

    ;;======================;;
    ;sumbform in entry level
    [#Line : EI ColumnOne]

    Add : Right Fields : Before : VCH QtyTitle : medium prompt,
    Local:Field:medium prompt:Set as:”QTY IN BOX”
    Local:Field:medium prompt:Align:Right
    Local:Field:medium prompt:Width:2.5 cms

    [#Line : EI InvInfo]

    Add : Right Fields : Before : VCH BilledQty : VCHBOXQTYVAL

    [Field: VCHBOXQTYVAL]
    Use: NUMBER FIELD
    Style : Small Bold
    Width : 2.5 cms
    Align : Right
    Set as :$QTYINBOX:StockItem:$StockItemName
    Background:RED

    PARVATHI
    24/3/18

  11. pmshabinjacob says:

    I did not find the subform in Tally Developer to find out the default definition of field?

    Please help me..

  12. Rani Kahar says:

    sir please help me out from this problem
    sir i’m not be able to get the value in day book which is put in the sales voucher…..
    this is my code.

    [#Line: DBTITLE1]
    Add : Fields :After :DSPVchAcctTitle: TC_MARGIN

    [Field:TC_MARGIN]
    Use : Name Title Field
    Info : $$LocaleString:”Margin”
    Style : Normal Bold
    Width : @@ShortNameWidth

    [#Line: DSP VchDetail]
    Add: Right Field: Before : DSP VchType :TC_MARGINAMOUNT1

    [Field: TC_MARGINAMOUNT1]
    Use : Name Field
    Set as: $…Margin ;:VoucherType:$VoucherTypeName
    Style : Normal
    Set Always:Yes
    Width : 15

    ;;============================================ voucher level ========================================================

    [#Line: EI ColumnOne]
    Option : EIColumnOne1:@@IsSales
    [!Line : EIColumnOne1]
    Add : Right Field : Before : VCH QtyTitle :TC_MARGINTITLE

    [Field:TC_MARGINTITLE]
    Use : Name Title Field
    Set as : “Margin”
    Style : Normal Bold
    Skip : Yes
    Width : 12

    [#Line: EI InvInfo]
    Option : EIInvInfo1:@@ISSales

    [!Line : EIInvInfo1]
    Add : Right Field : Before : VCH BilledQty :TC_MARGINAMOUNT

    [Field: TC_MARGINAMOUNT]
    Use : Name Field
    Style : Normal Bold
    Width : 15
    Storage:Margin
    Align : Center

    [System:UDF]
    Margin : String : 2121

    1. Hello Rani,

      I have observed that you are not studying the course chapters and unless you study them, you can’t learn it.
      Also, even through no matter how much I wish, It is not possible to offer support for projects beyond the course chapters.

      But if you follow the course, you will learn those art. The reason is that in TDL one solutions doesn’t work for every projects and that is the reason, I insist everyone to study every project and learn the art of solving problems.

      You need to add the collections or modify a collection and add the UDF to that collections.
      Adding UDF to the collections is already explained in some chapters.

  13. Rani Kahar says:

    [Field: TC_MARGINAMOUNT1]
    Use : Name Field
    Set as: $Margin
    Style : Normal
    Set Always:Yes
    Width : 15

    i had try this one also…….

  14. BrajeshKumar Verma says:

    I want stock items allocations link

    please help me out

  15. Aalap Shah says:

    Sir

    i did not find any sub form in my tally developer nine

    Please guide me to turn on that function

    1. Hello Aalap,
      In the chapter no where I mentioned to create any sub form!

      Just read the course cahpter and try to undersand and if you have any queries, please do let me know what issues you are having exactly?
      but creating a sub form is not a part of this chapter!

  16. Mohd Mahmood ali khan says:

    [#Part : ledcontact]
    Add : Line :after : ledmasterline : retrive openingline

    [Line : retrive openingline]
    Field : medium propmt, opening balance
    Local : Field : medium prompt : Set as :”opening balance is”

    [Field : opening balance]
    Use : Amount Field
    Set as : $OpeningBalance

    hi sir,

    please see the above code what error. its not showing in tally.

    1. Check your codes again and compare with the course chapter carefully

      Where is the ledmasterline? Is it defined in your code? if not then remove this line and test it again.

  17. madhuri Kumar says:

    hello
    how to take the tally screen shot for uploading purpose. plz guide me

  18. madhuri Kumar says:

    [#Part: STKI Units]

    add: Lines :after :STKI BaseUOM :myunit

    [Line: my unit]

    Fields : my unit
    [Field: my unit]
    Use : Symbol Field
    set as :$BaseUnits
    Set Always: yes

  19. Sudhir Verma says:

    Hello Sir,
    In ledger master opening balance fetch but when i want to other ledger’s details fetch instead of opening Balance then value does not shows or fetch.

    This is my code….

    [#Part: LED Contact]

    Add : Line : LedOpnBlnce ,LedTransactionTyp ,LedgerBankName, LedgerAccountNo, LedIFSC

    [Line: LedOpnBlnce]

    Fields : Medium Prompt, Name Field, Led FetchOpnBlnce
    Local : Field : Medium Prompt : Set as : $$LocaleString:”Opening Balance”
    Local : Field : Name Field : Set as : $OpeningBalance
    Local : Field : Name Field : Width : @@NumberWidth
    Local : Field : Name Field : Format : “AllSymbols,NoZero”

    Local : Field : Default : Color : Blue

    [Field: LED FetchOpnBlnce]

    Use : Amount DrCr Field
    Set as : $OpeningBalance
    Skip : Yes
    Format : “NoZero”

    [Line: LedTransactionTyp]

    Fields : Medium Prompt, Name Field
    Local : Field : Medium Prompt : Set as : $$LocaleString:”Transaction Type”
    Local : Field : Name Field : Set as : $DefaultTransactionType

    Local : Field : Default : Color : Blue

    [Line: LedgerBankName]

    Fields : Medium Prompt, Name Field
    Local : Field : Medium Prompt : Set as : $$LocaleString:”Bank name”
    Local : Field : Name Field : Set as : $BankName

    Local : Field : Default : Color : Blue

    [Line: LedgerAccountNo]

    Fields : Medium Prompt, Name Field
    Local : Field : Medium Prompt : Set as : $$LocaleString:”A/c no.”
    Local : Field : Name Field : Set as : $AccountNumber

    Local : Field : Default : Color : Blue

    [Line: LedIFSC]

    Fields : Medium Prompt, Name Field
    Local : Field : Medium Prompt : Set as : $$LocaleString:”IFSC”
    Local : Field : Name Field : Set as : $IFSCode

    Local : Field : Default : Color : Blue

    1. Hi,
      Exactly what you want to do? i am unable to understand it.

      Instead of writing code can you simply explain me exactly what you are trying to do?

      1. Sudhir Verma says:

        i want ledger’s bank details but nothing to show in my created fields.

        1. Sudhir Verma says:

          which is also in ledger’s master

      2. Sudhir Verma says:

        sir, please reply…..

        1. Sudhir,
          That Chapter is about to fetch the field value from the same ledger. It is not about fetching value from any other ledger or from anything else!
          That chapter is not about to retrieve the value from another ledger!
          One single solutions doesn’t work in every case! and every solutions you can’t learn from one single chapter.

          There are 1000 thing which no one can learn in one single chapter. that too just in starting of the course!

          You do a project, test it and your project should be related to that course chapter only! and then move to the next unit to understand it better and move to the next unit!

  20. jitendratallyagra says:

    [#Part:LED CONTACT]
    Add:Line: opening bal
    [Line:opening bal]
    Field:MEDIUM PROMPT,balance
    Local:Field:MEDIUM PROMPT :Set as:”ledger opening balance”
    [Field:balance]
    Use : Amount Field
    Storage : $OpeningBalance

    not work

  21. PRASHANTHA S says:

    [#Part: STKI Units]
    Add:Line:Mirror Line

    [Line: Mirror Line]
    Field: Short Prompt, Flash Unit Field,

    Local: Field: Short Prompt: Info: $$LocaleString:”Miror Units”
    Local: Field: Short Prompt: Color: Red

    [Field: Flash Unit Field]
    Use: Number Field
    Set as:#BaseUnits
    Set Always: Yes
    Skip: Yes

    ;; Master unit not Retrive in the Flash Unit Field

  22. Rakesh Nakade says:

    Screenshot Attached

  23. Rishi Kumar says:

    Dear sir,
    pls tell us how we get default Part or line definition for modifying and new field?
    in last project we have added Date of Birth in ledger master where[ part :led contact] you have already informed.
    like that please help us how we get right predefined part, line etc.

  24. dear sir
    I am Completed moudule 3, unit 5,
    1) I am Not able to open Tally in devoloper mode,
    2) I am trying to solve Question #3, but I am not able understand the questions.

  25. Amit Pandya says:

    Sir, I have a question…What should we do to set UDF Short Prompt Box at desired place? i.e. if I want to place UDF Box below Alias or beside Item Name…I wrote code guided by you, it shows retrieved value at bottom

    Also you shown in vid modifying Part area where as I started with modifier Form…as below: then how to know part should be modified or form? Warm Regards

    [#Form: Stock Item]
    Part: U

    [Part: U]
    Line: UNT

    [Line: UNT]

    Field: Short Prompt, UNTNM

    Local: Field: Short Prompt :Set as: “UNT Name”

    [Field: UNTNM] ;;Sir, here it showing at bottom…what if I want this exact below Alise or beside Item Name???

    Use: Symbol Field
    Set as: $BaseUnits
    Background : Yellow

  26. Hello sir,
    I am unable to find the field, name for coding please help me out here.
    regards.

    SHAM RAO

  27. Dear sir,

    I unable to find a field,
    in stock item master.

    please guide me to do it.

    Regards

    SHAM RAO

  28. Sir, I had completed assignment of this unit.

  29. ankitkiran says:

    Video is not playing

  30. ankitkiran says:

    I am not able to go to next section.

  31. seema kasliwal says:

    how we will know default part name

  32. RUPESH THAKUR says:

    Dear Sir,

    I am not able to find out default definition.
    Please help.

    Regards,
    Rupesh

  33. RUPESH THAKUR says:

    Dear Sir,

    Please check below codes and let me know what correction/improvement is required :

    [#Part: STKI Units]
    Add:Line:STKI Unit
    [Line: STKI Unit]

    Fields : Short Prompt, STKI Unit Field,Fld2
    Local : Field : Short Prompt : Info : $$LocaleString:”Units New”

    1. I think I had reviewed your online assignment and I didn’t noticed any issue.
      So, there is nothing wrong in your project. If still you feel for any issue then you can tell me about that.

  34. rana.tally says:

    How Can add field in item master ?

  35. sarthakinfotechsolutions says:

    I have write code as you shown
    but not working…
    what to do..

    and i also want to know process that you find the field storage name “opening balance ” and “opBalFld”

    1. Hi,
      You need to tell me what is not working. just by telling that something is not working, I can’t get the idea.
      Please share the screen shot of what output you are getting to my whatsApp.
      Also all these chapters are done by most of the students so there is no reason that it will not work only for you.
      When your code doesn’t work, you need to re check your code again and again and also you need to compare your codes with the chapter.
      To learn code, most important thing is not to learn code but to have a good reading and writing ability and comparing the codes.
      Only then you can solve issues.

      So, please check your codes 4-5 times, line by line, and code by code.
      All of us do mistakes while writing codes and that time a strong habit of reading and comparing our codes again and again can only help us to solve a problem.
      If you don’t develop such habit, then you can’t learn TDL or any other coding.
      and I am unable to understand what do you mean by finding the opBalFld and opening balance?
      There are chapters ahead through which you will learn how to find out the default definitions.
      opBalFld was a custom field developed by me so, you don’t have to find out that. Here I am really confusing why you need to find out that field!!

  36. KISHORE KUMAR B N says:

    Thank you Mahendra sir for quick replay and any time support, really great wonderful class

  37. BANOTH RAVI says:

    sir i am not able to doing this chapter-5 (Module 3) please help once.

  38. nitin meshram says:

    how to run tally in developer mode

  39. Prashant Agrawal says:

    Hello, I am getting the following error: https://ibb.co/JQTsQHd

    [#Part: STKI Basic]
    Add: Line: My Stock Unit
    [Line: My Stock Unit]
    Field: Medium Prompt, My STKI Unit
    Local: Field: Medium Prompt: Set as: “Stock Unit”
    [Field: My STKI Unit]
    Set as: $BaseUnits
    Use : Symbol Field

    Please help

    Thanks

    1. Prashant Agrawal says:

      Solved successfully!

      ;; [#Part: STKI Basic] ;; Displays ERROR
      ;; [#Part: MSTAliasMode] ;; Adds “Stock Unit” on both, Stock Item Master & Ledger Master
      [#Part: STKI Units]
      Add: Line: My Stock Unit
      [Line: My Stock Unit]
      Field: Short Prompt, My STKI Unit
      Local: Field: Short Prompt: Set as: “Stock Unit”
      Local: Field: Short Prompt: Width : @@ShortNameWidth
      [Field: My STKI Unit]
      Set as: $BaseUnits
      Use : Symbol Field

      Thanks

  40. CHANDAN GOYAL says:

    HELLO SIR

    HOW TO FIND THE DEFAULT DEFINITION OF A FIELD IN TALLY PRIME.?

    1. In Module 3, I think you do not need to find out the default defintions.
      Default defintions are containted in Module 4

  41. akash sharma says:

    Akash Sharma’
    Hello Sir, I have uploaded a file to my folder in dropbox named stock master field UDF kindly check and let me know if its correct, and if the code is correct.

  42. DHARMENDRA BARASARA says:

    quetion 2 [line:My Line ]
    field : Name Field, Mediam Promt , Jitni Bar Likenge Etni Field Banti He Buy Aapne Canfuse Kar Diya

  43. RANGANATHAN S says:

    Super Worth to join here for TDL course
    even if i taken online live video class also i cannot able to this much level by one day
    every unit is learning well
    i am shocked that i am done STKI Item project and learned
    thanks for that test
    first i struggle where i need to get the define name for Stock item after that i got idea we can select the field name based on that name i search the line name based on name i searched the part name and successfully done this test

    thanks for teaching very easily to all

    1. Thank you so much and I am really impressed to see you are learning with a passion and dedication. I saw you studying the course yesterday mid night.
      These types of dedications can never be deafeted.

Leave a Reply

Your email address will not be published.

error: Alert: Content is protected !!