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.