Can't really say without knowing more about how it's set up. Presumably you'll need to modify a calculation somewhere, but which calculation and what specific change depends on the specific design of your database.
You should have a calculation that reads something like: Taxable Amount * Salestax, this could be the entire expression or part of a more complex one. The names "Taxable Amount" and "Salestax" are names that I've made up, but in your database, the names could be entirely different...
You should add it to the Subtotal_Taxable calculation.
Thanks for the help.
I'm a complete newbie at this hence why I used the 'out of the box' set up.
When I go into manage database - Sales Tax - calculation this is what it states
Sum(Line Items::Taxable Amount) *Sales Taxe Rate + If(Discount Rate;0;0)
Does that shed any light on the set up?
(Sum(Line Items::Taxable Amount) + NAME OF SHIP field)*Sales Taxe Rate + If(Discount Rate;0;0)
add the ship field name to the calculation and that will include it.
Apologies for a not-so-slight digression, but it seems the question is already answered precisely by TKnTexas...
Since when are sales taxes applicable to shipping charges?
the concept got caught in my brain-filter...I had to ask...
While we're digressing - what exactly is this part for?
+ If(Discount Rate;0;0)
I did as you kindly suggested put in the field Shipping into the area of text supplied
so it now reads:
Sum(Line Items::Taxable Amount) + Shipping) +* Sales Tax + If(Discount Rate;0;0)
but I get an error message stating: an operator (eg+,-,*,) is expected here.
I don't have a subtotal_taxable section, do I create one,
if so how?
There should be a Left parenthese to start the calculation. You want to enclose the subtotal and the shipping so both are multiplied by the sales tax rate.
When I did this my amount applied to tax went from $4.32 to $432.00 so I am definately not doing something right.
I am definately not doing something right.
What is in your Tax Rate field? It looks like you are using a rate of 10,000%.
I'm using 5% for GST, there must be something elsewhere that is causing the issue.
Perhaps I have the calculation setup, if someone could show me the actual line of script I should write
that would be great.
It currently looks like thisin my Sales Tax Field:
Sum(Line items::Taxable Amount) *(Shipping + Tax Rate) + If Discount Rate;0;0)
Any help would be great, this is gruelling for a newbie!!
I don't know why you keep changing the formula you have been given. It should be:
( Sum ( Line items::Taxable Amount ) + Shipping ) * Tax Rate
I have copied exactly as you have stated but like before I keep getting an error box saying an operator is expected here!