The Asset Category should accept only unique entries and be case-sensitive.

[deepdoshi79]

Information about bug

In Asset Category doctype It does not allow the creation of duplicate entries; however, it permits the creation of asset category if the case differs, such as uppercase, lowercase, or mixed capitalization, It should only allow unique entries in accordance with standardization.

For Example

I created Asset Category Equipment in Sentence case Uppercase and mixed capitalization.

Module

assets

Version

ERPNext: v15.34.0 (pre-prod)

Frappe Framework: v15.41.0 (pre-prod)

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response

[tinadn]

Findings on the issue: Postgresql case-sensitive which means, 'Equipment', 'EQUIPMENT', 'eQUIPMENT', 'equipment' are treated as 4 different values solution that may help: Use citext Data Type Create records using lowercase like (lower("project_name"));