Report filters auto complete, even when you choose "Begins With"
The point of "begins with" or "contains" or "like" is to use substrings.
For example, on the inventory movement details report, Reference "begins with" "TR-" is the obvious way to select all Stock Transfers.
However, the filter builder always does autocomplete. You can not enter "TR-" if there is one or more transactions on the report. If you have a transaction TR-0001 then you can only do "begins with" TR-0001 which destroys the value of 'begins with'.
I reported this as a bug and was redirected to leave a feature request.
The work-around is to make sure there are no rows on the report by using a date with no transactions. Build the filter; it doesn't try to autocomplete now. Then choose the date range you want.
1 person likes this idea