In System, the Reference No. field in transactions can be set as a Unique Field using the Customization Center.
For example, the Reference No. in Sales Order wherein it will be set that the system will detect if there is a duplicate Reference No.
To set it up, go to Tools > Customization Centre
In the User Difference, Select QNE Business Solutions so that the ruling will be applied to all users.
Under Model tab, QNE Business Solutions > Validation > Rules > Add > Rule Unique Value
Then follow the Set Ruling below;
Result Type: it should be set to Error for the system to prompt that it is an Error
TargetContextIDs: it should be set to Save so ruling will trigger upon Saving of the Transaction
TargetPropertyName: the field name in the transaction
TargetType: it specifies the type of the object for which the Validation Rule will be checked
CustomMessageTemplate: it specifies a custom informational text that is displayed in a validation error message for a broken Validation Rule
ID: it specifies the Validation Rule identifier
NOTE: CustomMessageTemplate and ID can be set differently
In transaction, there is already a saved Sales Order with a Reference No. of 12345.
Upon creating another Sales Order with the same Reference No. that already exists, system was able to prompt the Validation Error.