Forum Discussion

Knight16's avatar
Knight16
Experienced Cover User
4 years ago

Job List Report

Hi   Are we able to sort a Job list report?  I can show/hide columns and sort the columns in to a particular order but I can't sort the information, for example, by Linked Customer Name.   If I e...
  • Jeff_AccAddons's avatar
    4 years ago

    Hi Knight16 

     

    Its possible to create the report you want using either the MYOB for Excel add-in or OdataLink

     

    Your can do that by quering all the jobs data into a single flat table including the linked customer field and then sort by that field. There are not blanks in the data when extracted

     

    Once created you just need to refresh that report in Excel without opening MYOB at all

     

    Your welcome to private message me if you require assistance going down that path

     

    Jeff