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

[Michael H. <mh...@it...>]

Any accountant will say that rounding should ALWAYS be the last step.


Thanks,

Michael


On Sep 5, 2007, at 3:17 PM, Robert Stanford wrote:

> 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
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a  
> browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users