Breadcrumbs

Transporting the parameter tables and layouts to SQL for AO Tax

This support note applies to:

  • AO Tax (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 34271

In MYOB Accountants Office Tax (AO Tax) if you experience some of the following scenario's when opening a tax return you will need to transfer the parameter tables and layouts to SQL. These include:

  • A blank screen appears;

  • A blank screen appears with no labels for a specific tax year or

  • Parts of the layout of the tax return are missing.

Transferring the parameter table and layouts to SQL is a routine that should only be run under the supervision or advice of MYOB Support.  Do not attempt this process unless you have been directed to do so.

Prior to performing this process make sure

There are 2 steps in this process.

  1. Find the location of the System Release directory to open System Release

  2. Perform the transfer of files and parameter tables.

Click to see the instructions

Opening System Release and Transport layout of SQL tables

  1. In MYOB AO, click Maintenance > Maintenance Map > Tax > Settings.

  2. Make a note of the location at Tax Program Path.
    taxprogrampath.png

  3. Open windows explorer, navigate to the location of Tax folder as shown in the Tax Program Path.

  4. Find and double click on sr.exe from the list of files in the Tax folder.

  5. Login using the details: User code = SUPERVIS and the Password = S6.

    If the Login gateway does not appear, you have automatically been logged into System Release however you might not have level 6* security access. Select File > Login As and then go to step 5.

  6. Double click on the folder with the reference to your Tax database. For example, AOTAX1.

    If the Folders window does not appear, click the Administration link on the Navigation Bar; then the Folders link.

    taxfolders.png

     

  7. Highlight the AOTAX1 folder and press ENTER. List of Tax Calculators and Ledgers appear.
    taxledgers.png

  8. Right-click the affected tax year's ledger and select Properties.

    taxmenu.png


  9. Type /s in the Command field and click OK. The Ledgers window re-appears. 

  10. Highlight the affected tax year's ledger and press ENTER. The message "These routines should only be run under the supervision of support" appears. Example:  Highlight Tax 2013 and then press the ENTER key on your keyboard.

  11. Click OK. A shortcut menu appears.

  12. Select 5. Other Utilities. Another shortcut menu appears.

  13. Select 4. Transport files. Another shortcut menu appears.

  14. Select 2. Transport layouts to SQL. The message "Warning All users must be out of Tax. Ensure that you have a reliable backup before performing this procedure." appears.

  15. Click OK. The Transporting files window appears.

    Once the procedure has finished a shortcut menu appears.

  16. Select 5. Other Utilities. Another shortcut menu appears.

  17. Select 4. Transport files. Another shortcut menu appears.

  18. Select 3. Transport Parameter table to SQL. The message "Warning All users must be out of Tax. Ensure that you have a reliable backup before performing this procedure." appears.

  19. Click OK. The Transporting files window appears.

    Once the procedure has finished a shortcut menu appears.

  20. Press ESC. The list of ledgers appears.

  21. Right-click the affected tax year's ledger and select Properties. The Item properties window appears. Example:  Right click on Tax 2013 and select the option Properties.

  22. Click the Options tab. The details of the tab appear.

  23. Delete the /s in the Command field and click OK. The Ledgers window re-appears.

  24. Close out of System Release using File > Exit.