Migrating MYOB AE integrated with AE Tax Series 6 or Series 8

It is required that you have a complete and reliable backup of all MYOB AE program and Data files. This needs to be done before you attempt to move or copy data to your new file server.

You'll also need to unschedule all ATO PLS reports on your old server and ensure there are no Tax Returns with a status of Transmitting or Transmitted. If you have Transmitted or Transmitting returns, contact MYOB support for assistance.

1. Log on to my.myob.com.au, and go to the Products > Downloads menu, and select MYOB AE Tax Series 6 or 8 from the drop down choices available.
2. Download the Release Notes, Installation guide and Install files under the most recent full version heading. The version will stated as 8.XX.0 or 6.XX.0

The install file is a self-extracting executable file. When double clicked it will extract all the installation files into a folder and series of sub folders.

• Check the System Requirements and Certified Environment Roadmap on the my.myob.com.au website to ensure that the environment of the new server is compatible;
• Ensure the operating system of the file server has the latest service pack that has been approved.

The DEP setting needs to be set to Turn on DEP for essential Windows programs and services only. If you are required to change the setting, you will need to reboot the server for the setting to take affect.

1. At the Windows desktop, follow the menu path: Start > Control Panel > System. The System Properties window appears.
2. Click the Advanced tab, and then click Settings in the Performance section. The Performance Options window appears.
3. Click the Data Execution Prevention tab, select the Turn on DEP for essential Windows programs and services only option and click Apply. The prompt "The changes you have made require you to restart your computer before they can take effect" appears.
4. Click OK. The Control Panel window closes.
5. Reboot your machine for the changes to take affect.

Turn off both Disabling User Account Control (UAC) and Establishing Data Execution Prevention (DEP) settings.

Server 2008 R2

1. Open Server Manager onTask bar

2. Click on Configure IE ESC

3. Switch Administrators to Off

4. Switch Users to Off

Virus scanners can prevent the installation of MYOB Accountants enterprise so if it has already been installed best to disable it for the duration of the migration.

Install SQL Express to the default instance in mixed mode with named pipes and TCP/IP enabled.

See Installing Microsoft SQL Server 2019 Express with Management Tools to MYOBACCT Instance.

1. Follow the menu path: START > Control Panel > Administration Tools > Terminal Services > Terminal Services Configuration
2. Set the Use Temporary Folders Per Session option to No.

1. Create a folder named MYOBAE either on the root directory or any other physical partition on the new server.
2. Share this folder out as MYOBAE with the Everyone group having Full control of the shares. The MYOBAE folder is shared.

It is best practice to keep the share and drive mapping the same as it was on the old server.

Create a program directory called MYOB under the MYOBAE share folder and ensure it appears as M:\MYOB in Windows Explorer. The MYOB folder is created (it should be on the same drive as theMYOBAE directory)

Before copying the data directories, ensure:

1. everyone is logged out of the software
2. the Administration Centre services are stopped
3. the background process is stopped
4. there are no open files.

To check open files on the old server navigate to START > Control Panel > Administrative Tools > Computer Management > System Tools > Shared folders > Open Files and ensure nothing is open.

For information about stopping and restarting services and process, see Checking, restarting and stopping Admin Centre services and background processes.

The entire database directory, including all sub directories, need to be copied to the new server ensuring you exclude the install location e.g. the folder containing the bin, lib, model, proto and other folders. Please also copy over the Sol64 folder but rename it to Sol64.OLD so that a new one is generated by the installer. Ensure that read only attributes have been removed from all MYOB directories on the new server. The data directory will be copied directly under shared directory "\MYOBAE" and will appear in Windows Explorer as M:\DATA\. The data needs to be backed up on the old server before copying over.

To locate the Database directory:

1. Copy both the folders listed as Database location and System release path
   1. Sites without AEPM: Can be found at START > All programs > MYOB Accountants Enterprise > Contacts > Help > About > Application details
   2. Sites with AEPM: Can be found at START > All programs > MYOB Accountants Enterprise > Compliance Management > Help > About > Application details

1. Make sure all users are logged out
2. Open Datasafe and run a Check Now on the database. See Running the Check Now Utility.
3. Once completed, click the Backup Now button to run a backup in Datasafe
4. Once this has completed, highlight the backup you just completed in Datasafe from the Current Online Backups list then hold down the alt key and double click the left mouse button on the backup you just completed. This will open up the physical location of the backup you have just completed. Take note of the folder name where the backup will be stored.
5. If the site has Corporate Compliance run the Corporate Compliance backup.
6. Open up Contacts to take a note of the data location from Help > About > Application Details > Database location. The datasafe backup you competed at step 5 should be in this location.
7. Making sure all services and processes are still stopped copy the data from the old location (as per step 7 above) to the new Server.

See the installation guide and details downloaded as per Step 2 above, ensuring you install to the program directory created earlier. E.g. M:\MYOB

