Hey Everyone,

About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge the standard %12 sales tax with the rest of the order. Is there some way to stop this from happening?

In the invoicing element of the sales orders (field INVDTAAMT(3)), it looks like this:

But on the invoice crystal report itself (see here for an example), you can see that the 5.00$ is being included in the tax calculation and the customer is being charged extra.

It is currently calculating as:

• Subtotal + (Subtotal+Fuel Surcharge)*GST(5%) + (Subtotal+Fuel Surcharge)*PST(7%) + Fuel Surcharge (Total 20.68)
  • 13.47+((13.47+5)*0.05)+((13.47+5)*0.07)+5 = 20.68

It should be:

• Subtotal + (Subtotal*GST) + (Subtotal*PST) + Fuel Surcharge (Total 20.08)
  • 13.47+(13.47*0.05)+(13.47*0.07)+5 = 20.08

Is there any way to stop the invoicing element from being included in the tax calculation? I don't know where this is set up at all unfortunately, so please ask any relevant questions and I will do my best to answer so we can get to the bottom of this!

Zoey