Re: [cart] Taxrate - seriously ..
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41458
interpreted = N
texte = The TaxTotal seems to be derived from the tax on each line item.When you add a line item you supply the sku of the product you want to add.I was using the products.db and the sku to do a lookup and find the tax rate.The lookup was in the formulas database.It appeared, that when we set a header, it would re-calculate all the individual tax amounts on each line but because we were setting a header and not adding a product, the sku wasn't available for the taxrate lookup to find the taxrate in the products database.When the carts taxtotal was added up from all the lines that were zero - it gave zero.Funky aye.It just means you can't have tax caculated based on the product you sell - which is no biggy I suppose.I think the one taxrate affects the whole cart anyway so we just Hard Coded It in the formulas database and it started working again.Yay hard coding!On 12/7/02 2:56 AM, John Peacock
wrote:> Andrew Simpson wrote: >> We fixed it. >> >> What we didn't realize was that webcat applies all the formulas to all the >> lineitems again if you modify the header. This means that the lookup in the >> formulas database that relied on the sku of the product didn't work because >> the sku wasn't there. >> > > WHOA! What do you mean webcat applies all the formulas to all the lineitems > again if you modify the header ??? This is _not_ true AFAIK. And what are > you > putting in the SKU field other than SKU? WebCat will recalculate all the > _derived_ fields if you change something in the header (like GrandTotal, > TaxableTotal, etc), but the lineitems are not touched again once added. > > It is a big deal that once you set a price based on formulas you cannot reset > that price or change the formulas (say for a volume discount) without deleting > and readding a lineitem. There is no [RecalcLineItems] context, though that > would be very useful. > > John-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
The TaxTotal seems to be derived from the tax on each line item.When you add a line item you supply the sku of the product you want to add.I was using the products.db and the sku to do a lookup and find the tax rate.The lookup was in the formulas database.It appeared, that when we set a header, it would re-calculate all the individual tax amounts on each line but because we were setting a header and not adding a product, the sku wasn't available for the taxrate lookup to find the taxrate in the products database.When the carts taxtotal was added up from all the lines that were zero - it gave zero.Funky aye.It just means you can't have tax caculated based on the product you sell - which is no biggy I suppose.I think the one taxrate affects the whole cart anyway so we just Hard Coded It in the formulas database and it started working again.Yay hard coding!On 12/7/02 2:56 AM, John Peacock wrote:> Andrew Simpson wrote: >> We fixed it. >> >> What we didn't realize was that webcat applies all the formulas to all the >> lineitems again if you modify the header. This means that the lookup in the >> formulas database that relied on the sku of the product didn't work because >> the sku wasn't there. >> > > WHOA! What do you mean webcat applies all the formulas to all the lineitems > again if you modify the header ??? This is _not_ true AFAIK. And what are > you > putting in the SKU field other than SKU? WebCat will recalculate all the > _derived_ fields if you change something in the header (like GrandTotal, > TaxableTotal, etc), but the lineitems are not touched again once added. > > It is a big deal that once you set a price based on formulas you cannot reset > that price or change the formulas (say for a volume discount) without deleting > and readding a lineitem. There is no [RecalcLineItems] context, though that > would be very useful. > > John-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- 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://search.smithmicro.com/
Andrew Simpson
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:
Encrypt File (2006)
Frames and WebCat (1997)
Signal Raised Error (Part III) (1997)
flushdatabases (1997)
&fieldsdir=ra truely random?? (2000)
Only charge card when product shipped ? (1997)
Relative URL quirk (1999)
Order not created error (1997)
File Upload (1997)
How does WebCatalog search the database? (1997)
Languages (1997)
project (1998)
Threaded Discussion (1998)
Demo math questions (2000)
Showif with an or (2003)
Various Problems (1997)
Using [showif] within [lineitems] [code fragment] (2000)
Help! WebCat2 bug (1997)
hm. (2002)
RE: Help name our technology! (1997)