If you have AEPM stop here and migrate this first, then run an AEPM workstation setup to update the licence paths to UNC, then rename the bothlic.ini files in the C:\MYOB subfolders (one is a hidden file) to avoid the invalid licence issue. Once the database conversion completes don't press Finish, press the [x] to close the window and click Finish on the next window that pops up. This is as instructed in the AETAX_Migration_Utility_2_0_User_Guide.PDF document at top of page 9.

Navigate to the database location on the new server then open the AE_Tax.ini in Notepad. Update the section named AeTaxDb= to the new server\SQL instance name.

You must read the AETAX_Migration_Utility_User_Guide.pdf prior to running the AETax Migration tool. Following this, ensure you run a Resync of the Security Users as per Page 22 of the guide as this will re-populate the System Release logins.

You can download the AE Tax Migration Utility on the my.MYOB Product Downloads page.

Once you have downloaded the AE Tax Migration Utility you will need to run AETaxMigration_2017.exe. When you get to the point where it prompts for the AETaxBackup.bak please do the following:

Copy either AETaxBackup.bak from a Datasafe backup or the AETAX.mdf file to the C:\Program files\MYOB\AETaxMigration folder on the new server. The file is copied to C:\Program files\MYOB\AETaxMigration.

If using the AETAX.mdf file you must ensure that database had been correctly detached from SQL/MSDE. See the Migration Utility User guide for further information regarding this process.

During this processyou will be prompted multiple times with a "Cleared" prompt box to which you just need to press OK.  This is the migration utility refreshing system services links on each year.

If you have AEPM you will also need to do the steps below once the migration utility has finished to ensure the Administration Centre has all the streams required.

1. Open your module.ini located in your installed folders BIN folder e.g. M:\MYOB\bin
2. In the [DB_1] section at the end before the next section add the line VizIntegrated=1 as per example below:
   
   [OpplockChecking]
   SERVER=True
   [DB_1]
   Name=Current
   Dir=\\SERVER\myobdata\DATA\MYOB\
   Group=0
   TimeCost_DB_Type=ACCESS
   DbAccessType=UNKNOWN
   Expand_Usage_Level=80
   Expand_By=20
   BackupDirectory=\\SERVER\myobdata\DATA\MYOB\backup\Group0\
   BackupDataFileName=backup.accdb
   RecvTax=\\SERVER\myobdata\DATA\MYOB\recvtax\
   VizIntegrated=1
   [Database_Mappings]
   \\SERVER\myobdata\DATA\MYOB\Group0=DB_1
   
   
3. Save and close
4. Open Datasafe->Support Tools and DBED your CDS.DIR to remove HVZ and add VIZ
   
   Enter the following commands (in bold) into the command window:
   d config with product(hvz) then press Enter - this removes 0~HVZ~
   s config then press Enter - this will display that 0~HVZ~ does not exist
   u config then press Enter and the cursor will drop to next line ready for data entry
   0~VIZ~ and press Enter
   . and press Enter - saves changes
   s config then press Enter - this will display that 0~VIZ~ exists
   q and press Enter - this will quit the DBED
   
   
5. Once this has been done please run AETaxConfigUpdate.exe from your installed location e.g. M:\MYOB\bin
6. Once the AETaxConfigUpdate.exe has finished you will need to open Administration Centre and ensure the stream Viz-AE Tax has its addresses mapped correctly. Once you have made the changes you will be prompted to run a resync to which you can say No as there is no need.

1. Follow the menu path Start > Run. The Run box appears.
2. In the Open field type M:\SOL64\sr where M: is the location of your program directory. The Login Gateway appears.
3. Enter the User CodeSUPERVIS and the Password S6 and click OK. The Folders list is displayed
4. Double click on the AETax folder. The contents of the folder are displayed.
5. Confirm entries for Central Database Systems, AE Tax Calculator (from 2005 to 2014) and AE Tax (from 2005 to 2014) exist.

If all the entries do not appear, see Creating a new ledger in System Release.

Check my.myob.com.au for any service packs available. And follow the installation guide.

Please check that you can generate an estimate on each tax year from 2005-Current. If it works please skip this step, if not proceed with Refreshing System services links as per below.

System service links need to be refreshed so that Tax Estimates show. For further instructions see Refreshing the System Services links (AE Tax Series 6 & 8).

The ELS History is located in a folder with the same name as your AETax database. E.g. if your database is named AETAX1 then the ELS History will be located in M:\Sol64.OLD\TA\AETAX1.

Tax Letters are located in the root of SOL64.OLD.

1. Locate the ELS folder in the Sol64.OLD\TA folder and select. The folder is selected.
2. Follow the menu path Edit > Copy. The folder is copied.
3. Browse to the newly created Sol64\TA folder and follow the menu path Edit > Paste. The ELS History folder is pasted.
4. In the Sol64.OLD folder highlight all the TaxLetters20** folders The folders are selected.
5. Follow the menu path Edit > Copy. The folder is copied.
6. Browse to the newly created Sol64 folder and follow the menu path Edit > Paste. The TaxLetters20** folders are pasted.

The ELS History and Tax Letters are now copied from the Sol64.OLD folder to the new Sol64 folder. Feel free to remove the SOL64.OLD folder now as it is no longer required.

