1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

please guide me in below image i want to add that field in "Item Description" part

Discussion in 'Tally Developer' started by pramod5542, Aug 3, 2018.

    
Page 2 of 3
  1. pramod5542

    pramod5542 Member


    not a name of item part i want to "description" part
     
    pramod5542, Aug 6, 2018
    #26


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    then use table..........and make a list of all the descriptions..........
     
    Amit Kamdar, Aug 6, 2018
    #27


  3. pramod5542

    pramod5542 Member


    In this code where is add to table please tell me...and give some hint...

    [*Part: EI DescExplosion]
    Line : EI DescExplosion
    Line : EI SizeExplosionT,EI SizeExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    Total : JAP Desc
    Total : JAP Desc2

    [Line: EI SizeExplosionT]
    Fields : Desc Label0,Desc Label,Desc Label00,Desc Label1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [Line: EI SizeExplosion]
    Fields : Desc0,Desc,Desc00,Desc1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat



    [#Line: EI DescExplosion]
    Fields : EI Desc, JAP Desc Label,JAP Desc,JAP Desc1 Label, JAP Desc1,JAP Desc2 Label, JAP Desc2

    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [#Line: EXPINV InvDetails]
    Border: No Border

    [#Line: EXPSMP InvDetails]
    Border: No Border

    [#Line: EI DescExplosion]


    [#Field: EI Desc]
    Lines : 3
    Max : 1000
    Width : 22

    [#Field: STKI Desc]
    Lines : 3
    Max : 1000
    Fullwidth : yes

    [Field: Desc Label0]
    Use : Name Field
    Width : 16
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn

    [Field: Desc0]
    Use : Name Field
    Width : 16
    Style : Normal bold
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn

    [Field: Desc Label]
    Use : Name Field
    Width : 8
    Style : Normal
    Info : "Qty Total"
    Cells : @@ExcelItemColumn
    Color: Red

    [Field: Desc]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc
    Set as : $$Total:JAPDesc
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label00]
    Use : Name Field
    Width : 5
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc00]
    Use : Name Field
    Width : 5
    Style : Normal
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label1]
    Use : Name Field
    Width : 10
    Style : Normal
    Info : "Amt Total"
    Cells : @@ExcelItemColumn
    Color: Red
    Align : Center

    [Field: Desc1]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc1
    Set as : $$Total:JAPDesc2
    Cells : @@ExcelItemColumn
    Align : Center

    [Field : JAP Desc Label]
    Info: "Qty"
    Width: 2
    Align : Left


    [Field : JAP Desc]
    Use : Number Field
    Set As :#VCHBilledQty
    Storage : JAPDesc
    Set Always : Yes
    Width: 2
    Align : Left
    Style : Normal

    [Field : JAP Desc1 Label]
    Info: "Rate"
    Width: 2
    Align : Left


    [Field : JAP Desc1]
    Use : Number Field
    Set As : $Rate
    Storage : JAPDesc1
    Set Always : Yes
    Width: 3
    Align : Left
    Style : Normal

    [Field : JAP Desc2 Label]
    Info: "Amount"
    Width: 4
    Align : Left


    [Field : JAP Desc2]
    Use : Number Field
    Set As : #JAPDesc * #JAPDesc1
    Storage : JAPDesc2
    Set Always : Yes
    Style : Normal
    Align : Left


    [System : Udf]
    JAPDesc : Number : 1100

    [System : Udf]
    JAPDesc1 : Number : 1101

    [System : Udf]
    JAPDesc2 : Number : 1102
     
    pramod5542, Aug 6, 2018
    #28


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    At [#Field: EI Desc]
     
    Amit Kamdar, Aug 6, 2018
    #29


  5. pramod5542

    pramod5542 Member


    Good Morning Sir...i Create drop down list but its showing eror...please rectify it...

    [System : UDF ]
    Desc : String : 10001


    [#Part:LED Other Details]

    [Line:LED Other Details]
    Field : Short Prompt, LED Desc
    Local : Field : Short Prompt : Set as : "Description: "
    Local: Field: Short Prompt: Width: 20
    Local: Field: Short Prompt: Style: Normal Bold

    [#Field: EI Desc]
    Use : Name Field
    Storage : Desc
    Width:25
    Table : List of Description, Not Applicable
    Show Table : Always
    Trigger : New Name : $$IsSysNameEqual:NewName:$$EditData
    ;Key :Create New Name
    Dynamic :""
    Key:Desc


    [Key:Desc]
    Key:ALT + C
    Action:Alter:DescRep



    [Collection: List of Description]

    ;Object : Desc1, Desc2, Desc3, Desc4
    Format : $DescName, 20
    Title : "List of Description"
    Type : DescName : Company
    ChildOf : ##SVCurrentCompany
    Collection: Not Applicable
    ;[Object: Desc1]
    ;Name: Printing,Binding

    [Report : DescRep]
    Form : DescRep
    Object : Company

    [Form : DescRep]
    Part : Desc Part
    Width : 20% screen
    Height : 100% screen

    [Part : Desc Part]
    Line : Select Desc , Desc Line
    Repeat : Desc Line : DescName
    Break On : $$IsEmpty:$DescName or $$Line > 1000
    Scroll : Vertical

    [Line : Select Desc]
    Space Bottom : 0.5 cms
    Field : Name Field
    Local : Field : Name Field : Info : $$LocaleString:"List of Description"
    Local : Field : Name Field : Width : 25 cms
    Local : Field: Name Field : Color: Blue
    Local: Field: Name Field : Align: Centre
    Local: Field: Name Field : Border:thick bottom


    [Line : Desc Line]
    Field : Symbol Field , Desc Field1
    Local : Field : Symbol Field : Set as : $$Line
    Local : Field : Symbol Field : Skip : yes
    Local : Field : Symbol Field : Width : 2 cms
    Local : Field : Symbol Field : Indent : 0.2 cms
    Local : Field : Symbol Field : Color: Blue
    Local: Field: Symbol Field : Border: thin right


    [Field : Desc Field1]
    Use : Voucher Name Field
    Width : 23 Cms
    Storage : DescName
    Lines : 2
    Color : Blue

    [System : UDF]
    DescName : String : 50003 : yes




    [System: UDF]
    TND: String: 1103
    [#Part: EI BaseInfo]
    Option: EI TND:$$IsSales:##SVVoucherType


    [#Part: VCHTitle2Left]
    Add: Line: EI TND Line


    [Line: EI TND Line]
    Add: Field: EI TND Label
    Add: Field: EI TND Field


    [Field: EI TND Label]
    Info: "Kind Attention :"
    Width: 15
    Indent : $$InPrintMode

    [Field: EI TND Field]
    Use: Short Name Field
    Storage: TND
    Width: 20
    Indent : $$InPrintMode


    [*Part: EI DescExplosion]
    Line : EI DescExplosion
    Line : EI SizeExplosionT,EI SizeExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    Total : JAP Desc
    Total : JAP Desc2

    [Line: EI SizeExplosionT]
    Fields : Desc Label0,Desc Label,Desc Label00,Desc Label1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [Line: EI SizeExplosion]
    Fields : Desc0,Desc,Desc00,Desc1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat



    [#Line: EI DescExplosion]
    Fields : EI Desc, JAP Desc Label,JAP Desc,JAP Desc1 Label, JAP Desc1,JAP Desc2 Label, JAP Desc2

    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [#Line: EXPINV InvDetails]
    Border: No Border

    [#Line: EXPSMP InvDetails]
    Border: No Border

    [#Line: EI DescExplosion]


    [#Field: EI Desc]
    Lines : 3
    Max : 1000
    Width : 22


    [#Field: STKI Desc]
    Lines : 3
    Max : 1000
    Fullwidth : yes

    [Field: Desc Label0]
    Use : Name Field
    Width : 16
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn

    [Field: Desc0]
    Use : Name Field
    Width : 16
    Style : Normal bold
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn

    [Field: Desc Label]
    Use : Name Field
    Width : 8
    Style : Normal
    Info : "Qty Total"
    Cells : @@ExcelItemColumn
    Color: Red

    [Field: Desc]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc
    Set as : $$Total:JAPDesc
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label00]
    Use : Name Field
    Width : 5
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc00]
    Use : Name Field
    Width : 5
    Style : Normal
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label1]
    Use : Name Field
    Width : 10
    Style : Normal
    Info : "Amt Total"
    Cells : @@ExcelItemColumn
    Color: Red
    Align : Center

    [Field: Desc1]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc1
    Set as : $$Total:JAPDesc2
    Cells : @@ExcelItemColumn
    Align : Center

    [Field : JAP Desc Label]
    Info: "Qty"
    Width: 2
    Align : Left


    [Field : JAP Desc]
    Use : Number Field
    Set As :#VCHBilledQty
    Storage : JAPDesc
    Set Always : Yes
    Width: 2
    Align : Left
    Style : Normal

    [Field : JAP Desc1 Label]
    Info: "Rate"
    Width: 2
    Align : Left


    [Field : JAP Desc1]
    Use : Number Field
    Set As : $Rate
    Storage : JAPDesc1
    Set Always : Yes
    Width: 3
    Align : Left
    Style : Normal

    [Field : JAP Desc2 Label]
    Info: "Amount"
    Width: 4
    Align : Left


    [Field : JAP Desc2]
    Use : Number Field
    Set As : #JAPDesc * #JAPDesc1
    Storage : JAPDesc2
    Set Always : Yes
    Style : Normal
    Align : Left


    [System : Udf]
    JAPDesc : Number : 1100

    [System : Udf]
    JAPDesc1 : Number : 1101

    [System : Udf]
    JAPDesc2 : Number : 1102
     
    pramod5542, Aug 7, 2018
    #30


  6. pramod5542

    pramod5542 Member


    Untitled.jpg
     
    pramod5542, Aug 7, 2018
    #31


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Storage : Desc is both in Field:Desc0 and Field:Desc and Field:Desc00...hence clashing
     
    Amit Kamdar, Aug 7, 2018
    #32


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    Storage : Desc is both in Field:Desc0 and Field:Desc and Field:Desc00...hence clashing
     
    Amit Kamdar, Aug 7, 2018
    #33


  9. pramod5542

    pramod5542 Member


    what can i do for this eror
     
    pramod5542, Aug 7, 2018
    #34


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use different storage name
     
    Amit Kamdar, Aug 7, 2018
    #35


  11. pramod5542

    pramod5542 Member


    Sir i create new code but its not fetching data..i think its problem in collection..please modify it...
     

    Attached Files:

    pramod5542, Aug 7, 2018
    #36


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Field: EI Desc] is Tally System's field...so you cannot alter the storage name.

    The storage would be "BasicUserDescription" only.... changing this would entail you will have to change whole lot of code elsewhere, wherever "BasicUserDescription" is called upon.

    After[#Field: EI Desc]....make...
    [Table : List of District]
    Title : List of Districts
    List Name : "Nashik," "Dharmanagar "
    Format : $Name, 20
    Client Only : Yes
     
    Amit Kamdar, Aug 7, 2018
    #37


  13. pramod5542

    pramod5542 Member


    Sir in this code add this table below [#Field: EI Desc].

    [*Part: EI DescExplosion]
    Line : EI DescExplosion
    Line : EI SizeExplosionT,EI SizeExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    Total : JAP Desc
    Total : JAP Desc2

    [Line: EI SizeExplosionT]
    Fields : Desc Label0,Desc Label,Desc Label00,Desc Label1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [Line: EI SizeExplosion]
    Fields : Desc0,Desc,Desc00,Desc1,
    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat



    [#Line: EI DescExplosion]
    Fields : EI Desc, JAP Desc Label,JAP Desc,JAP Desc1 Label, JAP Desc1,JAP Desc2 Label, JAP Desc2

    Indent : If $$InPrintMode Then 6 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [#Line: EXPINV InvDetails]
    Border: No Border

    [#Line: EXPSMP InvDetails]
    Border: No Border

    [#Line: EI DescExplosion]


    [#Field: EI Desc]
    Lines : 3
    Max : 1000
    Width : 22

    [#Field: STKI Desc]
    Lines : 3
    Max : 1000
    Fullwidth : yes

    [Field: Desc Label0]
    Use : Name Field
    Width : 16
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn

    [Field: Desc0]
    Use : Name Field
    Width : 16
    Style : Normal bold
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn

    [Field: Desc Label]
    Use : Name Field
    Width : 8
    Style : Normal
    Info : "Qty Total"
    Cells : @@ExcelItemColumn
    Color: Red

    [Field: Desc]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc
    Set as : $$Total:JAPDesc
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label00]
    Use : Name Field
    Width : 5
    Style : Normal
    Info : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc00]
    Use : Name Field
    Width : 5
    Style : Normal
    Storage : Desc
    Set as : ""
    Cells : @@ExcelItemColumn
    Align : Center

    [Field: Desc Label1]
    Use : Name Field
    Width : 10
    Style : Normal
    Info : "Amt Total"
    Cells : @@ExcelItemColumn
    Color: Red
    Align : Center

    [Field: Desc1]
    Use : Number Field
    Width : 10
    Style : Normal
    Storage : Desc1
    Set as : $$Total:JAPDesc2
    Cells : @@ExcelItemColumn
    Align : Center

    [Field : JAP Desc Label]
    Info: "Qty"
    Width: 2
    Align : Left


    [Field : JAP Desc]
    Use : Number Field
    Set As :#VCHBilledQty
    Storage : JAPDesc
    Set Always : Yes
    Width: 2
    Align : Left
    Style : Normal

    [Field : JAP Desc1 Label]
    Info: "Rate"
    Width: 2
    Align : Left


    [Field : JAP Desc1]
    Use : Number Field
    Set As : $Rate
    Storage : JAPDesc1
    Set Always : Yes
    Width: 3
    Align : Left
    Style : Normal

    [Field : JAP Desc2 Label]
    Info: "Amount"
    Width: 4
    Align : Left


    [Field : JAP Desc2]
    Use : Number Field
    Set As : #JAPDesc * #JAPDesc1
    Storage : JAPDesc2
    Set Always : Yes
    Style : Normal
    Align : Left


    [System : Udf]
    JAPDesc : Number : 1100

    [System : Udf]
    JAPDesc1 : Number : 1101

    [System : Udf]
    JAPDesc2 : Number : 1102
     
    pramod5542, Aug 7, 2018
    #38


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    is your code changing minute by minute.... earlier u posted "ADD description" file.... wherein i advised you to add the TABLE....(code given)

    You want me to make changes for you??? or should you be the one doing it?
     
    Amit Kamdar, Aug 7, 2018
    #39


  15. pramod5542

    pramod5542 Member


    thank you sir...i do it...and one more thing when entry description field the "total qty" & "total amt" figure not showing...
    After entered and go back to sales voucher then its showing the value.......please help me when i entry "item description" the "total qty" & "total amt" value showing... Untitled.png
     

    Attached Files:

    pramod5542, Aug 7, 2018
    #40


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Put.......... Set Always : Yes in the respective 2 fields...........
     
    Amit Kamdar, Aug 7, 2018
    #41
    pramod5542 likes this.


  17. pramod5542

    pramod5542 Member


    I want to print in report....

    [System: UDF]
    TND: String: 1103
    [#Part: EI BaseInfo]
    Option: EI TND:$$IsSales:##SVVoucherType


    [#Part: VCHTitle2Left]
    Add: Line: EI TND Line


    [Line: EI TND Line]
    Add: Field: EI TND Label
    Add: Field: EI TND Field


    [Field: EI TND Label]
    Info: "Kind Attention :"
    Width: 15


    [Field: EI TND Field]
    Use: Short Name Field
    Storage: TND
    Width: 20
     
    pramod5542, Aug 7, 2018
    #42


  18. pramod5542

    pramod5542 Member


    i want to print "Kind Attention : Mr. x" below buyer details in report
     
    pramod5542, Aug 7, 2018
    #43


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your code is fine...see no problem with it..... unless you are/have referred to the wrong Line...i.e. [#Part: VCHTitle2Left] or maybe this Part might not be activated when you are printing it..... i.e. from F12 Print Configuration.
     
    Amit Kamdar, Aug 7, 2018
    #44


  20. pramod5542

    pramod5542 Member


    In print its not showing...how to print i.e. ("Kind Attention : Mr. x" ). Mr. x is my storage value.
     
    pramod5542, Aug 8, 2018
    #45


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    refer my previous post....same answer....

    either wrong reference or the specified field is not active.......the one after which you have specified your own fields.
     
    Amit Kamdar, Aug 8, 2018
    #46


  22. pramod5542

    pramod5542 Member


    Sir this part showing field in voucher ---- [#Part: VCHTitle2Left]
    suppose i deleted that its not showing in voucher.....how to active this part for print
     
    pramod5542, Aug 8, 2018
    #47


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    i dunno about print part....refer to TALLY's TDL for the field name..............
     
    Amit Kamdar, Aug 8, 2018
    #48


  24. pramod5542

    pramod5542 Member


    sir me not a developer.....just start learning.........give some example code
     
    pramod5542, Aug 8, 2018
    #49


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I am not a developer either......still learning...

    Also I do not have access to Tally developer as of now, since I am out of town....

    So best I can do is give you pointers.............
     
    Amit Kamdar, Aug 8, 2018
    #50
    pramod5542 likes this.


Page 2 of 3

Share This Page