1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

RoundOff Not Working

Discussion in 'Tally Developer' started by Binoy.M.E, Aug 26, 2019.

    
Tags:
  1. Binoy.M.E

    Binoy.M.E New Member


    I had added one column in Invoice for printing Ex showroom Price.The Customization is working fine.But Ex Showroom field not showing Round Off value.Please help.

    [Style: CNormal Bold Italic]
    Use: Normal Bold Italic
    Height: 11

    [#Part: EXPINV Totals]
    Add : Line:After : EXPINV Totals : DSP EXPINV InvInfo Amt


    [#Part: DSP EXPINV Totals]
    Add : Line:After : DSP EXPINV Totals : DSP EXPINV InvInfo Amt

    [Line: DSP EXPINV InvInfo Amt]
    Left Field : DSP EXPINV EXDTL
    Local: Field: EXPINV Desc : Set as: "Ex Showroom Price : "
    Local: Field: EXPINV TP : Set as: @@Rate
    Local: Field: EXPINV TP1 : Set as: @@Tax
    Local: Field: EXPINV TP2 : Set as: $$Round:mad:@TTax
    Border: Thin Box
    Local: Field: Default : Style: CNormal Bold Italic
    Space Bottom: 0.25
    Space Top: 0.25

    [Field: DSP EXPINV EXDTL]
    Field: EXPINV Desc,EXPINV TP,EXPINV TP1,EXPINV TP2

    [Field:EXPINV TP]
    Type : Number
    Align : Right
    Invisible: Yes

    [Field:EXPINV TP1]
    Use: EXPINV TP
    Invisible: Yes

    [Field:EXPINV TP2]
    Use: EXPINV TP
    Invisible: No

    [System: Formulae]
    Rate : $$CollectionField:$Rate:1:AllInventoryEntries
    Tax : ($$FilterAmtTotal:AllLedgerEntries:TaxEntries:$BasicRateOfInvoiceTax)+100
    TTax : (#EXPINVTP*#EXPINVTP1)/100

    [System :Formula]
    TaxEntries : Not $$IsEmpty:BasicRateOfInvoiceTax
     
    Binoy.M.E, Aug 26, 2019
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [System: Formulae]
    TTax : (#EXPINVTP*#EXPINVTP1)/100
    TTaxRound : $$Round:mad:@TTax:2

    ==================
    Local: Field: EXPINV TP2 : Set as: @@TTaxRound
     
    Amit Kamdar, Aug 26, 2019
    #2


  3. Binoy.M.E

    Binoy.M.E New Member


    Thanks for the reply. Round off is working.But showing some issues. I herewith added the screenshot for your reference.Here the rate is 138230.23 and the total Tax % is 29.After adding the tax the amount will be 178316.99.But the rounded value shown as 178316 only.Also need to display the Rupees Symbol.Please help me to resolve the issue.

    Invoice.jpg
     
    Binoy.M.E, Sep 17, 2019
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [System: Formulae]
TTax : (#EXPINVTP*#EXPINVTP1)/100
TTaxRound : $$StrByCharCode:8377 + $$Round::@@TTax:0

==================
Local: Field: EXPINV TP2 : Set as: $$String:@@TTaxRound
     
    Amit Kamdar, Sep 17, 2019
    #4


  5. RakeshGupta

    RakeshGupta New Member


    I wants to show rupees symbol in amount forex field how can do it
    my code bellow
    [Line : SPINV AmtTotal2]
    Field : /*NameField,*/Amount Forex Field
    Local : Field : Default : Style : Normal Bold
    Local : Field : NameField : Set as : "Total Amount"
    Local : Field : Amount Forex Field : Set as : $$StrByCharCode:8377;+$$Round:$Amount:1
    Local : Field : Amount Forex Field : Full Width: yes
    Local : Field : Amount Forex Field : Format : "No Zero, Symbol," + ##ShowForex
     
    RakeshGupta, Jun 19, 2020
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Local : Field : Amount Forex Field : Set as : $$StrByCharCode:8377 + $$Round:$Amount:1
     
    Amit Kamdar, Jun 20, 2020
    #6


Share This Page