Error: "Roll over failed" in Tax 2025 (SQL)

This support note applies to:

AO Tax (AU)
AE Tax (AU)
AE Tax Series 6 & 8 (AU)

Article ID: 37410904

In MYOB Tax, you may experience the error "Roll over failed" when running the Year End Routine for Tax 2025.

Use this article if you need to reset the 2025 ledger.

Before you begin

Backing up the MYOB AE or AO database. If you're using AE Series 6/8, make sure you also take a Performing a Datasafe backup.
Ensure all users have Error: "Cannot obtain unique access - other operators in tax" of all MYOB AE or AO applications.
For MYOB AE, Verifying if SQL Tax is installed.

2. Reset your 2025 tax data files

This process will clear any existing tax return data in the 2025 tax year.

If you've already lodged or started to work on a 2025 tax return, export the return before resetting your tax data files. After resetting the 2025 tax data files, you can import the returns back in and continue working.

2. Reset your 2025 tax ledger

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
Password: S6
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 2025 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:
TB Header
A DS6TB610
C DZZTB630
D DS6TB640
E DZZTB650

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.

3. Run the Year End Routine

After resetting your tax database files as per the previous procedure, from System Release, double-click the Tax 2025 ledger. The year-end routine appears.
Follow the Year End Routine prompts to complete the process.

The 2025 PLS Tax tables will need to be recreated. Call our support team for assistance with this procedure.

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