Some user preferred to use lower case letter in Chart Of Account but QNE Optimum default setting was Upper case letter only.

2. Tick checkbox “Allow Lower Case in the Description of Accounts”

3. Save and Close

4. Re-open Chart of Account

5. Now you can key in Lower Case letter in Chart Of Account

 6. If you are using an older version of QNE Optimum, checkbox “Allow Lower Case in the Description of Accounts” might not available yet

7. You can choose to upgrade to higher version or use below method to allow lower case letter in Chart Of Account

8. Go to Tools > Database Utility > Select Database Utility

9. Click Connect button and key in your connection string then click OK button

11. Select “Data” > Click “New Query”

12. Copy and paste below query in to the “Query” box

INSERT INTO [dbo].[SystemData]

([SystemDataCode],[SystemDataValue],[OptimisticLockField])

VALUES

('AllowLowerCaseInGLAccountDescription','True',null)

14. If the “Result” show “Command has been executed successfully”, close “Support” and “Database Utility”

15. Re-open Chart of Account

16. Now you can key in Lower Case letter in Chart Of Account

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software