The importance of date, number and currency standards
In corporate ERP systems, invoices, orders, collections and journal entries are entered from dozens of different computers. Regional setting mismatches between client computers and the database server; It may lead to incorrect perception of dates as day and month (such as 05.01 instead of 01.05), shifts in invoice amounts by pennies and thousands (such as perceiving 150000 TL instead of 1.500,00 TL) and incorrect exchange rate calculations.
Such data inconsistencies corrupt all corporate data, from tax returns to inventory costs. For this reason, Windows Region and Language (Locale) settings on ERP users' computers should be configured to a single corporate standard.
Critical region settings and possible error table
The following table shows the most common regional setting problems in ERP and accounting programs and their solutions:
| Setting Parameter | Turkish Standard Value | Incorrect Setting Result | Solution and Configuration |
|---|---|---|---|
| Decimal | Comma ( , ) | 100x digit error in invoice amounts | Additional Settings -> Numbers -> Decimal symbol = ',' |
| Digit Grouping | Dot ( . ) | Numbers are detected as text and cannot be summed | Additional Settings -> Numbers -> Digit symbol = '.' |
| Short Date Format | dd.mm.yyyy (dd.MM.yyyy) | Day/month confusion in due and invoice dates | Region -> Formats -> Short date = 'dd.mm.yyyy' |
| System Locale | Turkish (Turkey) | In software, the letters 'İ/ı', 'Ş/ş', 'Ğ/ğ' are replaced by '?' exit | Administrative -> Set system locale to 'Turkish' |
| SQL Server Collation | Turkish_CI_AS | Searching and querying Major I / Minor incompatibilities | Turkish Collation should be selected when creating the database |
Configuring Windows Region and Language settings step by step
To verify the settings on ERP client terminals, follow the steps below:
1. Open the Control Panel -> 'Region' window.
2. Make sure to select the 'Turkish (Türkiye)' option in the 'Format' drop-down box.
3. Click the 'Additional Settings' button; In the Numbers tab, confirm that the Decimal symbol is a comma (,) and the digit grouping symbol is a dot (.).
4. In the Date tab, ensure that the Short Date format is 'dd.mm.yyyy'.
5. Switch to the 'Administrative' tab at the top. Press the 'Change system locale' button in the 'Language of non-Unicode programs' section. Select 'Turkish (Türkiye)' from the drop-down list. Make sure the 'Beta: Use UTF-8 for worldwide language support' box is UNCHECK and restart the computer.
SQL Server collation and network time synchronization
In addition to the client settings, the collation setting of the database server is also of great importance. The letters 'I-ı' and 'I-i' in the Turkish alphabet are different from the English language logic. When 'Turkish_CI_AS' (Case Insensitive, Accent Sensitive) collation is not used on SQL Server; When the user searches for 'ISTANBUL', the 'Istanbul' record may not be listed.
In addition, the time and date synchronization of the ERP server and all user computers should be automatically synchronized via NTP (Network Time Protocol); Otherwise, there will be inconsistency in the second invoice and e-delivery note timestamps.
Bu içerik genel bilgilendirme amaçlıdır. Mevzuat ve teknik sürüm bilgileri uygulama öncesinde resmi, güncel kaynaklardan doğrulanmalıdır.