Generate reports from MYOB AccountRight

Question

hi there,&nbsp;We use Microsoft's Power BI to generate reports but as Microsoft have advised that they have EOL the content pack integration to Power BI Online as of 1 September 2019, we cannot use Power BI to generate report from myob accountright.&nbsp;&nbsp;&nbsp;We are looking to create reports that require the data from Profit and Loss Statements, Balance Sheets and Cashflow statements (this would include account numbers, balances etc.)&nbsp;&nbsp;&nbsp;Could u please suggest what options are available for the reports creation ? Are there any third party apps available which directly integrates with myob?&nbsp;Regards,puja&nbsp;

hdexpertise · Answer

Hi,&nbsp;We have developed reports for our MYOB customers from MYOB classic 19 until MYOB 2020. Our solution is that we pull data from MYOB (requested tables) and put it to another database (we used MySQL), then we develop reports and dashboards on MySQL database.&nbsp;For MYOB AR 2020, we developed a program that connects to MYOB API and pulls MYOB data through API and puts it as a database table. The logics of MYOB AR 2020 does not much differ from MYOB AR Classic 19, so when you pull data, you can create tables like AR Classic tables

mike_james · Answer

Hi&nbsp;PujaParekh&nbsp;, the ODBC and API access methods are completely different, so don't make any assumptions about performance in general, or particular apps. The vendor can probably comment further.&nbsp;
&nbsp;
We do the same, ie we use a local relational database to store API extracts for further reporting, and we find the performance of the extracts is generally adequate for most users' requirements. Occasionally we switch to reporting off the live file, either because performance is not an issue, or for functional reasons.&nbsp;
&nbsp;
Note that extracting data from cloud files requires you to deal with oauth2 credentials and processes including 2FA, whereas extracting data from files held locally or on a network does not.&nbsp;

neil_m · Answer

Hi&nbsp;PujaParekh&nbsp;
&nbsp;
In terms of third party programs that have been previously developed to integrate with different MYOB programs I recommend having a look at the MYOB Apps Marketplace. This is a collection of different third party apps that other developers have created.
&nbsp;
If you were wanting to make use of the AccountRight or MYOB Essentials APIs to extract information from the file, I recommend taking a look at the documentation on our MYOB Developers website, which details a lot of information around the APIs, including code snippits.

pujaparekh · Answer

Thank you for the reply.&nbsp;&nbsp;Yes, we looked at this option of using the myob API to download data from myob table into sql server tables and then generate reports in using Power BI (power BI connects to sql server).&nbsp;As we are already using the myob API to export data, we know that its very slow at times. So downloading data and the need to create myob tables in sql server is a time consuming process and the data is not up to date.&nbsp;&nbsp;We were looking at the below option where u use this addon to access myob tables directly in sql server. It paid though unlike myob API.&nbsp;https://accountingaddons.com.au/odbclink/&nbsp;Wondering if u have used this addon or have more information on it. Wouldn't this be better than myob API ?I would like to know your thoughts on this.&nbsp;

mike_james · Answer

Hi&nbsp;PujaParekh&nbsp;, the ODBCLink app uses the API to access the AccountRight file, and then converts the endpoints into tables that look like the ODBC tables in v19. So it is likely to operate at the same speed or slower than native API, given that there is a conversion/transformation process included.&nbsp;

Forum Discussion

Generate reports from MYOB AccountRight

Looking for something else?

Related content

AccountRight Import General Journal Error

Supplier Inv No. displayed in a General Ledger Report

AccountRight Plus Viewing Report issue

General ledger detail report MYOB Business Lite

AccountRight Report not matching my STP report

Report packs using custom PDF style templates not generating

Discount reports in Accountright

Entering General Journals after EOY Rollover