Solution for adding more decimals to a ticket price

(Last Updated On: July 23, 2017)

A customer wrote in with the following question: “We have an outside rental that we are doing box office for.  They want the ticket price to be a flat .  We add sales tax at the end of the sale rather than including it in the actual ticket cost.  When I enter the ticket at .06 at the end of the sale it comes to .01.  If I change the ticket cost to .05, at the end of the sale it comes to .99.  I can’t get it to be exactly even.  We have the sales tax (8.55%) entered into the software in the payment types (under File), so I can’t adjust that because it affects every other show.  Our accountant suggested going out another hundreth of a cent, but the program does not allow you to add more than 2 figures at the end of the price.”

Change the number of decimals in the price from 2 to 3.

Navicat is the easiest way to make this kind of change. Right click on the shows table and select Design. Look for the price fields. You can change the fields as necessary. This is what it looks like:

navicat

This entry was posted in Uncategorized and tagged . Bookmark the permalink.