As you would expect, MYOB Advanced incorporates a standard report designer that allows you to create quick and easy transaction reports, audit trail reporting and of course ubiquitous forms such as invoices , statements quotes and PO’s.
For simple single layer dashboards constructed from Generic Inquiries and widgets in MYOB Advanced this capability is included out of the box.
MYOB Advanced data can be exposed using web services, integration tools, and reporting tools. Web services and integration tools expose data from specific MYOB Advanced screens – so they make data available using the standard data classes. Reporting tools allow you to mix and match data tables to expose any data you need.
The generic inquiry writer is a reporting tool that can access any data in MYOB Advanced, including data stored in customised fields, and publish it. The OData formatting option exposes the data in the Open Data Format supported by business intelligence tools like Microsoft Power BI.
Microsoft Excel Integration
Microsoft Excel has been for many years, the tool of choice to access, format and report on data from Financial Management Solutions like MYOB Advanced so its no surprise that MYOB Advanced has the topic of Excel integration well covered. Almost any data grid, screen or report can be instantly exported to Excel and in most cases a live read-only link is created that allows instant refresh of the data from Excel without going back to MYOB Advanced to regenerate the report.