Knowledgebase: Downloads > MFF Documents
How to prevent to enter lowercase for Account Code in JE or JI?
Posted by Syed Qutubuddin, Last modified by Syed Qutubuddin on 29 September 2013 10:56 AM
How to prevent to enter lowercase for Account Code in JE or JI?



Description:

When extract data from AA, the transaction did not appear if extract all unallocated transaction but it will appear if extract by Period only. The investigation found out that it is due to the Accound Code for the particular transaction is in lowercase.

Solution:

The control of upper or lower case is not with the Sunsystems Application but is control by the Microsoft SQL database. The issue arises when the database Collation Type is not on a recommended format. The recommended one is Latin1_General_Bin. If anything other than this selection then users should ensure that all the codes entered are upper case to avoid confusion. To resolve this issue, you will need to re-install the Microsoft SQL database with Binary Sort order.


(0 vote(s))
Helpful
Not helpful

Comments (1)
Walid SAMY FAHIM
08 April 2014 05:46 PM
in case it's happened already and the user already post the JV by lowercase characters, we may fix the lowercase entry by follow below steps

1- Take full Backup "fb -> b-> DB code"
2- Go to _back folder then Open Ledger file "LF" with notepad
3- search for the record by F3
4 change lowercase character
5- Restore "fb->r->DB code

Note :
1 . All user must be out during above steps
2. You may take backup of ledger file only in order to save time

Regards,
Walid SAMY
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).