Hi There,
This is a very unusual issue and only happens as a result of inconsistent data, it would suggest that one of the following things has happened in your system historically:
- Item Unit of Measure records where imported via config packages or similar imports without the corresponding Item itself.
- Item itself was deleted in an unconventional way, leaving orphaned relating records like the Item Unit of Measure behind, causing issues when the same item no is created again, hence the error.
The error occurs because when an Item is created, a related Item Unit Of Measure record is also created automatically, and because there is already one (orphaned record), which the system does not expect to exist, the Item creation errors.
In short, your system contains orphaned data it would seem, there is no way to remove them easily from the front-end without the Item existing which is the primary issue.
You have 2 possible ways of correcting this issue:
- If you or a super use are familiar with config packages, you can delete the orphaned Item Unit Of Measure records for the item(s) you are trying to create, this is a difficult procedure as you would have to identify all the orphaned Item Unit Of Measure entries first before you can remove them, this process is also very risky if you apply the incorrect filters when deleting records. (Always take a backup of the data first so you can put it back the way it was in case something goes wrong)
Alternatively (Recommended):
- Get a developer to write a report that will check all Item Unit Of Measure entries against relating Items, if an Item is not found, remove the Item Unit Of Measure entry as it is then classified as orphaned - this is the recommended solution, the report will remove all Item Unit Of Measure records that does not have a corresponding Item, fixing all the issues in one go permanently.
Hope this helps.
