We have a custom field column on our sales invoices where we enter the shipping document number.
We just realized that if we copy/paste the number then occasionally there is an extra blank space at the end of the number… and that is causing issues for us… Now we have manually gone through each and every number and removed this blank space but I wanted to request @lubos to add a trimming function on the entered data which removes all blank spaces from the beginning and the end of the entered data.
The issue we face is that there will be two shipping numbers in the custom report (which displayes the summary of each invoice for each delivery number) when we have for example “AWB12345” and "AWB12345 " (notice the blank space at the end). When we click the invoices in the list created in the custom report that have the blank space at the end, Manager takes us to the invoices that has no blank space at the end… This means we have no chance to actually click on the invoices that have this blank space in the end…
I assume this affects all custom reporting so I recommend to add trimming to entered values for all custom fields…