Performing Force RSD in Accountants Enterprise


These instructions are for the client to do it themselves. Please don't run the steps with the client. If the client requests you to do the steps, talk to the tax team leader first.


Article ID: 55312455


Only follow the steps in this KB if support asks you to. It requires technical expertise. Make sure you read all the instructions before proceeding. If you're unsure, speak to your IT for help.

This KB is relevant only for AE and Series 6/8 clients who have done a bulk rollover of all the tax returns.

In these steps, we'll be forcing a rollover of the tax returns that have already been rolled over.

Before you begin
  • Make sure you have access to the server where your SQL database is located. You'll need this to take backups.

  • You'll need to be an administrator to login to AE and system release. You'll need the admin rights to export and import tax returns.

  • Make sure all users are logged out of AE.


Step 1: Taking a backup of your SQL database and the ledger


SQL backup

On your server, take a backup of your Tax (for eg., AETAX1) and Practice management (for eg., VMPSER or AEDB1) databases. Follow the steps below for instructions.


2020 Ledger backup

Take a backup of your 2020 tax ledger. Follow the steps below for instructions.



Step 2: Exporting tax returns with status other than not started

Export any returns that don't have a Not Started status. You can import them back later. You can use Audit update option to export returns in bulk and within a date range.

  1. Open MYOB AE/AO and click the Tax button. The Tax Homepage:  Tax - Client Search tab appears.

  2. Highlight the required return then click Export in the Tasks panel. The Export Returns window opens.

  3. Ensure that all options on the left-hand side are selected except for the Include client details option. The export options are selected.

  4. Select Batch on the right-hand side. Batch is selected.

  5. The Current path shows the location to which the export files are exported. MYOB recommends not changing this location, as it is the default required for importing tax returns. Deselect Send as email attachment.

    pic1.png

  6. Click OK. The Export batch window opens.

  7. Select Audit Updates. Select this option to export all or some of the returns you had worked on during a certain period.
    audit.png

  8. Select Edit and enter a date range.
    We recommend the date range to be when you first installed tax 2020 (for example, 31/07/2019) till the date you're performing these steps.

    date range.png

  9. Click OK.
    For example, you've made changes to 100 returns, 15 of which were done in the last 2 days. If you set the date range to this 2 day period then the 15 returns will be exported.

  10. Click OK. The Export Returns window opens.

  11. If you have previously exported returns, the message "Do you wish to Overwrite or Append?" appears. We suggest you select Overwrite for the first time, but if you need to export any more returns after that select Append.

    In exporting all the selected tax returns, this creates a file called EXPORT in the chosen export directory. 


Step 3: Unlocking the exported returns

When you export a tax return, the returns will be locked. You can unlock the returns in bulk.

  1. Login to system release as an administrator.

  2. Double click to open the tax 2020 ledger.

  3. From the Utilities menu, select Unlock/lock return.

  4. In the Lock/Unlock returns window, under selection select Range and under Option select Unlock.
    unlock.png

  5. Double click the locked returns and select OK. The returns are unlocked.


Step 4: Performing the Force RSD
  1. Login to System Release as an administrator.

  2. Double click to open the tax 2020 ledger.
    tax 2020.png

  3. From the Utilities menu, select Practice default options > Retain schedule data.

  4. If the Enter Master Password window appears, enter the master password. The default password is ASSERT. If this doesn't work, contact your practice administrator.

  5. In the Retain Schedule Data Options window, select Force RSD for every selected Return.
    force rsd.png

  6. Go to Form

    I tab and make sure the following options are selected:

    1. Retain alpha details

    2. Update Deprec and Capital works deds

    3. Carry forward Capital Losses.

      form i.png
  7. Go to Form C and F tab and make sure the following options are selected:

    1. Retain alpha details

    2. Update Depreciation and Capital works deds

    3. Carry forward Capital Losses.
      form cf.png

  8. Go to Form P and T tab and make sure the following options are selected:

    1. Retain alpha details.

    2. Update Depreciation and Capital works deds

    3. Carry forward Capital Losses.
      form pt.png

  9. Go to the General tab and click Execute.
    general.png

  10. Select Proceed in the Retain Schedule Data Options window.
    proceed.png

  11. In the Record Selection window, select By Range.

  12. Leave the From and To fields blank and click OK.
    by range.png
    The returns are now reset to Not started.


Step 5: Import back the tax return you've exported
  1. Open MYOB AE/AO and click the Tax button. The Tax Homepage:  Tax - Client Search tab appears.

  2. Highlight the return then click Import in the Tasks panel. The Import Tax Data window opens.

    When importing tax returns back into the system, ensure that you do not include the EXPORT.CDS file. This file can be removed from your export location. Only import the EXPORT file.


    The question "Print a list of the Return(s) imported?" appears.

  3. Click Yes. The Print window opens.

  4. Click Preview. A print preview of all the imported tax returns appears.

  5. Click Close. The Tax Homepage returns and the EXPORT file is imported.