Forum Discussion

DaveKC's avatar
DaveKC
Experienced Cover User
21 days 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

      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

        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?