Forum Discussion

Aileen_6300's avatar
Aileen_6300
Experienced Cover User
4 years ago
Solved

Customise reports

Hi there - is there a way to customise reports.  I would like a list of Creditor Invoices which shows what expense codes were used to input the invoice and the Job codes used? Any help would be much...
  • Steven_M's avatar
    Steven_M
    4 years ago

    Hi Aileen_6300 

     

    The Purchases [Supplier Detail] report should be able to produce that information - Reports>>Purchases>>Supplier.

     

    This report will list the Item/Account that was used on the purchase. You can even insert the job number (or name) through the Insert/Modify>>Show Hide option.

Aileen_6300's avatar
Aileen_6300
Experienced Cover User
4 years ago

Hi again Steven_M.  Yes, that was very helpful.  I seem to have almost all I want in the report now, but is there a way to get the Expense Account name included please - I can't seem to find it in the show/hide list.  I can get the Item/Acct (i.e. Expense Code number) but would like the name instead as it's more meaningful to others who are not familiar with all the numbers.  I've changed the margins to suit but the footer (even though I click and drag down when icon turns to a double sided arrow) doesn't seem to stay down.  Is there a way around this please?

Steven_M's avatar
Steven_M
Former Staff
4 years ago

Hi Aileen_6300 

 

The Purchases [Supplier Detail] report would not show the account name, only the account number. I'm not familiar with any purchase-based reports that will list the account's name rather than the number. 


The only way I could see you getting that number would be if you also run the Account List report then sent that report and the Purchase report to Excel. Once in Excel, you would use a Lookup function to pull that account name onto that report.

  • Aileen_6300's avatar
    Aileen_6300
    Experienced Cover User
    4 years ago

    Steven_M  - now we're getting a little out of my league.

    I've exported to Excel however my VLookup function is only showing as the formula itself, not the result of the formula.  I seem to have a lot of trouble when I export to Excel in that I have to reformat columns to show as numbers and not text, then use AutoSum function to get my totals if I need to delete anything etc.  In this case, is there a better work around?  I've clicked the Calculate Now button to no avail - I'm still seeing =Vlookup(L13,AccountName,2,False) and not the result.  Also, can I use an If function so that the lines that don't have the code in them stay blank?  Thanks so much if you're able to help.

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User
      4 years ago

      Hi Aileen_6300 , if all you see is the formula, then the column is probably formatted as text.  To see the formula result, you need to format the column as eg number before adding any formulae. 

       

      Usually you need to delete that column and start over.

       

      Wrapping the formula in an if statement is one way to hide zeroes, or you can extend the number format code. These codes have 4 parts separated by semicolons, these are positive, negative,  zero and text. So for example 0.00;-0.00;;@ would also hide the zero. (To see the format code, after selecting your format, select the custom option and edit the code there).

      • Aileen_6300's avatar
        Aileen_6300
        Experienced Cover User
        4 years ago

        Mike_James thank you - yes, I deleted the column and formatted as suggested and all good.

        For my future reference: is there a way to ensure when exporting to Excel from MYOB that the data comes across as numbers and not text... it gets a bit frustrating having to reformat everything when I do my reports?

        I really appreciate your input.

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.