Forum Discussion

RhiannPhillips's avatar
1 year ago

Job Report

 

Hi,

 

I am trying to run a report to show all transactions without a job number allocated. 

 

Is this possible?

9 Replies

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    1 year ago

    Hi TAGCRU,

     

    Filtering the job activity report to show only transactions without a job code is a breeze! Here’s how you can do it:

    • Open the Job Activity Report
    • Find the option to insert or modify the report
    • In the insert/modify settings, you can choose to hide specific columns. Locate the columns for Job No. and Job Name and hide them. This will remove these columns from the report view

     

    Check out the attached screenshot for a visual guide:

    Cheers,

    Princess

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    1 month ago

    Hi oscook,

     

    When the job reports aren't lining up, it usually comes down to how the transactions have been coded. In MYOB Business, you can run the Job Activity report and use Customise button to add job code/number column so you can see what each transaction's linked to. There isn't a way to remove that column, but after setting your date filters, you can use the drop down to expand the view and check the job codes. If the job name's showing blank, it means that line hasn't been assigned a job. It's worth opening those transactions and making sure each line has the correct job selected. If you're still having trouble tracking down the the right job report, you can reach out to our team on Live Chat via our virtual assistant, MOCA, or by submitting a support case via My Account and they'll a closer look with you.

     

    Cheers,

    Doreen

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    1 year ago

    Hi RhiannPhillips

     

    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

  • TAGCRU's avatar
    TAGCRU
    Contributing User
    1 year ago

    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_HD's avatar
    Earl_HD
    MYOB Moderator
    1 year ago

    Hi TAGCRU,

    To filter the Job Activity report to show only transactions without a job code, you can follow these steps:

     

    1. Open the Job Activity report.
    2. Look for the filter options available within the report settings.
    3. 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-Myob's avatar
    Evie-Myob
    Experienced Cover User
    1 year ago

    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_James's avatar
    Mike_James
    Ultimate Cover User
    1 year ago

    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?

  • MYOB Business Lite - I cannot find anywhere that produces reports with Job Codes or without.  I can add a column for "Job Name" but that does not consistently show the Job Name - I only have 3 Jobs in my file.

    It's a disaster when running Job reports and finding the reports don't agree.

    Can anyone help?

  • oscook's avatar
    oscook
    Member
    1 month ago

    Thanks Doreen.

    I can't see all those options in MYOB Business Lite in the Job Activity Report area but they are available in AccountRight
    MOCA was totally lost with this query.

     

     

    MYOB AccountRight

    MYOB Business Lite

     

     

     

     

     

     

    Seems MYOB doesn't think Lite users deserve the Job Exceptions capability.  Makes this a very expensive upgrade just to correct missed Job Codes or hours of checking every entry.

    I don't understand why they don't have an uncoded option in Lite under Select jobs

     

     

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.