RoundOff Not Working

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

         
  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
     


  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
     


  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
     


  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 
     


Share This Page