QBE on numeric fields


Well Known Member
Hello -

Is there any way to query by example or query filter on a numeric field such as quantity on hand and select less than zero or greater than zero?

Thank you.

Yes, definitely. Standard applications such as P0411 - Voucher Entry allows QBE on columns like Gross Amount.

If you have a problem with this feature it would be best to provide all the details, especially the application involved. If the application is a custom application, you will need to provide further detail, including the properties of the grid and column involved and any event rules.
Zero value is not retained in the QBE column, it is due to the edit code associated under the display rule tab.