Re: Term Discounts

Dale E. Reed Jr. ( (no email) )
Thu, 06 Mar 1997 13:04:59 -0800

Scott Burch wrote:
> I remember a discussion about the term discounts some time ago
> relating to the percentages being rounded. Would it be possible to
> provide an AMOUNT as well as a PERCENTAGE that can be applied. We drop
> our price from $25.00 a month to $19.95 a month if some pays 6 months
> in advance. This comes out to 20.02% which Emerald doesn't like and
> rounds it to 21%.

You can modify the database to store up to 4 digits, but really
only three are relevant, if are only using 2 digits. :)
Use Eneterprice Manager to:

A) Rename your Discounts "Percent" Field, to "PercentOld" and
save the changes.

B) Add a field called Percent, Type Real, Default 100 and save.

C) Execute the query:

Update Discounts Set Percent=PercentOld

Then you should be able to add percentages.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |