DataWise staff have all been approved and certified as professional partners and developers for many years.

CoPilot Support

Download the 30 day Trial


DataWise works with many of the MYOB products, including MYOB Accounting and AccountRight Family, MYOB Payroll, Exo Payroll, and Retail Manager.

WindedPowered

 


BULK ATTACHMENT DOWNLOADS (ACCOUNTRIGHT & MYOB BUSINESS)

Background

At the time of writing, documents can be uploaded via the In-Tray and attached to purchases, spend money transactions and cards. Multiple attachments can be added to any of these records. Attachments are not stored with your company file, but in a separate database. 

If you wish to retrieve a document, you can do so in the MYOB program one document at a time, and save it as a PDF. The default attachment name will be like 68ed5174-a864-4ce4-b8dc-4e9e07a73ef7.arlsmartdoc.pdf. If you want to be able to locate a PDF for a particular record later, you will need to save the PDF under a different name.

Do you need to download all your attachments?

There will be occasions when you need to download attachments in bulk. For example:

- you have not religiously saved copies of every document to a local folder before uploading them
- you are taking your file offline permanently
- you require all documents for a period for (eg) a tax audit
- You are closing down your business and require copies of the last 7 years' attachments for your records
- You are moving to a new software program and ceasing your subscription to AccountRight

A solution for bulk downloads

MYOB advise that they will provide bulk downloads on application, but we suspect that the default filenames will be used. Note that File Explorer will search within PDFs, not just on the file names, but PDFs with image content, as opposed to text content, will be omitted from the search. Meaningful file names makes it easy to find, for example, all attachments for one transaction.

The limitations of downloading attachments in the core programs (one-at-a-time, meaningless file names) have prompted us to develop an efficient solution to downloading in bulk. The main features are:

- Due to complexities with the API we now only provide this as a service.
- The download includes attachments to item & service purchases and Spend money transactions (card attachments are not yet available via the API)

- File names for purchases include part of the supplier name, the MYOB reference (eg PJ number), supplier invoice number and transaction date. To find a PDF for any transaction across a folder or group of folders, you may only need to know one reference.
- File names for Spend Money transactions start with the words "Spend_Money" and include the "cheque number", part of the Payee, and the date
- Multiple attachments for the same transaction have a numeric suffix added

What you need to do

To utilise our service:

- Email or call us to with your details.
- You invite us to your file as a user, read-only
- We process the attachments across the date range/s you require.
- A deposit invoice issued = to the setup fee required up front.
- Once we have susccessfully downloaded the attachments, we send you a spreadsheet of ffiles downloaded for you to check and final amount of download.
- On receipt of balance payment, we send you a link to the file folder/s, using SendThisFile .comfile transfer method.
- Once you have confirmed the contents as correct, we delete our PDF copies and you cancel our file access. 

Pricing

 $150.00 set-up fee for the first data file, $100.00 per file thereafter
+ $50.00 per 1000 pdfs with maximum $750-00 charge per file)

The prices are the same in both AUD and NZD.

Conclusion

For further inquiries contact sales@datawise.co.nz.