MYOB: Difference between revisions

From eStream Software
Line 64: Line 64:


===Import Others Master Data===
===Import Others Master Data===
* 7.4 Go to <b> Tools | Options | Customer and update <b>Default Control Account.</b> Same things apply on Supplier.
* 7.4 Go to <b> Tools | Options | Customer and update Default Control Account.</b> Same things apply on Supplier.
[[File:2016-09-22 1623.png]]
[[File:2016-09-22 1623.png]]
<li> Once done setting, repeat Step 2,4,5 & 6 to continue import.</li>
<li> Once done setting, repeat Step 2,4,5 & 6 to continue import.</li>
* 8.1 Select the rest of the modules & click Execute.
* 8.1 Select <b>the rest of the modules & click Execute.</b>
* 8.2 Once the last module "Stock Item" shown as "Done" then click Exit to close it.
* 8.2 Once the last module "Stock Item" shown as "Done" then click <b>Exit</b> to close it.
[[File:2016-09-22 1631.png]]
[[File:2016-09-22 1631.png]]

Revision as of 08:36, 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:-

  1. Get the MYOB Backup file ( XXX_20160908.zip ) and place the backup file to the Desktop, example C:\Users\SQL\Desktop\MYOB.
  2. Download 7 Zip to extract MYOB Backup file.
  3. 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
    * Make sure install the right one or else you cannot find 7 zip to Extract.
    
  4. Refer Image below on How to Extract MYOB Backup file.
  • 3.1 Right click on MYOB Backup file.
  • 3.2 Select "7-Zip"
  • 3.3 Select "Extract Files"
  • 3.4 Extracted file will show as another folder.
2016-09-22 1457.png

Import Data from MYOB

Import Account Master Data

  1. Create New Database then Log On New Company with ADMIN User.
  2. 2016-09-22 1505.png
  3. Once Log On, Go to File | Data Import |Select MYOB.
  4. 2016-09-22 1509.png
  5. Click on the "Download button" to download a compulsory tool before import MYOB, then place the 'myData CLI' to C:\Users\SQL\Desktop\MYOB.
  6. 2016-09-22 1513.png
  7. Click on the "Select File" button and look into C:\Users\SQL\Desktop\MYOB to select 'mydatacli.zip'.
  8. 2016-09-22 1516.png
  9. 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)
  10. Those highlighted in BOLD is based on own Company Name of MYOB Backup.

    2016-09-22 1528.png

  11. Refer step below to start import.
  • 6.1 Click Connect
  • 6.2 Select Chart of Account.
  • 6.3 Click Execute to Import
  • 6.4 Once done import Chart of Account, click OK to close the message.
2016-09-22 1601.png
  • Once you have done import Chart of Account, it’s prompt an message that successful and you have to do few setting according to the message
    • 7.1(a) Read the Information then click "OK" to close it
    • 7.1(b) Close the Data Import.
    2016-09-22 1612.png
    • 7.2 Go to GL | Maintain Account, verify the Imported Chart of Account & set the necessary Special Type. Especially for Trade Debtor, Trade Creditor, Bank/Cash Account, Stock & etc.
    2016-09-22 1617.png
    • 7.3 Go to Tools | Options | General Ledger, to setup for :
    - Financial Start Period
    - System Conversion Date
    - Default Account
    2016-09-22 1621.png

    Import Others Master Data

    • 7.4 Go to Tools | Options | Customer and update Default Control Account. Same things apply on Supplier.

    2016-09-22 1623.png

  • Once done setting, repeat Step 2,4,5 & 6 to continue import.
    • 8.1 Select the rest of the modules & click Execute.
    • 8.2 Once the last module "Stock Item" shown as "Done" then click Exit to close it.
    2016-09-22 1631.png