Yes, in such cases would be required theoretical accuracy of 8-9 digits.
There are no many companies that have the raw material stock in tonnes
and consume in milligrams. Maybe some medicine factory. But I think
there is a processing, sorting and allotments of raw material, which is
a preproduction phase, which may include conversion to an intermediate
unit of measurement (eg tonnes in kg)..
I think the effort should focus primarily on improvenet of functionality
and usabilitaty of mrp to cover more industries.
Best wishes,
Dumitru Gilcescu
Fil System

On Sat, 2010-03-27 at 11:20 +0000, Ana Juaristi Olalde wrote:

> As shown on Ferdinand links,
> 1 centigram = 1.0e-8 tonne
> 
> So we would need at less 8-9 accuracy for all kind UOM conversion. But maybe
> only going up to 6, would be enough? Yes, I think it needs discussion from
> other manufacturing experts to define it.
> 
> Lionel, thank you for your comment about my reputation :)
> 
> 2010/3/26 Ferdinand @ ChriCar <email address hidden>
> 
> > http://www.onlineconversion.com/
> >
> > I would expect that OpenERP should support (and ship?) "common" conversions
> > mentioned here
> > loadable as extra addons module ?
> > http://www.onlineconversion.com/weight_common.htm
> > http://www.onlineconversion.com/length_common.htm
> > http://www.onlineconversion.com/volume.htm
> >
> > --
> > unit factor is limited to 5 zeros
> > https://bugs.launchpad.net/bugs/511193
> > You received this bug notification because you are a direct subscriber
> > of the bug.
> >
> > Status in OpenObject Addons Modules: Confirmed
> >
> > Bug description:
> > I have got a category measure unit size.
> >
> > The master unit is meter, but I need having m2, m3 and related measure
> > units like mm, mm2, mm3, micrometer
> >
> > so 1m = 1000mm
> > but 1m = 1000000micrometer
> >
> > If I try including a conversion factor where I need more than 5 zeros,
> > system crashes showing this error:
> >
> > Environment Information :
> > System : Windows-XP-5.1.2600-SP3
> > OS Name : nt
> > Operating System Release : XP
> > Operating System Version : 5.1.2600
> > Operating System Architecture : 32bit
> > Operating System Locale : es_ES.cp1252
> > Python Version : 2.5.2
> > OpenERP-Client Version : 5.0.6
> > Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
> > call last):
> >  File "/home/xabier/openerp-server/server/bin/netsvc.py", line 244, in
> > dispatch
> >    result = LocalService(service_name)(method, *params)
> >  File "/home/xabier/openerp-server/server/bin/netsvc.py", line 73, in
> > __call__
> >    return getattr(self, method)(*params)
> >  File
> > "/home/xabier/openerp-server/server/bin/addons/base_module_record/base_module_record.py",
> > line 38, in execute
> >    res = super(recording_objects_proxy, self).execute(*args, **argv)
> >  File "/home/xabier/openerp-server/server/bin/service/web_services.py",
> > line 583, in execute
> >    res = service.execute(db, uid, object, method, *args)
> >  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 59, in
> > wrapper
> >    return f(self, dbname, *args, **kwargs)
> >  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 118, in
> > execute
> >    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
> >  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 110, in
> > execute_cr
> >    return getattr(object, method)(cr, uid, *args, **kw)
> >  File "/home/xabier/openerp-server/server/bin/osv/orm.py", line 2458, in
> > write
> >    'where id in ('+ids_str+')', upd1)
> >  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 76, in
> > wrapper
> >    return f(self, *args, **kwargs)
> >  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 120, in
> > execute
> >    res = self._obj.execute(query, params)
> > ProgrammingError: numeric field overflow
> > DETAIL:  A field with precision 12, scale 6 must round to an absolute value
> > less than 10^6.
> >
> > This is limiting the possibility of having all posible and needed
> > conversion factors on measure units, so I think it could be considered a bug
> > or maybe wishlist
> >
> > Thank you!!
> >
> > Ana
> >
> > To unsubscribe from this bug, go to:
> > https://bugs.launchpad.net/openobject-addons/+bug/511193/+subscribe
> >
> 
> 
> -- 
> Ana Juaristi Olalde
> Consultor Freelance OpenERP
> www.anajuaristi.com
> www.openerpsite.com
> www.avanzosc.com
> 677 93 42 59 - 943 85 06 25
> 
> -- 
> unit factor is limited to 5 zeros
> https://bugs.launchpad.net/bugs/511193
> You received this bug notification because you are a member of OpenERP
> Drivers, which is subscribed to OpenObject Addons.
> 
> Status in OpenObject Addons Modules: Confirmed
> 
> Bug description:
> I have got a category measure unit size.
> 
> The master unit is meter, but I need having m2, m3 and related measure units like mm, mm2, mm3, micrometer
> 
> so 1m = 1000mm
> but 1m = 1000000micrometer
> 
> If I try including a conversion factor where I need more than 5 zeros, system crashes showing this error:
> 
> Environment Information :
> System : Windows-XP-5.1.2600-SP3
> OS Name : nt
> Operating System Release : XP
> Operating System Version : 5.1.2600
> Operating System Architecture : 32bit
> Operating System Locale : es_ES.cp1252
> Python Version : 2.5.2
> OpenERP-Client Version : 5.0.6
> Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
>   File "/home/xabier/openerp-server/server/bin/netsvc.py", line 244, in dispatch
>     result = LocalService(service_name)(method, *params)
>   File "/home/xabier/openerp-server/server/bin/netsvc.py", line 73, in __call__
>     return getattr(self, method)(*params)
>   File "/home/xabier/openerp-server/server/bin/addons/base_module_record/base_module_record.py", line 38, in execute
>     res = super(recording_objects_proxy, self).execute(*args, **argv)
>   File "/home/xabier/openerp-server/server/bin/service/web_services.py", line 583, in execute
>     res = service.execute(db, uid, object, method, *args)
>   File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 59, in wrapper
>     return f(self, dbname, *args, **kwargs)
>   File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 118, in execute
>     res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
>   File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 110, in execute_cr
>     return getattr(object, method)(cr, uid, *args, **kw)
>   File "/home/xabier/openerp-server/server/bin/osv/orm.py", line 2458, in write
>     'where id in ('+ids_str+')', upd1)
>   File "/home/xabier/openerp-server/server/bin/sql_db.py", line 76, in wrapper
>     return f(self, *args, **kwargs)
>   File "/home/xabier/openerp-server/server/bin/sql_db.py", line 120, in execute
>     res = self._obj.execute(query, params)
> ProgrammingError: numeric field overflow
> DETAIL:  A field with precision 12, scale 6 must round to an absolute value less than 10^6.
>  
> This is limiting the possibility of having all posible and needed conversion factors on measure units, so I think it could be considered a bug or maybe wishlist
> 
> Thank you!!
> 
> Ana
> 
>