Re: [SL] wrong rebatte calculation in invoice/SO

[Jeff R. <je...@jr...>]

Hi Ashley

I think I understand now, You're manually putting in 7.5% discount on 
the line as you create the invoice right?  If that's the case it could 
be argued that it would be better to multiply the quantity by the price 
then apply the discount ( but the difference is in your favour :-) ) 
Maybe a future revision could move the brackets around in the equation 
to do that.

If you're assigning a discount to a vendor on an item then it's a 
different story because the item is 'pulled' from the tables with a 
price that is dependant on the date, pricegroup of the customer, and any 
exceptions or overides in the pricing matrix and there is no way to 
correct a rounding error once the query has run other than to start 
carrying four or five digits on every price just in case there is a high 
enough quantity sold to make a more than marginal difference.

Jeff


Ashley J Gittins wrote:
> On Tue, 4 Sep 2007, Jeff Roberts wrote:
>   
>> The item is discounted first, then rounded then multiplied by your
>> quantity. This allows you to discount one item while retaining other
>> items on the same invoice at full price If you applied the discount to
>> the sub total you'd lose the functionality of being able to discount
>> individual items.
>>     
>
> That is incorrect.
>
> There is nothing problematic with taking a line item, discounting it, 
> multiplying out for qty and _then_ rounding, that would have absolutely no 
> affect on other line items, and avoids that line item having a 
> rounding "error". 
>
> Additionally, it may be arguable that each invoice line should not be rounded 
> before total as well, but that's not what Robert is noting here.
>
> (btw, the math you expressed is exactly what I had said earlier - but I am 
> guessing you were replying to Robert more so than my post).
>
>