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 1 of 3
  1. pramod5542

    pramod5542 Member


    Untitled.jpg
     
    pramod5542, Aug 3, 2018
    #1


  2. pramod5542

    pramod5542 Member


    Untitled.jpg
    [*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

    [Field : JAP Desc Label]
    Info: "QTY"
    Width: 5

    [Field : JAP Desc]
    Use : Number Field
    Set As : $$Value
    Storage : JAPDesc
    Set Always : Yes

    [Field : JAP Desc1 Label]
    Info: "Rate"
    Width: 5

    [Field : JAP Desc1]
    Use : Number Field
    Set As : $$Value
    Storage : JAPDesc1
    Set Always : Yes
    [Field : JAP Desc2 Label]
    Info: "Amount"
    Width: 5

    [Field : JAP Desc2]
    Use : Number Field
    Set As : $$Value
    Storage : JAPDesc2
    Set Always : Yes

    [System : Udf]
    JAPDesc : Number : 1100

    [System : Udf]
    JAPDesc1 : Number : 1101

    [System : Udf]
    JAPDesc2 : Number : 1102
     
    pramod5542, Aug 3, 2018
    #2


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use #VCHBilledQty for Quantity
    Use $Rate for Rate

    Multiply --- #JAPDesc * #JAPDesc1
     
    Amit Kamdar, Aug 3, 2018
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    See screenshot below..........

    1Capture.PNG
     
    Amit Kamdar, Aug 3, 2018
    #4
    pramod5542 likes this.


  5. pramod5542

    pramod5542 Member


    View attachment 3875 [/QUOTE]
    Thank You sir...but its not storage the value...when save the voucher and reopen that voucher its showing zero zero value
     
    pramod5542, Aug 3, 2018
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    with me....it is storing................

    see screenshot........

    2Capture.PNG
     
    Amit Kamdar, Aug 3, 2018
    #6
    pramod5542 likes this.


  7. pramod5542

    pramod5542 Member


    its storage when voucher is open after save that voucher and reopen it then its not showing ...See the below image Untitled.jpg
     
    pramod5542, Aug 3, 2018
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Maybe because it is OPTIONAL Voucher......

    I tried with Sales Voucher and it is working as you can see from my screenshot............

    Or maybe you are using a different code than mine....or you might have changed something else............

    So you might have to solve it from your side.....happy hunting......
     
    Amit Kamdar, Aug 4, 2018
    #8


  9. pramod5542

    pramod5542 Member


    Good Morning Sir..i tried in sales voucher also but when save and reopen its its not save..please help me.
     
    pramod5542, Aug 4, 2018
    #9


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Pramod....If you want help then one should be truthful and upfront with all the details.... it seems you are not sharing the full code (which might be affecting and thus creating your problem).

    Since the same code works at my end...what more can I do?? ......So you really need to check at your end.
     
    Amit Kamdar, Aug 4, 2018
    #10


  11. pramod5542

    pramod5542 Member


    Sir my full code is below details :

    [#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


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



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


    [Field : JAP Desc]
    Use : Number Field
    Set As : $$Value
    Storage : JAPDesc
    Set Always : Yes
    Width: 3
    Align : Left


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


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


    [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
    Width: 5
    Align : Left


    [System : Udf]
    JAPDesc : Number : 1100

    [System : Udf]
    JAPDesc1 : Number : 1101

    [System : Udf]
    JAPDesc2 : Number : 1102
     
    pramod5542, Aug 4, 2018
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You must read very carefully on what solution I have given........

    you are still using $$Value in Fields --> JapDesc and JAPDesc1......please refer my post # 3 above....read carefully and modify it............
     
    Amit Kamdar, Aug 4, 2018
    #12
    pramod5542 likes this.


  13. pramod5542

    pramod5542 Member


    Thank You very much sir....its working...
     
    pramod5542, Aug 4, 2018
    #13


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very good....next time...be slow to read...absorb all things written........keep up....
     
    Amit Kamdar, Aug 4, 2018
    #14
    pramod5542 likes this.


  15. pramod5542

    pramod5542 Member


    sir can modify the name "Qty" to upper up to "Qty value" Untitled.jpg
     
    pramod5542, Aug 4, 2018
    #15


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    that is your choice....if you want it...do it....just repeat what you have done in your Quotation TDL file.
     
    Amit Kamdar, Aug 4, 2018
    #16


  17. pramod5542

    pramod5542 Member


    Sir in Qty value how to use the upper part to write"Qty"...give me some example
     
    pramod5542, Aug 4, 2018
    #17


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    you will have to re-write the FORM for additional description.........
     
    Amit Kamdar, Aug 4, 2018
    #18


  19. uttam100

    uttam100 Member


    Kindly share the final codr
     
    uttam100, Aug 4, 2018
    #19


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use this simplified Code...............

    Code:
    [#Line: EI DescExplosion]
    Fields         : EI Desc, JAP Desc
    Indent         : If $$InPrintMode Then 6 Else 2
    Option         : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

[Field : JAP Desc]
    Use         : Name Field
    Set As         : "Qty :"+$$String:$BilledQty+" X "+$$StrByCharCode:8377+$$String:$Rate+" = "+$$StrByCharCode:8377+$$String:$Amount+"/-"
    Storage     : JAPDesc
    Width         : 40
    Set Always     : Yes
    Invisible     : $$IsEmpty:$BasicUserDescription

[System : Udf]
    JAPDesc     : String : 1100
     
    Amit Kamdar, Aug 4, 2018
    #20
    pramod5542 likes this.


  21. pramod5542

    pramod5542 Member


    Sir any solution for that below code........ Untitled.jpg
     

    Attached Files:

    pramod5542, Aug 6, 2018
    #21


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please submit your dummy TALLY data also...so I can try out your code........

    Am travelling now....so will see your data n code in a few days............
     
    Amit Kamdar, Aug 6, 2018
    #22


  23. pramod5542

    pramod5542 Member


    Tally Data
     

    Attached Files:

    pramod5542, Aug 6, 2018
    #23


  24. pramod5542

    pramod5542 Member


    Sir in "item description" part its manually put. any method its showing drop down list like "Name of Item".
     
    pramod5542, Aug 6, 2018
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    FYI...it is already drop-down.....type a character and a list of items will appear............
     
    Amit Kamdar, Aug 6, 2018
    #25


Page 1 of 3

Share This Page