This support note applies to:
- AO Tax (AU)
- AE Tax (AU)
- AE Tax Series 6 & 8 (AU)
In MYOB Tax, you may experience the error "Roll over failed" when running the Year End Routine for SQL Tax 2023.
Perform data integrity check in the prior financial year to ensure any orphaned records are removed from MYOB Tax.
An "orphaned record" is information that no longer has a connection to any other data or database table.
See Performing an Integrity Check for details.
This process will clear any existing tax return data in the 2023 tax year.
If you've already lodged or started to work on a 2023 tax return, export the return before resetting your tax data files. After resetting the 2023 tax data files, you can import the returns back in and continue working.
Log in to Identifying the location of System Release as an Administrator with level 6* security access.
If you are unsure of an administrator username or password, use the following credentials:
User code: SUPERVIS
Click the Folders option from the Navigation Bar.If the Folders window does not appear, click the Administration link on the Navigation Bar; then the Folders option.
- Select the Tax folder with the reference AETAX1 or AOTAX1 and press Enter.
- Right-click on the Tax 2023 ledger and select Rebuild. The message "Ledger has been operated on since backup. Continue?" appears. Click Yes. The Data rebuild/reset utility window appears.
Click the Reset tab and select the following files:
Do not tick the files: DZZTT010 AND DZZTB010
Click OK. The message "Warning: You have elected to reset some database components. This will result in any existing data stored therein being deleted. Are you sure you wish to proceed?"
Click Yes. The 2020 tax database files are reset. You'll now need to run the Year End Routine.
After resetting your tax database files as per the previous procedure, from System Release, double-click the Tax 2023 ledger. The year-end routine appears.
- Follow the Year End Routine prompts to complete the process.
The 2022 PLS Tax tables will need to be recreated. Call our support team for assistance with this procedure.
- Log into System Release and open the Tax 2023 year.
- Follow the Year End Routine instructions.
MYOB Internal Notes
Run the following scripts located within C:\Program Files (x86)\Myob\TaxCore\ in order on the clients SQL tax database to recreate the tables. (PD will be making a utility for this. Check with Premium).
tax install 01 - Tax_TaxYearTableType.sql
tax install 02 - Columns and Indexes.sql