SalesCart Standard / PRO / SQL - taxes

Print Page | Close Window

taxes - too many digits

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=116
Printed Date: May/18/24 at 11:22am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com

Topic: taxes - too many digits

Posted By: jimgub
Subject: taxes - too many digits
Date Posted: June/04/04 at 6:47am

In reviewing a PO in the Order mgmt tool, the sales tax and Grand totals display more than 2 decimal point digits..

also, in one particular instance the shipping charge applied to an order with two items incorrectly charged for shipping for only one item (shipping based on quantity) and the grandtotal listed for the order was way off.. are these related problems (the wrong shipping charge being applied and the grand total being off...)?

thx
Jim

Replies:

Posted By: jimgub
Date Posted: June/04/04 at 7:15am

in reply to my own message, I have confirmed why the grand total appeared off (a whole order discount was applied to order, but we have no way of knowing that from report)... but the shipping charge applied was still wrong...

my question remains about too many digits..

thx again
Jim

Posted By: NJTackle
Date Posted: September/14/04 at 7:47pm

jimgub wrote:

In reviewing a PO in the Order mgmt tool, the sales tax and Grand totals display more than 2 decimal point digits.

I also have the same problem. Since I'll be using this as the customer receipt, I would be nice to have the tax and subtotal only show 2 decimal places.

There must be an easy fix!?!?!? :-)

EDIT: Looking over the code it seems the variables for tax and grand total are not converted to Currency before display. Sound right Will?

Posted By: Techno Geek
Date Posted: September/16/04 at 5:09pm

NJTackle wrote:

jimgub wrote:

In reviewing a PO in the Order mgmt tool, the sales tax and Grand totals display more than 2 decimal point digits.

That's correct. Please submit this a bug/feature request and we'll have it fixed.

The simple code fix for this is to change the code. It should look something like this:

<%=MyCurrency(Products1.Fields.Item("Price").Value)%>

-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support

Posted By: NJTackle
Date Posted: September/16/04 at 5:31pm

Actually, I think the code would be in the format simliar to:

<%=FormatCurrency(Products1.Fields.Item ("Price").Value)%>

Thanks Will!