openerp-expert-framework team mailing list archive

[Sharoon Thomas <sharoonthomas@xxxxxxxxxxxx>]

Hello All,

This has been an entertaining and informative conversation all over (Those guys out there who are not on twitter - you are missing a lot of it).

We have been talking all the while about accounting for which we have the database (normally) storing as decimal (numeric x,2), while we continue to use floats (double precision) data type for the stock moves. So with all the example given, something we could be sure of is that the stocks are truly messed up if you have unit other than PCE (like kgm, litres etc)

We have chances to check, verify the accounts/moves while I am not really sure if any organisation really checks the stock moves. It would be interesting to see the stock moves with the float case given by sisalp, because in stock we really see how 3 digits precision will be rounded to 2.

Please correct me if I am wrong.

Thanks,

Sharoon

On 19 Aug 2010, at 01:41, bounaberdi wrote:

> 
> hi
> Raphaël Valyi wrote:
>> 
>> I can read things like if 3rd decimal reaches 5 should
>> be rounded up, else down.
>> 
> This rule is often ignored by non accountants, as the previous discussion.
> (0.101 was the right answer)
> 
> Raphaël Valyi wrote:
>> However, nowhere I can see if a 10^⁻17 epsilon is
>> tolerated in the computation before we do that rounding (it's hard for me
>> to
>> believe it's not tolerable as it would make simple daily accounting pretty
>> challenging and that's why I ask for legal texts or specialists
>> interventions upon this).
>> 
> Reports must be "acurate", which means cents must be exact.
> In many audits, only cents are checked first because it is fast. If cents
> are not correct, then it's usually not needed to control any further. The
> report is rejected.
> There is no problem in daily accounting because all devices calculate in BCD
> for this reason. The first hand-held calculator since 70s, and any
> spreadsheet with the "finance" format does it. A cashier has to calculate in
> BCD.
> Accountants have never learnt one can calculate differently than in base
> ten, so you'll probably not find a law. Anyway, regarding French legals,
> there are more important reasons to be careful.
> 
> 
> -- 
> View this message in context: http://openerp-expert-framework.71550.n3.nabble.com/float-errors-propagating-to-10-2-in-OpenERP-v5-tp1175425p1217623.html
> Sent from the openerp-expert-framework mailing list archive at Nabble.com.
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-expert-framework
> Post to     : openerp-expert-framework@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-expert-framework
> More help   : https://help.launchpad.net/ListHelp