Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Reports: Simple data table format reports

Cover User

3Posts

0Kudos

0Solutions

3 Posts
Cover User
Australia

It would be a real time saver if MYOB reports such as the "Account Transaction" and "payroll category transaction" reports were also available in simple data table format.

By this I mean that they don't subtotal by the first column, but just repeat the item down the rows.

This would enable the tables to be easily exported to excel and its powerful Pivot table function.

I imagine this would be a really simple option to add in.

These are really good reports, but at present I spend a lot of time manually converting the reports in excel to data table format.

I have looked at the ODBC driver, but the 64bit/32bit problem raises its head.

If there is a work around please let me know.

thanks

Michael

 

"MYOB Reports in Data Table format"

 

 

 

Current Status: Archived
Last Changed: August 2018

Thank you for the idea. Unfortunately, this request has had no support from the community since it was submitted, so we are moving this idea to the Archived status. For more information on Idea Statuses, please read this article: Changes to our Idea Exchange pages

3 Comments
The_Doc
Ultimate Partner
1,537 Posts
Ultimate Partner

Hi @Mike_McG

 

 

I think a big problem here is that most of the fields in the datafile are text and not numbers - it cuases serious grief when importing. Not so much exporting as a text that looks like a number gets treated as one.

 

Just look at how MYOB handles GST and rounding to get a grip on the problem.

 

The Doc

AccountingPower
Valued User
194 Posts
Valued User

HI Mike

 

You can do this using Excel, regardless of 32/64 bit - you just have to know how to do it.

 

Shoot me an email to matt@accountingpower.com.au with the specific issue that you have using the ODBC driver and the actual 32/64 bit problem you have and I'll create a short video for you to show you how to do it.

 

Its just super easy once you know how.

 

Matt Jones

AccountingPower

Advanced Reporting for MYOB - Made Super Easy

 

Steven_M
45,180 Posts
Former Staff

Thank you for the idea. Unfortunately, this request has had no support from the community since it was submitted, so we are moving this idea to the Archived status. For more information on Idea Statuses, please read this article: Changes to our Idea Exchange pages