Problem Scenario:


In Chart of Accounts, System only accepts upper case for Account Name/Description.




We can allow lowercase by executing a script in SQL Server Management Studio.


1. In Windows search, find SQL Server Management Studio by typing “ssms” without the quotation marks and Open it.

2. Connect to server:


Server type: Database Engine

Server name: Computername\QNEBSS

Authentication: Windows Authentication


3. Create new query in SQL Server Management Studio

4. Select the database where you want to apply the script 

5. Copy and Paste script below:


INSERT INTO [dbo].[SystemData]

6. Then Execute [F5] the script and Message should be “Query executed successfully”.

The system should now accept both uppercase and lowercase for the Account Name/Description.