1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Decimal Portion of Rate in Sales Voucher

Discussion in 'Free Source Codes' started by Shabin Jacob, Nov 28, 2018.

    
Page 1 of 2
  1. Shabin Jacob

    Shabin Jacob New Member


    Dear Exports,

    Can we increase the decimal portion of Rate per unit in Sales Voucher without increasing the decimal portion of Other Fields like Amount Field.

    For example ; 10,210 printed labels sold @ 0.1257 (The Decimal portion of Amount Field required is only 2 digits), But that is Rate will be 4 digits..

    Stock Item Qty Rate Per Amount
    Printed Labels 10,210 0.1257 Label 1,283.40
     
    Shabin Jacob, Nov 28, 2018
    #1


  2. Jenny

    Jenny Active Member


    [#Field: VCH Rate]
    Format : Decimal : 2
     
    Jenny, Nov 29, 2018
    #2


  3. Shabin Jacob

    Shabin Jacob New Member


    Dear Ms. Jenny,

    I had tried this code earlier.. But it did not work as desired.

    If we set the decimal portion as 2 digits in company creation then the decimal portion of every filed will be 2 digits only. In other words if we increase the decimal portion to 4 digits as per the above code given by you, it will be rounded off to 2 decimals and the remaining 2 decimals will be zero. Please refer the attachments..
     

    Attached Files:

    Shabin Jacob, Nov 29, 2018
    #3


  4. Jenny

    Jenny Active Member


    [#Field: VCHBATCH Rate]
    Format : Decimal : 2
     
    Jenny, Nov 29, 2018
    #4


  5. Shabin Jacob

    Shabin Jacob New Member


    Same will happen...
     
    Shabin Jacob, Nov 29, 2018
    #5


  6. Jenny

    Jenny Active Member


    upload ur code and dummy tally data
     
    Jenny, Nov 29, 2018
    #6


  7. Shabin Jacob

    Shabin Jacob New Member


    Please find the attachments
     

    Attached Files:

    Shabin Jacob, Nov 29, 2018
    #7


  8. Jenny

    Jenny Active Member


    Its working....just see my screen shot 1.jpg
     
    Jenny, Nov 29, 2018
    #8


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    No you cannot.......... but it would be interesting if anyone can make a WORK-AROUND to this problem.

    I have a IDEA....if anyone wants to work hard on coding a 4 digit RATE field, without affecting the rest of the decimals..............
     
    Amit Kamdar, Nov 29, 2018
    #9


  10. Shabin Jacob

    Shabin Jacob New Member


    Dear Ms. Jenny,

    I want 4 Decimals in the rate field not 2 Decimals without affecting any other fields..

    Is it possible?
     
    Shabin Jacob, Nov 29, 2018
    #10


  11. Shabin Jacob

    Shabin Jacob New Member


    Dear Sir,

    How can we do that (4 Decimals in rate field)?
     
    Shabin Jacob, Nov 29, 2018
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Study Units of Measurement which has a facility for upto 4 decimals (Tally can only support 4 decimals).

    And implement it for your rate field.

    Also once you do this, ensure all RATE Fields WIDTH is also increased across all reports.

    BTW.... aren't you that person with a REMINDER problem for employee document expiry ??? Has it been resolved?
     
    Amit Kamdar, Nov 29, 2018
    #12
    panam likes this.


  13. Shabin Jacob

    Shabin Jacob New Member


    Will try this..

    The reminder coding has not been completed...

    It is fetching the data for reports like day book but not for employee profile.
     
    Shabin Jacob, Nov 29, 2018
    #13


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Keep trying.... don't abandon a project...........Did you made that code yourself or are you working on an existing one??
     
    Amit Kamdar, Nov 29, 2018
    #14
    panam likes this.


  15. Shabin Jacob

    Shabin Jacob New Member


    Working on new one
     
    Shabin Jacob, Nov 29, 2018
    #15


  16. Shabin Jacob

    Shabin Jacob New Member


    Done..

    Attached the Screen Short for more than 2 Decimal for Rate Field...
     

    Attached Files:

    Shabin Jacob, Nov 30, 2018
    #16
    Johar likes this.


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    good job...congrats....
     
    Amit Kamdar, Nov 30, 2018
    #17
    panam likes this.


  18. Sachin Garg

    Sachin Garg New Member


    How you did that? Can please tell me.
     
    Sachin Garg, Jul 5, 2020
    #18


  19. mharit1

    mharit1 Member



    Sir can you guide me?
    I have same query
     
    mharit1, Aug 10, 2020
    #19


  20. dhanapal

    dhanapal New Member


    How do you get decimal. Kindly give tdl code here or guide us
     
    dhanapal, Nov 6, 2020
    #20


  21. panam

    panam Member


    hint :change the decimal to 4.
     
    panam, Nov 6, 2020
    #21


  22. Gagan Jyoti

    Gagan Jyoti Member


    [​IMG] Why so, when we can enter the rate as 10, 100 1000 pcs also. Tally will auto calculate the value.
     
    Gagan Jyoti, Nov 8, 2020
    #22


  23. udaya

    udaya Active Member


    Dear Experts...
    i am trying if any value after decimal 2.00 should 2 but note working

    Ex:
    [Field:uk1]
    use: Number Field
    ....
    Format:"No Zero"

    but it show same as 2.00
    zeros are appear

    Please Solution...........
     
    udaya, Nov 8, 2020
    #23


  24. Himanshu-2002

    Himanshu-2002 Active Member


    Udaya Sir
    Try Like This

    [Field: Example]
    Use: Number Field
    Set as : ...
    Format: "Decimal:0"
     
    Himanshu-2002, Nov 8, 2020
    #24
    panam likes this.


  25. udaya

    udaya Active Member


    Himanshu Bro..

    if the amount is if Amount as 2.06 it will only take 2 only
    but i need if the Amt as 2.00 as 2 and 2.06 as 2.06

    any way to get it .... please let me know experts.
     
    udaya, Nov 8, 2020
    #25


Page 1 of 2

Share This Page