Calculating sales tax
I've been using an old version for billing, but my office assistant changed the sales tax calculation in "define fields". Also, MA has increased the sales tax so I need to change the calculation. Help?
Select File | Manage | Database | Fields.
Find the field that calculates your sales tax.
Double click it to open the Specify Calculation dialog for this calculation or to bring up the auto-enter options if it is a field that uses an auto-entered calculation.
Now you can edit your calculation.
That's a general discription of how to do this. To provide more details, I'd have to know more about your database and how it's set up.
"When I get back to the "total Due" line it reads ".06" "
It's possible that the field is formatted to show only two decimal places. Enter layout mode, click the field and use Format | number to check and see if this is the case.
"It just adds this amount to the sub total as opposed to making a calculation."
In otherwords you are getting Taxable Amount + 0.06 instead of Taxable Amount * 0.06 (or taxable amount * 1.06)?
It sounds like you need to look at the definition for the field that computes your sales tax and correct it. Find that field on your layout, enter layout mode and double click it. A dialog box will pop-up and the name of the field and its table will be shown on the right hand section of this dialog. The field name will be highlighted and the name of its table will be shown in the drop down menu just above the list of field. Now that you know the name of the field, go back to File | Manage | Database and check out it's definition.
Not really. If it were a lookup from the beginning, then you never would have had your issue. Records should always store what the rate was at the time that the record was generated. It should not be a calculation.
Retrieving data ...