Re: Tax calculation problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50161
interpreted = N
texte = Do you have a formulas.db and/or a TaxRates.db?As for the rounding, your price diplaying is probably formatted to two decimal places: (eg [format .2f][price][/format]). If you want it to round up or down a certain way, then you'll need to use ceil or floor with the [math] context. There's quite a few examples in the talk archives about that.I don't know why your POS system calculates it to $3.40?Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Mark D. Laws > Reply-To: (WebDNA Talk) > Date: Thu, 8 May 2003 14:51:33 > To: (WebDNA Talk) > Subject: Tax calculation problem > > I'm having a problem with the way WebDNA rounds our tax calculations. > The POS system we enter our web orders into for fulfillment rounds up > at .005. WebDNA does not, so we have a lot of transaction that are > off by .01¢. > > Example: an item costs $46.00. Our tax rate here is 8.25% (.0825). > The underlying value is 3.795. WebDNA calculates the tax as $3.79, > our POS systems calculates it as $3.40. > > I see where the [taxtotal] is located on the invoice page, but I > don't see where the calculation is being made. I also can't find any > Round command in the documentation to make the calculation round up > at .005. > > Any help would be appreciated. > > Thanks. > -- > > > > Mark D. Laws > Information Systems and eCommerce Manager > Campus Computer Store, The Scholar's Workstation > University of California, Berkeley > 2200 University Hall, Rm 41 > Berkeley, CA 94720 > > voice: (510) 642-3135 > fax: (510) 643-6201 > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Tax calculation problem (John Peacock 2003)
  2. Re: Tax calculation problem (Tim Robinson 2003)
  3. Tax calculation problem (Mark D. Laws 2003)
Do you have a formulas.db and/or a TaxRates.db?As for the rounding, your price diplaying is probably formatted to two decimal places: (eg [format .2f][price][/format]). If you want it to round up or down a certain way, then you'll need to use ceil or floor with the [math] context. There's quite a few examples in the talk archives about that.I don't know why your POS system calculates it to $3.40?Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Mark D. Laws > Reply-To: (WebDNA Talk) > Date: Thu, 8 May 2003 14:51:33 > To: (WebDNA Talk) > Subject: Tax calculation problem > > I'm having a problem with the way WebDNA rounds our tax calculations. > The POS system we enter our web orders into for fulfillment rounds up > at .005. WebDNA does not, so we have a lot of transaction that are > off by .01¢. > > Example: an item costs $46.00. Our tax rate here is 8.25% (.0825). > The underlying value is 3.795. WebDNA calculates the tax as $3.79, > our POS systems calculates it as $3.40. > > I see where the [taxtotal] is located on the invoice page, but I > don't see where the calculation is being made. I also can't find any > Round command in the documentation to make the calculation round up > at .005. > > Any help would be appreciated. > > Thanks. > -- > > > > Mark D. Laws > Information Systems and eCommerce Manager > Campus Computer Store, The Scholar's Workstation > University of California, Berkeley > 2200 University Hall, Rm 41 > Berkeley, CA 94720 > > voice: (510) 642-3135 > fax: (510) 643-6201 > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Tim Robinson

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

SKU (1997) Problems with [Search] param - Mac Plugin b15 (1997) email database file (2005) # of real domains on 1 web server (1997) Cookies (1999) Multiple prices (1997) selectively replacing records within a [founditems] (2000) Searching Dates (2000) system crashes, event log (1997) [click][/click] (1999) RAM variables (1997) RE: [WebDNA] Suddenly, lots of WebDNA problems with FastCGI (2013) 4.5 -> 6.0 Upgrade (2005) Formulas.db / Quantity Discount problem (1998) Trouble with Netscape (1998) Popup Menu Options (1998) referrer usage (1997) where to put code (1998) AAgghh!! Help, please. SSL strikes again. (1997) SSL data to/from webcatalog? (2000)