1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Rate Colm with 4 decimal

Discussion in 'Tally Developer' started by GEEKAYSYS, Mar 20, 2014.

    
  1. GEEKAYSYS

    GEEKAYSYS New Member


    [#Field: VCHBATCH Rate]
    Format : "Symbol,Forex,Decimal:4"

    I want to make Rate with forex 1.1111 or 1.2366

    In above both case the storage is showing only 1.1100 or 1.2400
    Thank you for your quick help.
    Kannan
     
    GEEKAYSYS, Mar 20, 2014
    #1


  2. ahmed rishali

    ahmed rishali Member


    I Think in company info you have to alter " Number of decimal places : 4

    Pleas check
     
    ahmed rishali, Apr 8, 2014
    #2


  3. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member





    He is right.

    I do not know Why. But it is working.
     
    JObimon Arackal JOhn, Apr 8, 2014
    #3


  4. GEEKAYSYS

    GEEKAYSYS New Member


    If I make the number of decimal place 4 then all my report showing 4 decimal place. But I wan to do only in Unit price
     
    GEEKAYSYS, Apr 23, 2014
    #4


  5. katyik mistry

    katyik mistry New Member


    Do This in company alteration decimal place will 4 and using TDL we can get only Rate in 4 decimal place

    [#Field : VCH Value]
    Add : Option : Decimal Place
    [#Field : VCHBATCH Value]
    Add : Option : Decimal Place
    [#Field : EI ValueTotal]
    Add : Option : Decimal Place
    [#Field : EXPINV Amount]
    Add : Option : Decimal Place
    [#Field : EXPINV ValueSubTotal]
    Add : Option : Decimal Place
    [#Field : EXPINV Total]
    Add : Option : Decimal Place
    [#Field : EXPINV AccAmount]
    Add : Option : Decimal Place
    [#Field : EXPINV TCSAmount]
    Add : Option : Decimal Place
    [#Field : EXPINV AccSRVTAmount]
    Add : Option : Decimal Place
    [#Field : ACLSAmt]
    Add : Option : Decimal Place
    [#Field : DSPDBDrAmt]
    Add : Option : Decimal Place
    [#Field: DSPDBExpAmt]
    Add : Option : Decimal Place

    [#Field: DSPDBCrAmt]
    Add : Option : Decimal Place
    [#Field : VCHBILL Amt]
    Add : Option : Decimal Place
    [#Field: DSP ClCrAmt]
    Add : Option : Decimal Place
    [#Field: DSP ClCrAmtA]
    Add : Option : Decimal Place
    [#Field: DSP OpAmtA]
    Add : Option : Decimal Place
    [#Field: DSP DrAmt]
    Add : Option : Decimal Place
    [#Field : DSP ClDrAmtA]
    Add : Option : Decimal Place
    [#Field: VCH CurBalance]
    Add : Option : Decimal Place
    [#Field: DSP DrAmtA]
    Add : Option : Decimal Place
    [#Field: DSP NettCrAmtA]
    Add : Option : Decimal Place
    [#Field: DSP CrAmtA]
    Add : Option : Decimal Place
    [#Field: DSP NettAmtA]
    Add : Option : Decimal Place
    [#Field: DSP ClAmtA]
    Add : Option : Decimal Place
    [#Field : VCH ItemValue]
    Add : Option : Decimal Place
    ;[#
    [!Field : Decimal Place]
    Delete : Format
    Add : Format : "Decimal:2"
    Add : Key : Calculator
    [!Field : Decimal Place Rate]
    Delete : Format
    Add : Format : "Decimal:2"
    Add : Key : Calculator
    [#Field: Amount Field]
    Add : Option : Decimal Place
    [#Field : Amount Forex Field]
    Add : Option : Decimal Place
    [#Field : Amount DBase Field]
    Add : Option : Decimal Place
    [#Field : Amount Base Field]
    Add : Option : Decimal Place
    [#Field : Amount DrCr Field]
    Add : Option : Decimal Place
    [#Field : EXPINV SubTot]
    Add : Option : Decimal Place
    [#Field : EXPINV Total]
    Add : Option : Decimal Place
    [#Field: EI ValueSubTotal]
    Add : Option : Decimal Place
    [#Field : EXPINV RateTotal]
    Add : Option : Decimal Place
    [#Field : EXPINV RateInclTitle]
    Add : Option : Decimal Place
    [#Field : EXPINV VATGCCTotalAmtTitle]
    Add : Option : Decimal Place
    [#Field: VCHBATCH Rate]
    Add : Option : Decimal Place : Not @@Isdecimalplace
    [#Field : VCH Rate]
    Add : Option : Decimal Place : Not @@Isdecimalplace

    [#Field: VCH GST DutyAmount]
    Add : Option : Decimal Place

    [#Field: VCH GST ItemValue]
    Add : Option : Decimal Place
    [#Field: Total Duty Value]
    Add : Option : Decimal Place
    ; Set as : $$RoundDown
    [#Line: GST As Per Transaction Amt]
    ; Local : Field : Total Duty Value : Delete : Set as
    add : Local : Field : Total Duty Value : Add : Set as : ##GSTTotalActualTaxAmount-$$AsAmount:0.050
    [#Field : VCH Vat DutyAmount]
    Add : Option : Decimal Place
    [#Field : VCH AccAlloc GSTAssessableValue]
     

    Attached Files:

    katyik mistry, Jun 16, 2021
    #5
    ASG likes this.


  6. katyik mistry

    katyik mistry New Member


    yes my concern is the same
     
    katyik mistry, Jul 19, 2021
    #6


  7. ASG

    ASG New Member


     
    ASG, Feb 24, 2022
    #7


  8. ASG

    ASG New Member


    MR. KATYIK MISTRY

    VERY GOOD. GRATE JOB DONE. IT IS WORKING FINE.

    THANKS A LOT.
     
    ASG, Feb 24, 2022
    #8


  9. ASG

    ASG New Member


    system formula @@isdecimalplace are not available and at last line [#Field : VCH AccAlloc GSTAssessableValue]
    are nor completed please mention that.
    Regards
    ASG.
     
    ASG, Feb 25, 2022
    #9


Share This Page