Forum Discussion

DaveKC's avatar
DaveKC
Experienced Cover User
2 months ago

Exporting Item List report to Excel

Hi All, We've just upgraded to Premier from Plus - in the past when exporting this report (and others) the inventory comes across on a single line making it easy to sort and combine with other data...
Mike_James's avatar
Mike_James
Ultimate Cover User
2 months ago

Hi DaveKC , do you have multiple locations enabled?

  • DaveKC's avatar
    DaveKC
    Experienced Cover User
    2 months ago

    Hi Mike_James yes we do…..

  • DaveKC's avatar
    DaveKC
    Experienced Cover User
    2 months ago

    Sorry Mike_James to be a pain but just following up on this one - any ideas?

    Thanks!

    • Mike_James's avatar
      Mike_James
      Ultimate Cover User
      2 months ago

      Hi DaveKC , if this is the item list summary, because you are using multiple locations, it has to be grouped either by item or by location. Neither of those will show each product as a single line. 

       

      If this isn't the issue, can you post a PDF of a part of your report, with costs blurred?

      • DaveKC's avatar
        DaveKC
        Experienced Cover User
        2 months ago

        Hi Mike,

        Thanks for your reply!

        And yes that is my issue - I'm trying to compare current stock levels (total, regardless of location) with sales over the previous 6 months (or whatever time frame). I've been able to run an inventory report and a stock report, export both to Excel and just 'merge' them reasonably easily.

        With over 1500 SKUs I'de prefer not to need to manually enter the stock level for each item.

        Any ideas?

        Thank you!

Looking for something else?

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

Community home

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