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

Modified on Mon, Jun 6, 2022 at 2:09 PM

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.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article