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:
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)