Troubleshooting Adapt Desktop

This page describes some issues you might come across in MYOB Adapt Desktop and how to resolve them.

Removing uploaded data from MYOB Advanced

If you’ve uploaded data records that don’t need to be in MYOB Advanced, you can’t undo the upload or delete the records using Adapt Desktop. For example, if you uploaded 20 records and realised 5 shouldn’t have been uploaded.

You have to manually delete the unnecessary records in the MYOB Advanced site. To prevent the unnecessary records from being uploaded again, make sure you update the extract in Adapt Desktop as well.

Microsoft Excel file issues

If you’re using Microsoft Excel files to upload data to MYOB Advanced, you might encounter some issues. We’re working to resolve this issues in a future release. In the meantime, you can follow these workarounds to keep your migrations on track.

When working around these issues, you can either edit the Excel file copy you already had, or you can export a fresh Excel file from Adapt Desktop.

Can't upload upper case fields or abbreviations

In the Pay Details-Taxation progress item, if the data in the Residency column is written in upper case, then the upload fails.

To resolve the issue, edit your Excel file so that data in the Residency column is not all in upper case. For example, replace AUSTRALIAN with Australian.

This issue only affects the Residency column. Data in the ContractType column can be in upper case or sentence case – e.g., INDIVIDUAL or Individual.

Can't upload data for Pay Details-Taxation progress item

For the Pay Details-Taxation progress item, you need to upload dates for the following fields before you can upload the rest of the data:

• UpwardsHoldingsVariationEffectiveDate

• WithholdingSingedDate

To resolve the issue:

1. In your Excel file, enter dates in the DD/MM/YYYY format for the UpwardsHoldingsVariationEffectiveDate and WithholdingSingedDate fields. If you don’t know the dates, leave the fields blank.

If you enter anything fields other than the correct dates (e.g., if you enter the wrong date or use the wrong format), your upload to MYOB Advanced will fail.

If the fields are null, blank, or contain any characters, such as a space, the upload fails.

2. Save your changes to the Excel file.

3. Import the Excel file to Adapt Desktop.

4. Upload the dates to MYOB Advanced.

After following these steps, you can upload other data.

Can’t upload changes to employee ID formats

Sometimes, the format of employee IDs in your customer’s source data might not match the format of IDs required in MYOB Advanced.

If you upload employee IDs in an incorrect format (e.g., as part of a test migration), you won’t be able to correct them by just changing them in Adapt Desktop and uploading them again. We’re working to resolve this in a future release.

Instead, you need to re-upload the employee IDs as a Microsoft Excel file.

In cases of format changes, this workaround will also work for that progress item too

1. In MYOB Adapt Desktop, go to the Employees progress item.

2. For all employees, select the Ignore checkbox.

3. Export the employee ID data into a Microsoft Excel file.

4. In the Excel file:

   1. delete the first three columns: toupload, uploaded and Ignore.

   2. In the EmployeeID column header, delete any space in the text on EmployeeID column header.

   3. Save your changes.

5. In Adapt Desktop, re-import the edited Excel file.

6. Select the To Upload checkbox for all the data you imported from the Excel file. You now have two groups of employee data: one to be uploaded and one to be ignored.

7. Click Upload to upload the changes to MYOB Advanced.

Error: “Guid should contain 32 digits with 4 dashes”

To avoid this issue, make sure that all payment types are available in MYOB Advanced before uploading employees and employee banking details.

Missing payroll data in Adapt Desktop

If there are no rows of data for some progress items, like Superannuation Funds or Employees, that means an issue occurred when extracting data with Adapt Uploader.

You can resolve the issue of missing data by rebuilding the staging database, then re-extracting the data with Adapt Uploader.

1. Log in to the MYOB Adapt online portal.

2. On the Customers screen, click the customer whose migration is missing data.

3. On the Edit Customer screen, click the migration that's missing data.

4. On the Edit Migration screen, click Rebuild Staging Database.

   

5. Read the warning message and click OK.

   

6. Log in to Adapt Uploader.

7. Re-extract your customer's data.
   After re-extracting, all of your customer's data is available to work on in Adapt Desktop.