on 2023 Oct 13 2:50 AM
Dear Experts,
I have some items master data, created by copy paste from excel/PDF/word.
Upon query all of these items, found out it will not appear in the result. After further checking, found out that the issue is due to long dash which is part of the item code
ABC – 123 (not appear in the query result)
ABC - 123 (appear in the query result)
anyone has similar issue like this and is it possible to query the item, without recreating the item using the correct dash?
Request clarification before answering.
Hi,
The value in the database is correct. The problem is with the interface showing you the result of the query. It interprets both characters as being the same, or at least it shows them as being the same. It is probably best not to try and have two item codes which only difference is the length of the dash.
You can test by copying the returned value for example into MS Word, a program that usually does recognize the difference, and will show it.
You may encounter similar problems with characters like ñ, õ, å, ä, ö and the like. When creating item codes, it is best to avoid certain characters anyway, like space, #, /, \, ;, :, ", ', =, <, >, and ,
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
123 | |
8 | |
8 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.