[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

*Subject*: Re: percentage discount not calculating properly*From*: Luke <..hidden..>*Date*: Wed, 24 Feb 2010 15:11:48 -0500 (EST)

On Wed, 24 Feb 2010, Chris Travers wrote:

This will affect the precision possible, not the method of calculating the discount.

Chris

First stage (inside a line item): maximum precision Second stage (line total): user specified - higher = more accuracy subtotal is based on second stage taxes, etc. are calculated on second stage Third stage (total): user specified - the end result receivable

I envision it something like this: [S1] itemprice (imaginary) * discount (imaginary) = 105.04017437 105.04017437 * quantity (5) = 525.20087185 [S2] 525.20087185 round to pre-subtotal precision (3): 525.201 No tax or other subtotal to total modifiers [S3] total rounded to total precision (2) = 525.20

That's what I'm angling for here. > As we revise the invoicing system I would like to be able to handle

"lot prices" but some additional thought needs to go into how that would work.

Add a quantity field to the price matrix, and sort on quantity descending? Luke

**Follow-Ups**:**Re: percentage discount not calculating properly***From:*Michael Richardson

**Re: percentage discount not calculating properly***From:*Chris Travers

**References**:**percentage discount not calculating properly***From:*Bob Miller

**Re: percentage discount not calculating properly***From:*Luke

**Re: percentage discount not calculating properly***From:*Chris Travers

**Re: percentage discount not calculating properly***From:*Bob Miller

**Re: percentage discount not calculating properly***From:*Chris Travers

- Prev by Date:
**Re: percentage discount not calculating properly** - Next by Date:
**Re: percentage discount not calculating properly** - Previous by thread:
**Re: percentage discount not calculating properly** - Next by thread:
**Re: percentage discount not calculating properly** - Index(es):