Skip to Content
Former Member
Jun 10, 2008 at 10:07 AM

Problem with FormattedSearch


Hi All,

I had taken some userdefined fields(Units and Totals-->Quantity) in BOM and assign a formula to get the weight using formatted search.

The query is working fine upto 2 decimal result,if the result have more than 2 decimal places its not working.

I had checked in General settings,display there I had given 6 decimal places for Quantity and Measures(ALL).

If I run the query in Query Generator there also its taking upto 2 decimal places only.(SELECT 0.050.620.01/1000) this is the query I used , I need the full result.

The same thing is happening in all documents.

Pls let me know the result ..


Chakrapani Bandaru

Edited by: chakrapani bandaru on Jun 10, 2008 12:08 PM

Edited by: chakrapani bandaru on Jun 10, 2008 12:20 PM