List of Accounting can be import to SQL Accounting: Difference between revisions
No edit summary |
No edit summary |
||
(32 intermediate revisions by the same user not shown) | |||
Line 3: | Line 3: | ||
! Product !! File Type !! File/Table Name !! File Type Extention !! Master File 90% Accurate !! Opening Balance 70%-80% Accurate !! Current Transactions 70%~80% Accurate | ! 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 || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | | style='background: #f0fff0' | Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 || align="center" |Paradox || AutoCount Backup || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | ||
|- | |- | ||
| Autocount Enterprise 2005 || MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding | | style='background: #f0fff0' | Autocount Enterprise 2005 || align="center" |MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding | ||
|- | |- | ||
| UBS Accounting || Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | | style='background: #f0fff0' | UBS Accounting || align="center" |Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| UBS Stock || Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | | style='background: #f0fff0' | UBS Stock || align="center" |Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| QnE || Firebird || | | QnE || align="center" |Firebird || | ||
Creditor<br> | Creditor<br> | ||
CreditorArea<br> | |||
CreditorCategory<br> | |||
Currency<br> | |||
Debtor<br> | Debtor<br> | ||
DebtorArea<br> | |||
DebtorCategory<br> | |||
Stock<br> | Stock<br> | ||
StockCategory<br> | |||
StockGroup<br> | StockGroup<br> | ||
StockLocation<br> | |||
Term<br> | |||
|align="center" | | |align="center" | | ||
GDB<br> | GDB<br> | ||
QZB<br> | |||
QIB<br> | QIB<br> | ||
|| Y (Except GL Maintain Account) || align="center" | N || align="center" | N | || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| QnE (MSSQL) || MSSQL || | | QnE (MSSQL) || align="center" |MSSQL || | ||
MSSQL Backup<br> | MSSQL Backup<br> | ||
Debtors<br> | Debtors<br> | ||
Line 29: | Line 37: | ||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| Mr Accounting(MSSQL) || MSSQL || | | Mr Accounting(MSSQL) || align="center" |MSSQL || | ||
MSSQL Backup<br> | MSSQL Backup<br> | ||
Currency_Setting<br> | Currency_Setting<br> | ||
Line 37: | Line 45: | ||
SupplierDetail<br> | SupplierDetail<br> | ||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |||
| 3A Accounting (Windows) || align="center" |MS Access || | |||
Crdat.mdb<br> | |||
DbDat.mdb<br> | |||
Stdat.mdb | |||
| align="center" | MDB || Y (Except GL Maintain Account) || align="center" | N || 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_ACCxxxxx.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 || || | |||
AcStk.DB<br> | |||
AcCard.DB<br> | |||
(Use Office XP to Open) | |||
| align="center" | DB || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| Smart Accounting(MSSQL) || align="center" | MSSQL || | |||
MSSQL Backup<br> | |||
AcStk<br> | |||
AcCard<br> | |||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| AccSys Business Information System || align="center" | MSSQL || | |||
MSSQL Backup<br> | |||
Company<br> | |||
Product<br> | |||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| Million Business Software || align="center" | MSSQL || | |||
MSSQL Backup<br> | |||
Currency<br> | |||
Customer<br> | |||
Product<br> | |||
Prodgrp<br> | |||
Project<br> | |||
Supplier<br> | |||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| ICS Accounting || align="center" |MS Access || | |||
Cred6000<br> | |||
Debt6000<br> | |||
| align="center" | MDB || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| APlus || align="center" | DBase || | |||
agent.dbf<br> | |||
area.dbf<br> | |||
currency.dbf<br> | |||
customer.dbf<br> | |||
vendor.dbf<br> | |||
stock.dbf<br> | |||
| align="center" | DBF || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
|style='background: #f0fff0' | MYOB || align="center" | MYO || | |||
addr.csv<br> | |||
cards.csv<br> | |||
chacc.csv<br> | |||
items.csv<br> | |||
terms.csv<br> | |||
(CSV files generated using myData CLI tool) | |||
| align="center" | MYO || align="center" | Y || align="center" | N || align="center" | N | |||
|- | |||
| Master Accounting || align="center" | MSSQL || | |||
MSSQL Backup<br> | |||
Debtor<br> | |||
Creditor<br> | |||
Stock<br> | |||
StockGroup<br> | |||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| ESoft Accounting || align="center" | MYSQL || | |||
MySQL Backup in .sql & zip<br> | |||
xxxxx.apvend.sql<br> | |||
xxxxx.arcust.sql<br> | |||
| align="center" | sql || Y (Except GL Maintain Account & Stock) || align="center" | N || align="center" | N | |||
|- | |||
| iFAS Accounting || align="center" |MSSQL || | |||
MSSQL Backup<br> | |||
AP_VENDOR_MASTER<br> | |||
AR_CUSTOMER_MASTER<br> | |||
AREA_MASTER<br> | |||
CURR<br> | |||
INV_CATEGORY_MASTER<br> | |||
INV_GROUP<br> | |||
INV_ITEM_MASTER<br> | |||
INV_LOCATION_MASTER<br> | |||
| align="center" | BAK || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|- | |||
| Remicle || align="center" | PostgreSQL || | |||
Remicle PostgreSQL database dump backup in .sql & zip<br> | |||
product_product<vr> | |||
res_partner<br> | |||
| align="center" | sql || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | |||
|} | |} | ||
* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check. | |||
Highlighted with <span style='background: #f0fff0'>background</span> mean direct import to SQL Database else will export to Excel or CSV file | |||
==See also== | |||
*[[Data Import]] |
Latest revision as of 07:13, 22 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 |
Remicle | PostgreSQL |
Remicle PostgreSQL database dump backup in .sql & zip |
sql | 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