How To Enable Lower Case For Account Name Under Chart Of Accounts

Problem Scenario:

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

Resolution(s):

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]
([SystemDataCode],[SystemDataValue],[OptimisticLockField])
VALUES
('AllowLowerCaseInGLAccountDescription','True',null)
 GO

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.