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.

But now each product loads into excel on 2 lines with the product code/description on one line and the quantity etc on the next line.

 

Anyone know of a way to get it to revert just to all the data for each product to be shown on a single line?

 

Thanks!

    • 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?

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.