Project

General

Profile

Actions

Task #19407

closed

MCL - Prevent Duplicate Client Identifiers (TAN, BRN, VAT)

Added by Redmine Admin 7 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
02/06/2026
Due date:
02/06/2026
% Done:

100%

Estimated time:
7:00 h
Spent time:
GitLab ID:
3809
GitLab Milestone:
GitLab Ticket Number:
1202
GitLab Time Logged:
10800
Lock Timeline Date:
No
gitlab project trace:

Description

The system should enforce validation rules depending on whether the client is an individual or a company, ensuring the uniqueness of identification numbers during both client creation and client updates.

Acceptance Criteria

Scenario 1: Individual & Local Client – TAN Validation

Given the client type selected is Individual & Local
When the user enters a TAN during client creation or update
Then the system must validate that the TAN is unique
And prevent saving the client if the TAN already exists
And display an appropriate validation error message.

Scenario 2: Company Client & Local– BRN & VAT Validation

Given the client type selected is Company
When the user enters a BRN and/or VAT number during client creation or update
Then the system must validate that both BRN and VAT are unique
And prevent saving the client if either BRN or VAT already exists
And display an appropriate validation error message indicating which value is duplicated.

Scenario 3: Update Existing Client

Given an existing client is being updated
When the identification values (TAN, BRN, or VAT) are changed
Then the system must re-validate uniqueness against all other clients
And allow saving only if no duplicates are found.

Validation messages must be clear and user-friendly

  • Example:
    • “A client with this TAN already exists.”
    • “A client with this BRN/VAT already exists.”

GitLab Sync Log

[{"id": "39451", "author": "Avisham", "hours": 3.0, "created": "2026-02-27T09:31:26.694Z", "log_date": "2026-02-26", "comment": "Imported from GitLab by @Avisham on 2026-02-27T09:31:26.694Z: 3h-(3.0)h spend at: 2026-02-26", "status": "active", "deleted_by": "", "redmine_entry_id": 12446}]

Actions #1

Updated by Redmine Admin 7 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 6 months ago

  • Description updated (diff)
Actions #3

Updated by Redmine Admin 6 months ago

  • Status changed from New to Development Done
  • % Done changed from 0 to 42
  • Estimated time changed from 0:00 h to 7:00 h
  • GitLab Time Logged changed from 0 to 10800
Actions #4

Updated by Redmine Admin 6 months ago

  • GitLab Sync Log updated (diff)
Actions #5

Updated by Redmine Admin 6 months ago

  • Status changed from Development Done to QA
Actions #6

Updated by Redmine Admin 6 months ago

  • Status changed from QA to New
Actions #7

Updated by Redmine Admin 6 months ago

  • Status changed from New to QA
Actions #8

Updated by Redmine Admin 6 months ago

  • Status changed from QA to Closed
  • % Done changed from 42 to 100
Actions

Also available in: Atom PDF