Tax Rate rounding
  • January 1970 Edit

    Hello,

    I am new to Simple Invoices, and am having the following problem.

    Local tax rate is 8.625% and gets rounded to 8.63%, as it's not legal to charge at a different rate
    I modified the si_tax table field tax_percentage to decimal(11,3) from decimal(10,2) which seems to work.

    Am I creating more problems for my self, is there a better way to do this?

    P.S. keep up the great work.

    Thanks
    George

  • justinjustin September 2007

    Hey George

    thanks - didn't know there where tax rates with more than 2 decimal places

    theres no other way than what you did you get it working
    but.. all the invoices are formatted to round to 2 decimal places

    Question:
    1 - do you prices,total cost etc. need to be 3 decimal places or is rounded to 2 OK?
    2 - what country are you in?

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • GeorgeRGeorgeR September 2007

    Justin,

    Thanks for the quick reply.

    Cost is 2 decimal places.

    Country is USA, New York state, Suffolk county.

    Note that tax rates differ in NYS by County were sale takes place.

    Or if mail order then county of the purchaser.

    Thanks

    George

  • justinjustin September 2007

    Thanks George,

    i'll include a patch in svn to change the tax table to to (11,3)

    Cheers

    Justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • GeorgeRGeorgeR September 2007

    Justin,

    Thanks

    George

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories