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

[Robert S. <ro...@st...>]

Jeff Roberts wrote:
> 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
>   
This has been a bit of a problem from a usability point of view.

SQL-Ledger rounds discounts before multiplying by qty. This causes no 
real problem when selling.

However the same thing happens when purchasing and here is where it 
causes problems.

Here's  where the problem arises, every supplier we have encountered 
rounds after multiplying by quantity, so when we it comes time for 
accounts to pay bills there if often a discrepancy between our purchase 
order and the suppliers invoice.

Dieters method of rounding first seems mathematically, however after a 
few years of encountering this I really think he should bite the bullet 
on this issue and round last, unfortunately this is one of those cases 
where 'everybody else is doing it'.

Kind Regards
Robert Stanford