What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.

WebDNA

Software Corporation

Search WebDNA Site

HOME

DOWNLOADS

LEARN

EDUCATION

NEWS

COMMUNITY

STORE

SUPPORT

CONTACT

Re: Individual Tax on Items

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 22040
interpreted = N
texte = Thanx.. it does work this way.I only have one problem... I have to do this in 6 .tmpl files... there is 10 lines of code as i'm displaying:price (catalog.db price)salestax (catalog.db price)inctax (calculated)inctaxdealer (calculated)totaltax (calculated)totaltaxdealer (calculated)This also means that I have to use math variables... making the pages harder to administer.I tried to use a [inctax] formula in formula.db and it won't work. Webcatalog just returns [inctax]Why is formulas.db not returning my calculationsinctax[math]([lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=salestax]/100*[lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=price])+[lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=price][/math]Marko-------------------------------------------------------------------- Marko Bernyk mailto:marko@conexus.com.au Senior System Engineer http://www.conexus.com.au Technical Services Conexus Pty Ltd, Sydney, Australia :)--------------------------------------------------------------------John W wrote:>You might want to try something like this:>>Have the tax rate for each item stored in the database (example .0825)>On your invoice page, after you have displayed the contents of the>customers order and subtotal, but before you display the shipTotal,>TaxTotal, GrandTotal.: Using lineitems, go through the cart contents,>and calculate the individual tax cost for each item and replace the>items price with (price + tax). Also keep a running total of the total>tax to display for the Tax Total. >>Let me know if this makes sense.>>John>>>Marko Bernyk wrote:>> >> Has anyone come across the need to Have Tax on individual items?>> Webcatalog only uses an overall Tax percentage on all goods.>> >> Australia has different Tax on different Item types like Printers,>> modems, consumables.>> >> How do you go about calculation individual tax on you products under>> invoice.tmpl as well as giving a subtotal of tax on goods puchased?>> >> Marko>> >> -------------------------------------------------------------------->> Marko Bernyk mailto:marko@conexus.com.au>> Senior System Engineer http://www.conexus.com.au>> Technical Services>> Conexus Pty Ltd, Sydney, Australia :)>> -------------------------------------------------------------------->>>>>RFC822 header>----------------------------------->> RECEIVED: from SF_Database by POP_Mailbox_-1297782573 ; 22 DEC 98 15:18:43 UT> Received: from NS.smithmicro.com by mail.conexus.com.au> with SMTP (QuickMail Pro Server for MacOS 1.1.1r1); 22 DEC 98 15:18:37 UT> Received: from 207.67.226.146 (ns2.smithmicro.com [207.67.226.146])> by ns.smithmicro.com (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) >with SMTP> id UAA02461; Mon, 21 Dec 1998 20:16:33 -0800> Date: Mon, 21 Dec 1998 21:38:14 -0600> Message-Id: <367F1426.CAD41C5B@genesis-internet.com>> From: John W > Subject: Re: Individual Tax on Items> To: WebDNA-Talk@smithmicro.com> Mime-Version: 1.0> Content-Type: text/plain; charset=us-ascii> Content-Transfer-Encoding: 7bit> Precedence: Bulk> X-URL: http://www.smithmicro.com/> X-URL-Search: http://search.smithmicro.com/> Reply-To: WebDNA-Talk@smithmicro.com> Errors-To: WebDNA-Talk@smithmicro.com> Associated Messages, from the most recent to the oldest:

Re: Individual Tax on Items (PCS Technical Support 1998)
Re: Individual Tax on Items (Marko Bernyk 1998)
Re: Individual Tax on Items (John W 1998)
Individual Tax on Items (Marko Bernyk 1998)

Thanx.. it does work this way.I only have one problem... I have to do this in 6 .tmpl files... there is 10 lines of code as i'm displaying:price (catalog.db price)salestax (catalog.db price)inctax (calculated)inctaxdealer (calculated)totaltax (calculated)totaltaxdealer (calculated)This also means that I have to use math variables... making the pages harder to administer.I tried to use a [inctax] formula in formula.db and it won't work. Webcatalog just returns [inctax]Why is formulas.db not returning my calculationsinctax[math]([lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=salestax]/100*[lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=price])+[lookup db=catalog.db&lookInField=sku&value=[sku]&returnField=price][/math]Marko-------------------------------------------------------------------- Marko Bernyk mailto:marko@conexus.com.au Senior System Engineer http://www.conexus.com.au Technical Services Conexus Pty Ltd, Sydney, Australia :)--------------------------------------------------------------------John W wrote:>You might want to try something like this:>>Have the tax rate for each item stored in the database (example .0825)>On your invoice page, after you have displayed the contents of the>customers order and subtotal, but before you display the shipTotal,>TaxTotal, GrandTotal.: Using lineitems, go through the cart contents,>and calculate the individual tax cost for each item and replace the>items price with (price + tax). Also keep a running total of the total>tax to display for the Tax Total. >>Let me know if this makes sense.>>John>>>Marko Bernyk wrote:>> >> Has anyone come across the need to Have Tax on individual items?>> Webcatalog only uses an overall Tax percentage on all goods.>> >> Australia has different Tax on different Item types like Printers,>> modems, consumables.>> >> How do you go about calculation individual tax on you products under>> invoice.tmpl as well as giving a subtotal of tax on goods puchased?>> >> Marko>> >> -------------------------------------------------------------------->> Marko Bernyk mailto:marko@conexus.com.au>> Senior System Engineer http://www.conexus.com.au>> Technical Services>> Conexus Pty Ltd, Sydney, Australia :)>> -------------------------------------------------------------------->>>>>RFC822 header>----------------------------------->> RECEIVED: from SF_Database by POP_Mailbox_-1297782573 ; 22 DEC 98 15:18:43 UT> Received: from NS.smithmicro.com by mail.conexus.com.au> with SMTP (QuickMail Pro Server for MacOS 1.1.1r1); 22 DEC 98 15:18:37 UT> Received: from 207.67.226.146 (ns2.smithmicro.com [207.67.226.146])> by ns.smithmicro.com (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) >with SMTP> id UAA02461; Mon, 21 Dec 1998 20:16:33 -0800> Date: Mon, 21 Dec 1998 21:38:14 -0600> Message-Id: <367F1426.CAD41C5B@genesis-internet.com>> From: John W > Subject: Re: Individual Tax on Items> To: WebDNA-Talk@smithmicro.com> Mime-Version: 1.0> Content-Type: text/plain; charset=us-ascii> Content-Transfer-Encoding: 7bit> Precedence: Bulk> X-URL: http://www.smithmicro.com/> X-URL-Search: http://search.smithmicro.com/> Reply-To: WebDNA-Talk@smithmicro.com> Errors-To: WebDNA-Talk@smithmicro.com> Marko Bernyk

DOWNLOAD WEBDNA NOW!

Re: Individual Tax on Items

1998

Top Articles:

Related Readings: