List of Accounting can be import to SQL Accounting: Difference between revisions
No edit summary |
No edit summary |
||
Line 53: | Line 53: | ||
|- | |- | ||
|style='background: #f0fff0' | Emas || align="center" |Foxpro || Emas Backup || align="center" | EMS || align="center" | Y* || align="center" | Y || align="center" | N | |style='background: #f0fff0' | Emas || align="center" |Foxpro || Emas Backup || align="center" | EMS || align="center" | Y* || align="center" | Y || align="center" | N | ||
|- | |||
| Emas(MYSQL) || align="center" |MYSQL || | |||
MySQL Backup in .sql & zip<br> | |||
YYYYMMDD_xxxxx.sql<br> | |||
apvend<br> | |||
arcust<br> | |||
currency<br> | |||
glarea<br> | |||
glagent<br> | |||
| align="center" | sql || Y (Except GL Maintain Account & Stock) || align="center" | N || align="center" | N | |||
|- | |- | ||
| Smart Accounting || || | | Smart Accounting || || |
Revision as of 01:48, 6 December 2023
Product | File Type | File/Table Name | File Type Extention | Master File 90% Accurate | Opening Balance 70%-80% Accurate | Current Transactions 70%~80% Accurate |
---|---|---|---|---|---|---|
Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 | Paradox | AutoCount Backup | B01 | Y | Y | Y (Except Sales & Purchase Outstanding Information) |
Autocount Enterprise 2005 | MSSQL | AutoCount Backup | A06 | Y | Y | Y (Except Sales & Purchase Outstanding |
UBS Accounting | Foxpro | UBS Backup | ACC | Y | Y | N |
UBS Stock | Foxpro | UBS Backup | STK | Y | Y | N |
QnE | Firebird |
Creditor |
GDB |
Y (Except GL Maintain Account) | N | N |
QnE (MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
Mr Accounting(MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
3A Accounting (Windows) | MS Access |
Crdat.mdb |
MDB | Y (Except GL Maintain Account) | N | N |
Emas | Foxpro | Emas Backup | EMS | Y* | Y | N |
Emas(MYSQL) | MYSQL |
MySQL Backup in .sql & zip |
sql | Y (Except GL Maintain Account & Stock) | N | N |
Smart Accounting |
AcStk.DB |
DB | Y (Except GL Maintain Account) | N | N | |
Smart Accounting(MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
AccSys Business Information System | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
Million Business Software | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
ICS Accounting | MS Access |
Cred6000 |
MDB | Y (Except GL Maintain Account) | N | N |
APlus | DBase |
agent.dbf |
DBF | Y (Except GL Maintain Account) | N | N |
MYOB | MYO |
addr.csv |
MYO | Y | N | N |
Master Accounting | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
ESoft Accounting | MYSQL |
MySQL Backup in .sql & zip |
sql | Y (Except GL Maintain Account & Stock) | N | N |
iFAS Accounting | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check.
Highlighted with background mean direct import to SQL Database else will export to Excel or CSV file