MYOB Advanced Report Designer

sfarrar

Hi,

 

I cannot find where to download the report designer tool for MYOB Advanced. Can you please point me in the right direction?

 

Thanks

Will_H

HI  @sfarrar ,

Sorry you didn't get a reply on this earlier.  
The report  designer can be reached at the screen "Download MYOB Advanced Tools"
The screenID is "FILEGETTER"

If you can't find this screen you might be missing the required role: "ReportDesigner".  Your administrator should be able to add this role to your user if you don't have access yourself.

 

Please be aware:
There are effectively 3 report writers in MYOB Advanced, being:

• Analytic Reports
  An excellent way to get to your General Ledger data, and generally the least technical writer since you're mostly deciding on your Row Sets, Column Sets & Unit Sets.
• Generic Inquiries 
  A great way to get data to view on screen or export to Excel, less good for printing. 
• Report Designer Reports.
  These are very powerful, but generally more complicated to write than Generic Inquriies.   Almost all printed reports are from the Report Designer.

 

@sfarrar ,

The above should work for you as well, but please be aware that the report writers in Advanced Business are fairly technical.

If you're looking to find further learning related to Reports in MYOB Advanced then we have some courses about the ARM reporter (General Ledger reporting) over in the MYOB Learning Academy:
https://academy.myob.com/blocks/kineo_coursesearch/index.php?query=report&products=MYOB Advanced Business&sort=popular

If you're looking for the full technical information that consultants use to set up the system, I recommend the S150 Report Designer course from Acumatica as an excellent starting point: 

https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/

Depending on your familiarity with SQL, you may also want to do some learning about SQL Joins, as the language used to write queries in Advanced is similar to SQL. 

My favorite starter SQL source is here;  
https://dataschool.com/how-to-teach-people-sql/sql-join-types-explained-visually/
But anything that teaches you about "Joins" is a good concept to get your head around.
But there are tonnes of tutorials available online for SQL.