Hello all,
I would like to know if we can prevent de-duplication or inserting/saving of incorrect keywords. For instance there might be an item ID = LAPTOP, and any other employee would go ahead and create a same item but with incorrect keyword = LEPTOP. How can we prevent such scenarios in Acumatica?
Hii
Acumatica does not provide a built-in mechanism to automatically validate keywords against existing inventory IDs or detect spelling variations such as LAPTOP vs LEPTOP. Keywords are treated as free-text values, so the system will allow users to enter similar or misspelled entries.
To minimize duplicates and incorrect keywords, consider the following approaches:
If this is a frequent issue, a customization can be implemented to validate keywords during data entry. For example:
This can be implemented in a FieldVerifying or RowPersisting event, depending on whether you want to warn users or block the save entirely.
+13Hi
The most common approach is to control item creation through security roles and data governance processes, limiting who can create. For additional control, a Generic Inquiry can be implemented to identify or warn about potentially duplicate or misspelled items.
Best Regards,
NNT
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
