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
Feedback sent
We appreciate your effort and will try to fix the article