Skip to main content
Skip table of contents

KI (All) - Stock Items - Weird search behaviour if using strings of numbers containing an E. ("31E2000")


When an Itemcode can be interpreted as a number, sometimes the stock search will behave erratically due to issues handling thes tring.



  1. Add an Extra Search Field for a Numeric column (EG: Avecost)

  2. Search for a value like "20"

  3. Search for a value like "31E20"

  4. Search for a value like "31E2000"

  5. Error return, invalid value "inf" when searching for the last one, as Delphi tracks the value as Infinite.


Check your extra search field definitions, and make sure you aren't searching against a numeric column.


Attached to Problem ticket EXB-6202 for resolution in a future release.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.