Code to get amount inclusive of tax

Discussion in 'Free Source Codes' started by PRAPTI, Feb 22, 2020.

    
  1. PRAPTI

    PRAPTI Member


    What line should I write to get the amount inclusive of taxes ?
     


  2. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Set as : $InclusiveTaxValue
    it is there in LedgerEntries Object
     


  3. PRANAV

    PRANAV New Member


    Hello I tried the following line but its showing blank line
    Local : Field : Amount Field : Set as :$InclusiveTaxValue
     



  4. Try : $Rate + ($Rate*$GSTClsfnIGSTRateEx)100 you will get Rate inclusive tax
     


  5. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    First Enable it in F12, during voucher entry, It is always better to use builtin methods provided by tally, before we invent our own
     


  6. PRANAV

    PRANAV New Member


    It reports bad formula
     



  7. First Fetch or Compute $GSTClsfnIGSTRateEx in collection then try $Rate + ($Rate * ($GSTClsfnIGSTRateEx /100)).
    Also, confirm first using Set as : $GSTClsfnIGSTRateEx to view it fetched/computed.
     


  8. Atul Rathi

    Atul Rathi New Member


    [#Line:EI COLUMNONE]

    Add: Right Field: At Beginning:With Tax Amount

    Local: Field:With Tax Amount:Info:With Tax Amount

    [#Line:EI INVINFO]
    Add:Right Field:At Beginning:With Tax Amount

    [Field:With Tax Amount]

    Use:rate field
    Skip:Yes
    Color:RED
    Border: Sub Column Titles
    Invisible:NOT $$IsPurchase:$VOUCHERTYPENAME
    Use:amount forex field
    Set as :mad:@formu
    Set as : $GSTClsfnIGSTRateEx
    ;;[System:Formulae]
    ;;formu:$Rate + ($Rate * ($GSTClsfnIGSTRateEx /100))
    [Collection:$Rate + ($Rate * ($GSTClsfnIGSTRateEx /100))]
    Set as : $GSTClsfnIGSTRateEx



    This code is not working to display inclusive rate in purchase voucher. Please correct and revert back
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Delete last 2 lines.
    Delete line ---- Set as : $GSTClsfnIGSTRateEx
    Delete line --- Use:amount forex field

    Un-comment the System Formula and its formula.
     


  10. Atul Rathi

    Atul Rathi New Member


    [#Line:EI COLUMNONE]

    Add: Right Field: At Beginning:With Tax Amount

    Local: Field:With Tax Amount:Info:With Tax Amount

    [#Line:EI INVINFO]
    Add:Right Field:At Beginning:With Tax Amount

    [Field:With Tax Amount]

    Use:rate field
    Skip:Yes
    Color:RED
    Border: Sub Column Titles
    Invisible:NOT $$IsPurchase:$VOUCHERTYPENAME
    Set as :mad:@formu
    [System:Formulae]
    formu:$Rate + ($Rate * ($GSTClsfnIGSTRateEx /100))




    Thank you so much for your help! Above code is working
     
    panam likes this.


  11. Anil hassani

    Anil hassani New Member


    How to use please guide
     


Share This Page