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 twodecimal places:(eg [format .2f][price][/format]).If you want it to round up or down a certain way, then you'll need to useceil or floor with the [math] context. There's quite a few examples in thetalk archives about that.I don't know why your POS system calculates it to $3.40?Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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:
Do you have a formulas.db and/or a TaxRates.db?As for the rounding, your price diplaying is probably formatted to twodecimal places:(eg [format .2f][price][/format]).If you want it to round up or down a certain way, then you'll need to useceil or floor with the [math] context. There's quite a few examples in thetalk archives about that.I don't know why your POS system calculates it to $3.40?Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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:
Nav. 4 probs with cart (1997)
protect tag on NT IIS (1997)
WebCatalog for NT (1999)
Polls (2003)
[WebDNA] WebDNA AJAX_Fileuploader (2013)
File upload woes (1998)
Execute Applescript (1997)
RE: Web*SSL and WebCatalog (1997)
WebCatalog for guestbook ? (1997)
[WebDNA] Fwd: TCPConnect DATA= REQUEST_DENIED You must use an API key to (2019)
SSL (1998)
VBScript and WebDNA (2003)
ImageMagick on OSX (2003)
BannerAds example (1998)
Sendmail Excel attachment (2003)
Bad Cookie / Internet Option / Internet Explorer (2004)
Emailer (1997)
[WebDNA] No more SQL in 7.1? (2012)
We need advice (1996)
[addlineitems] (1997)