Please follow the steps provided in this support page to upgrade your ODBCLink.

We are pleased to announce that the ExcelReportLink List Reports now include a bulk jobs updater which allows you to make changes to jobs in bulk.

You can use it to quickly update all the job numbers or job names.

Click on images above to enlarge.

At this stage, it is only available in the Pro Edition.

In addition, we have included a Jobs List report which is available in All Editions.

To download the latest version of ExcelReportLink List Reports, go to the ExcelReportLink List Reports download page.

Jeff Stephenson
Managing Director | Solution Architect

Situation

MYOB has custom lists and these need to be udpated in bulk

Procedure
1) Export the list to Excel

2) Add the New Name in Column D

Save as text file and import back in.

Set import option to Update existing data

Match all fields

The list is now updated

MYOB have released the 2014.3 update of MYOB AccountRight live.

You will need to upgrade ODBClink:

• if you are using ANY version of MYOB AccountRight live on the cloud;
• if you are planning on upgrading to MYOB AccountRight live 2014.3 and are using it locally, on a server or in the cloud.

Upgrading ODBClink is FREE for all users. You can download the latest upgrade of ODBClink (v3.42.7.109) as well as read the terms from the following link.
http://accountingaddons.com.au/odbclink/upgrade

You can find the upgrade instructions on our wiki.
http://accountingaddons.com.au/wiki/budgetlink/index.php?title=Upgrading_ODBClink

For more information about ODBClink, go here.
ODBClink Home

We hope this update makes a difference.

Jeff Stephenson
Managing Director | Solution Architect

We give away functionality to solve the core accounting problems
Charge a low monthly fee for functionality that solves the complex problems
Assist you with high end consulting services at an hourly rate

Currently our reporting add-on software integrates with Xero Online Accounting.
It works by connecting to the Xero API

Our solutions integrate with the following MYOB accounting products, editions and versions:

MYOB AccountRight Live
All editions including AccountRight Live Basics, AccountRight Live Standard, AccountRight Live Plus
Version 2019 and all earlier versions including Version 2013.

MYOB AccountRight Classic
All editions with the MYOB ODBC Driver including AccountRight Enterprise, AccountRight Premier and AccountRight Standard
All versions up to v19.9

Steps to cleanse an MYOB AccountRight Classic data file

1. Contact us to discuss your data cleansing requirements.
   We will then provide an estimation
2. If you choose to proceed then we will forward an invoice for 50% of the minimum expected amount. Upon notification of payment we will schedule in a time to perform the processing. Typically this will be over the week end.
3. Optimise and backup your MYOB data file
4. Click this link to open Dropbox
5. Enter your Name and Email address
6. At Subject enter [Your Company Name] MYOB Data file
7. Select your zipped MYOB data file
8. Select any supporting documents required to match records. ie a list of matching duplicates
9. In the Notes field enter your MYOB Administrator Username and Password and confirm that the MYOB data file has been optimised. Also include any instructions on what you want us to do
10. Click Send it
11. Ensure that users do not make changes to MYOB during processing
12. When processing is complete an email will be sent with a link to a zipped copy of your cleansed MYOB Data file.
13. Download and unzip the MYOB Data file and make it the current version.
14. Check that the MYOB data file appears OK.
15. When OK advise users that they can log back onto MYOB.

BudgetLink – Specialised Functionality – Price on Application

Functionality that requires consulting to implement and may require some development depending on what is required.

• Simultaneous MYOB Category and Job budgeting and reporting
• Set up and monitor account ratios and KPI’s like Current and Debt to Equity ratio’s
• Publishing Scripts – Published sets of reports and distributes to users.
• Overnight Upload – Used if you have many or large data files or many users. Pulls data from from sources overnight so that reports are immediately available
• Company Eliminations using Categories – Track and eliminate inter-company transactions using categories.
• Data Archiving – Archive MYOB actual data to allow detailed reporting into historical years even when transactions are purged in MYOB.
• Consolidate data files across different accounting systems
• Quotes and Orders Version – Report in a profit and loss and balance sheet format. Combine with Actuals to create a forecast
• 13 4 weekly period reporting
• [4, 4, 5] weekly reporting periods
• Cash flow reporting by Job
• Benchmarking
• Cash flow Statements and Forecasts – Split by Operating, Investing and Financing Activities
• EBIT and EBITDA Reporting
• Job Linked Customer Hierarchy – Report Profit and Loss by Job Linked Customer
• Security – Setup users and restrict them from accessing selected reports and divisions (jobs)
• Integration with MYOB EXO

Download BudgetLink for FREE

BudgetLink Home