disabled_sheuerman

Problem with a tax script...

Discussion created by disabled_sheuerman on May 23, 2013
Latest reply on May 29, 2013 by timwhisenant

I am trying to change a script that is for sales tax. I do not understand how it is calculating the information that it is. Our database is really old and I've just upgraded to FileMaker 12. I want to make it where the tax field will auto populate that if it is bought or shipped within the state of Texas it would charge sales Tax to not only the product but the shipping as that is what is required within the state of Texas. Can someone see what's wrong with my script? The first picture is of what is currently working but only pulling from the sold to. The second is where I changed it to include the ship to state. The third is the Tax Calculation, (Again that is currently working on Sold to only.) I want it to be from either the sold and ship to state. Please let me know if you have any questions. I'm really stumped on this. I'm an intermediate programer and trying to learn everything I can.

 

Thanks!

 

Sandi

Outcomes