This support note applies to:
- AO Practice Manager (NZ)
- AO Practice Manager (AU)
- AE Practice Manager (NZ)
- AE Practice Manager (AU)
- AE Tax Series 6 & 8 (AU)
- AE Tax (AU)
In MYOB Practice Manager (PM) you may need to generate a list of all address types attached to your clients. We've created the following spreadsheets to generate this list for you in Microsoft Excel.
This spreadsheet is designed to provide basic information catering for a broad range of requirements. If changes are needed to the spreadsheet, they may be undertaken as a chargeable service, in the same way as report customisations.
Right-click on the relevant link in the Report column of the above table.
From the drop-down menu, choose Save Link As...
Navigate to a memorable folder location then click Save. The report is saved to this folder.
Using Windows File Explorer, navigate to the location you saved the spreadsheet in, and double-click on the file to open it in Excel.
- From within Excel, click the Data tab > Refresh All.
- If you receive a Microsoft Excel Security Notice, click OK to accept.
- If you are prompted with an SQL Server login screen, enter your SQL password and click OK.