1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Help in Below Code

Discussion in 'Free Source Codes' started by imranlhr, Jan 13, 2020.

    
  1. imranlhr

    imranlhr Member


    Amit Sir and Experts,

    I make new code for Cost Center Screen to add Qty and Rate. so, i need your help for input data in those fields.

    ;;UDF definition
    [System: UDF]
    MetalQtyUDF: Number: 1001
    MetalRateUDF: Number: 1002
    [#Line: VCHCSTCAT CstTitles]

    Add: Field:after:VCHNameTitle:MetalQty,MetalRate



    [Field : MetalQty]
    Set as : "Qty"
    Style : Small Bold


    [Field : MetalRate]
    Set as : "Rate"
    Style : Small Bold





    ;; End-of-file
     

    Attached Files:

    Last edited: Jan 13, 2020
    imranlhr, Jan 13, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have just made the code for adding the title...and itis working fine.

    Similarly, make a code for below part/line also, wherein you can input the data as desired.
     
    Amit Kamdar, Jan 14, 2020
    #2


  3. imranlhr

    imranlhr Member


    Thanks Sir, I am trying on this code. When i will made this will post.
     
    imranlhr, Jan 14, 2020
    #3


  4. imranlhr

    imranlhr Member


    Amit Sir, I made it after doing so many practice. so, please guide me how to show it in a report and in main voucher screen in Journal Voucher. i already attach screen shots
     

    Attached Files:

    Last edited: Jan 16, 2020
    imranlhr, Jan 16, 2020
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    same way you added in TITLE and in the ALLOCATION screen, in same manner you must add the field in whichever report you want..i.e. the voucher screen etc.

    You are doing good progress and efforts...so please continue working on that.
     
    Amit Kamdar, Jan 16, 2020
    #5


  6. Pritam Krishna

    Pritam Krishna Member


    If you open Tally in Developer Mode you can easily identify the Default Tally's Form / Part / Line Name
     
    Pritam Krishna, Jan 16, 2020
    #6


  7. imranlhr

    imranlhr Member


    Thanks alot Amit Sir and Pritam Sir. I am using Developer mode where i found all these codes. I am trying and practice too much and i hope with co-operation of all of you i can make this report soon.
     
    imranlhr, Jan 19, 2020
    #7
    Pritam Krishna likes this.


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes Imran...that is good spirit and attitude. Only by self doing it, one learns lots more in experience and skill.
     
    Amit Kamdar, Jan 19, 2020
    #8


  9. imranlhr

    imranlhr Member


    Thanks Amit Sir, I have changed few codes and learnt more about TDL. First i used codes without alignment now it improves and looks great. Sir, i m doing practice when i will finalize i will post in this site to view.
     

    Attached Files:

    imranlhr, Jan 21, 2020
    #9
    Amit Kamdar likes this.


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very Good....practice makes perfect.
     
    Amit Kamdar, Jan 21, 2020
    #10


  11. imranlhr

    imranlhr Member


    Thanks Amit Sir and Experts. Sir i need a clue how i can make Qty total in above screen.
     
    imranlhr, Jan 22, 2020
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Define the totals in the PART level..........
    then in the bottom part...add your field...in same manner as u added the title and data fields.
     
    Amit Kamdar, Jan 22, 2020
    #12
    Pritam Krishna likes this.


  13. imranlhr

    imranlhr Member


    Thanks Amit Sir, i am trying to do this. when it will be finished i will post it.
     
    imranlhr, Jan 25, 2020
    #13


  14. imranlhr

    imranlhr Member


    Amit Sir and Experts,

    Please help me to fix the total formula in this code. Amit Sir as per your instructions i define total in part level. please look into this and guide me how i can get the results
    [#Line: VCHCSTCAT CstTitles]

    Add : Left Fields : After:VCHNameTitle:MetalQty,MetalRate
    Local : Field : MetalQty : Info : "Qty"
    Local : Field : MetalRate : Info : "Rate"
    Local : Field : MetalQty : Style : Small Bold
    Local : Field : MetalRate : Style : Small Bold
    [#Line: VCHCST Line]

    Add : Left Fields : After : VCHCST Name : MetalQty,MetalRate


    [Field : MetalQty]
    Use : Number Field
    Type : Number : Forced
    Style : Simple
    Storage : MQty
    Set as : ""
    Width : 6
    Align : Center
    Format : "NoZero"


    [Field : MetalRate]
    Use : Number Field
    Type : Number : Forced
    Style : Simple
    Storage : MRate
    Set as : ""
    Width : 6
    Align : Center
    Format : "NoZero"


    [#Part: VCHCST Allocation]

    Add : Line : After : VCHCST Line : MetalQtyLine
    [Line : MetalQtyLine]
    Local : Field : QtyTotal : Bottom : Double Line


    [#Line: VCHCST Total]
    Add : Field : Before : VCHCST Total : QtyTotal


    [Field : QtyTotal]
    Border : Totals
    Use : MetalQty
    Set as : $$Total:MetalQty

    Align : Center








    [System : UDF]
    MQty : Number : 702
    MRate : Number : 701
     

    Attached Files:

    imranlhr, Jan 26, 2020
    #14


  15. imranlhr

    imranlhr Member


    Amit Sir,

    I have done this. i successful make a code in allocation screen only we have to make entry in cost center screen it auto comes in allocation screen. Thanks Sir for your support but sir, total of qty column is pending and i am working on above screen. so, guide me in total of qty.
     

    Attached Files:

    imranlhr, Jan 26, 2020
    #15
    Amit Kamdar likes this.


  16. imranlhr

    imranlhr Member


    Amit Sir and Experts,

    I improved my code now. it shows total in border but not auto calculated . sir, i need your help to make a formula to calculate it.
     

    Attached Files:

    imranlhr, Jan 27, 2020
    #16


Share This Page