Sales tax calculation is not correct

darshanmdarshanm Member Posts: 280
I have Navision 4.0(SP3 HF6) Indian localization DB .

When I calculate Sales Tax in with below parameters
it givies me wrong Tax % in Purchase Order line

Item Qty = 2 nos
Direct Unit cost = 1.90

Sales tax % set in sales tax setup = 4%

system calculates = 3.95

I have checked all the setups including all the rounding related
setups on General Ledger setup, But still it gives me 3.95% instead of
4%
Darshan Mungekar
Senior Consultan

Comments

  • ilayarajavilayarajav Member Posts: 19
    Dear Dharshan,

    This Problem already i have posted in mibuso. Diference between in Tax % is becuase of Navision back calculating tax percentage from Tax amount.
    In ur case,
    Qty = 2
    Unit cost = 1.9
    Total cost = 3.8
    Tax amount = 3.8 * 4/100 = 0.152 = 0.15 round off.

    if u back calculate Tax % = 0.15/3.8 = 3.95%

    So the problem with back calculation with rounding off function.

    U need to comment back calculation function.

    Regards,
    Ilayaraja. V
    Regards,
    Raja
  • ssinglassingla Member Posts: 2,973
    U need to comment back calculation function.

    I hope you have anticipated what all problems it might pose :mrgreen:
    CA Sandeep Singla
    http://ssdynamics.co.in
Sign In or Register to comment.