Hi,
I've been struggling with MYOB for a while trying to make the custom report I want and finally dropped the idea.
To create a custom report: I need to open a prebuilt report, then select the ...
Reports: Ability to create own report
okcorale
7 years agoExperienced User
It would be beneficial if all data fields are available for selection in the reports module. We utilise most data fields in the inventory and card files. We have over 2000 card files and 6000 inventory items and rising. The limited information we can get through the reporting module is causing extra unnecessay workloads.
- DanT7 years agoContributing Cover User
I agree, there should be no downside to making the custom report options able to reference all fields. I have been trying to ad a single field which was available in Quickbooks (ship to address) due to the MYOB limitation in a card file of only 5 address entries. This does not support customers that have more than 5 addresses which results in needing to use another card for each individual address. By doing this it's impossible to have a report which you can filter/sort by delivery address
- Jennifer_Kelly7 years agoSuper Partner
To be able to access most of the fields from an Item, Customer and Supplier card and from invoices themselves to use in your reporting, to filter and sumarise by can I suggesst that you look at some of the Advanced Reproting Addon solutions - https://www.myob.com/au/addons/
A number of these solutions will definitely help open up your MYOB data for more flexible and automated reporting.
As an example our Business Intelligence solution BI4Cloud lets you report on Item Sales while accessing fileds including:
- Customer State, Country, Custom Lists & Fields, Salesperson, Last Sales Date etc
- Item Custom Lists & Fields, Average and Standard cost
- Supplier Custom Lists & Fields,
- Invoice - Ship to address, Referal source, Customer PO, Invoice Memo, Salesperson
- Sales reports incluce $Sales, Qty, Gross Profit & margin by most of the above fields
- Transactions by day, week, quarter year and running over all prior year data for use in comparisons
These fields can all be accessed in the one report covering elements like the Type or location of customers v the type of product, brands v the Salesperson selling them.
Some examples of how clients us BI4Cloud to solve a common problem - Which Customers have stopped buying
Most of these reports are prebuilt and are available as soon as you connect up BI4Cloud. All details and a 14 day free trial are available at bi4cloud.com.
I hope this helps
Jennifer Kelly CA
02 8011 1511
BI4cloud
- DanT7 years agoContributing Cover User
Hi Jennifer_Kelly,
Thanks for the suggestion, unfortunately that means we have to go and spend additional $$ for functionality that should be available out of the box. These 3rd party ad-ons are extremely expensive if you're only requiring 1 thing like I do in this case. It may be justifiable for @okcorale however for a small business it's not.
$17/mo for me to get access to 1 field in a report that I might run a few times a month doesn't stack up.
Just further frustration and questions as to why we bothered moving away from Quickbooks which seemed to offer a lot more functionality.
Thanks
Related Content
- 10 months ago
- 10 months ago