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.