| Line 29: | Line 29: | ||
===Import Account Master Data=== | ===Import Account Master Data=== | ||
<ol> | <ol> | ||
<li>Create New Database then Log On New Company with ADMIN User.</li> | <li>Create New Database then Log On <b>New Company with ADMIN User.</b></li> | ||
[[File:2016-09-22 1505.png]] | [[File:2016-09-22 1505.png]] | ||
<li>Once Log On, Go to <b>File | Data Import |Select MYOB.</b></li> | |||
[[File:2016-09-22 1509.png]] | |||
<li>Click on the <b>"Download button"</b> to download a compulsory tool before import MYOB, then place the 'myData CLI' to C:\Users\SQL\Desktop\MYOB.</li> | |||
[[File:2016-09-22 1513.png]] | |||
<li>Click on the <b>"Select File"</b> button and look into C:\Users\SQL\Desktop\MYOB to select 'mydatacli.zip'.</li> | |||
[[File:2016-09-22 1516.png]] | |||
<li>Click <b>"Select File"</b> button then look into "C:\Users\SQL\Desktop\MYOB\<b>TEST_20160908</b>\DATAFILES\MYOB DATA CD\MYOB Data Backup" to select <b>"Test 2015-2016v161.MYO"</b> (MYOB Backup File)</li> | |||
<pre style="color: black; font-weight: bold"> | |||
Those highlighted in BOLD is based on own Company Name of MYOB Backup.</pre> | |||
[[File:2016-09-22 1528.png]] | |||
<li>Refer step below to start import.</li> | |||
Revision as of 07:49, 22 September 2016
Module that can be import from MYOB System
| Data Migration from MYOB | Module | Data Migration from MYOB | Module | Data Migration from MYOB | Module |
|---|---|---|---|---|---|
| Chart of Account | Yes | Customer Master | Yes | Supplier Master | Yes |
| Stock Master | Yes | Project Master | Yes | Area Master | Yes |
| Agent Master | Yes | Terms Master | Yes | Currency Master | Yes |
Setting of MYOB Backup file
Here are the step-by-step guide how to do with MYOB database before import into SQL:-
- Get the MYOB Backup file ( XXX_20160908.zip ) and place the backup file to the Desktop, example C:\Users\SQL\Desktop\MYOB.
- Download 7 Zip to extract MYOB Backup file. Download Path for 7 Zip : Window 32 Bits : http://www.sql.com.my/utility/7-zip.msi Window 64 Bits: http://www.sql.com.my/utility/7-zip-x64.msi
- Refer Image below on How to Extract MYOB Backup file.
* Make sure install the right one or else you cannot find 7 zip to Extract.
Import Data from MYOB
Import Account Master Data
- Create New Database then Log On New Company with ADMIN User.
- Once Log On, Go to File | Data Import |Select MYOB.
- Click on the "Download button" to download a compulsory tool before import MYOB, then place the 'myData CLI' to C:\Users\SQL\Desktop\MYOB.
- Click on the "Select File" button and look into C:\Users\SQL\Desktop\MYOB to select 'mydatacli.zip'.
- Click "Select File" button then look into "C:\Users\SQL\Desktop\MYOB\TEST_20160908\DATAFILES\MYOB DATA CD\MYOB Data Backup" to select "Test 2015-2016v161.MYO" (MYOB Backup File)
- Refer step below to start import.
Those highlighted in BOLD is based on own Company Name of MYOB Backup.