Open up a tax return of each year and go to Utilities > Control Record > Defaults and enter the SQL password then press ENTER twice to save.

It must be done using the Enter key to take affect. This password is used for Tax Letters.

Backing up the Smart Reports SQL database

For SQL users:

1. Follow the menu path Start > Programs > Microsoft SQL Server 200* > SQL Server Management Studio Express. SQL Server Management Studio Express opens.

2. Expand Databases. The list of databases appear.

3. Right click on the SSR1 database and follow the menu path Tasks > Back up. The Back Up Database window opens.

4. Ensure that the Disk option is selected and remove any existing path in the Destination section of the window and then click Add in the Destination section of the window. The Select Backup Destination window appears.

5. Use the ellipses [...] button to select the destination of where you want to save the backup to and enter a name for the backup in File name, ensuring it has a .bak extension, and then click OK, OK, and OK again. The Smart Reports database is backed up.

6. Copy this backup to the new server and restore.

1. Follow the menu path Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio Express. SQL Server Management Studio Express opens.
2. Right click on Databases and select New Database. The New Database window opens.
3. In Database name type SSR1 and click OK. A blank SSR1 database is created
4. Rightclick on the SSR1 database that has been created and follow the menu path Tasks > Restore > Database. The Restore Database window appears
5. Select From device and click the ellipses [...] button The Specify Backup window appears.
6. Ensure File is selected in Backup media and then click Add. The Locate Backup File window opens.
7. Browse to the backup of the SSR1 database created earlier and select it. The backup is selected.
8. Click OK and OK again. You are returned to the Restore Database window.
9. Tick the Restore box and then select Options The Restore options appear.
10. Tick Overwrite the existing database and click OK. The restore process commences.
    At the end of the restore you'll be notified that the database has been restored successfully.

1. Browse your database location e.g M:\DATA\MYOB folder, locate the ae_tax.ini file and double click to open in Notepad. The ae_tax.ini file opens.

2. Remove the line SSR_DSN=SSR1 and then follow the menu path File > Exit. You are prompted to save your changes.

3. Click Yes. The changes are saved.

   You can now install Smart Reports from the Accounts Enterprise CD. See the Smart Reports Release notes included on the Accountants Enterprise for detailed installation instructions.

1. Install Reporter 3.5

2. Install Reporter workstation setup from M:\MYOB\Setup\reporter Integration\setup.exe

   

   This install lays down a required DLL file. If you have customised your masters these will need to be copied over from the installed location off the old server so you retain changes.

    

When the server installation has completed successfully run a workstation installation from windows explorer by browsing to M:\MYOB\SETUP and double click on the setup.exe file. This will start the workstation installation. At the end of the installation process ensure the workstation is restarted.Also run the Reporter workstation install as mentioned above.

The workstation installation needs to be done on each workstation.

If the workstation is a pre-existing workstation you will need to amend the ceedata.ini manually post workstation setup or copy it from c:\windows off the new MYOB SQL server.

This can be located in different locations depending on your environment.

For Windows 7, 8, 8.1 and 10: C:\windows and C:\Users\user\AppData\Local\VirtualStore\Windows

For Server 2008 R2, 2012 and 2012 R2 Terminal servers/RDS: each user will have their own under %USERPROFILE%\Windows folder

Run the following tests:

1. Open Client Compliance in AEPM and check that all clients are showing on the Client Compliance screen.
2. Open Compliance Management in AEPM and check that all icons are showing on the screen.
3. Open Datasafe by following the menu path Start > Programs > MYOB Accountants Enterprise > Datasafe and check the Datasafe screen appears.

1. Open Contacts or Client Compliance on the server and locate a client with Tax matters and double click to open the client profile. The client profile window opens.

2. Click on the money bag Tax icon. The client's tax return opens.

3. Close the tax return by following the menu path File > Exit. The Tax Return closes.

4. Select a client who has an uncompleted current year tax return and double click the client to open the client profile. The client profile opens

5. Click the Names button. The Names window opens.

6. Change the surname by adding 123 to the end and click OK. The Names window closes and the Surname is changed.

7. Open the clients Tax Return. The Tax Return opens showing the amended Surname

8. Remove the 123 from the Surname and press Tab and then Esc. The Surname changes and the Tax Return closes.

9. Click the Names button. The Names window opens.

10. Confirm the Surname is back to the original entry. Integration is confirmed. Repeat the integration testing process from a workstation.

To set up PLS:

1. Log into MYOB AE as an Administrator user and follow the menu Maintenance > Online > Practice my.MYOB settings. 

2. Enter your Practice my.MYOB login, password and MYOB client code in the relevant fields.

   

   Make sure the Practice my.MYOB login that you enter is the same Practice my.MYOB login used on your old server. This login must have web administrator access on the my.myob website.

3. You'll need to onboard again with your new softwareID to setup for PLS. See How to complete the onboarding process?

For details of how to set Datasafe backups on the server see Scheduling DataSafe to back up one or more databases.