Forum Discussion
- Shella_AMYOB Moderator
Absolutely! You can run a Job Activity Summary and Detail report and filter it to show only transactions without a job number. You can proceed by clicking Insert/Modify, then choosing to hide the job number under the Show/Hide option. See this helpful article about customizing reports for more details. If you need more help, don't hesitate to ask!
Kind regards,
Shella
- TAGCRUContributing User
Shella_ARhiannPhillipsCan I pick up on this thread and ask you HOW you filter the Job Activity report to show only transactions without a job code?
- Earl_HDMYOB Moderator
Hi TAGCRU,
To filter the Job Activity report to show only transactions without a job code, you can follow these steps:- Open the Job Activity report.
- Look for the filter options available within the report settings.
- Apply a filter to exclude transactions that have a job code assigned. This can typically be done by setting the job code filter to "None" or by using a similar option that excludes any specific job codes.
If the report does not have a direct filter for transactions without a job code, you may need to export the report data to a spreadsheet application like Excel. Once exported, you can manually filter out the transactions that have job codes.
You can also visit this help page for more information: Jobs reports
I hope this helps!
Regards,
Earl
- Evie-MyobExperienced Cover User
There is no such animal that exists in any of the MYOB reports that allows you to produce a report showing what transactions are missing a job code.
You have to do this manually by running a transactions report or general ledger report showing all details. Make sure you have the job code showing on the report (by going to modify report settings and add the job code column). Then export to excel and apply a filter or pivot table etc to the data.
You would think that since the launch of MYOB in the 1980s they would have figured out how to put this as a filter option on the reports but no... instead you need to waste hours mucking around with data exports so you can do validity checks on data. VERY ANOYING especially when job codes are vital to some business's operations/existence.
Fundamental feature ignored. They (MYOB) will blame the user saying we haven't voted for it or not enough votes...
- Mike_JamesUltimate Cover User
Hi Evie-Myob , whilst I agree with running GL detail reports to review for missing job numbers, for AccountRight, select Reports index, then Accounts, then Job sub-section. Don't the two job exception reports show which transactions are missing a job code?
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.